Date: Wed, 8 Apr 2009 17:50:13 -0400
Reply-To: Dave Brewer <david.brewer@UC.EDU>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Dave Brewer <david.brewer@UC.EDU>
Subject: Re: How to read a value coming in as Oct 3,
2007 and create a SAS date
On Wed, 8 Apr 2009 10:36:23 -0700, Jack Hamilton <jfh@STANFORDALUMNI.ORG>
wrote:
>Try the aANYDTDTE informat,
<http://support.sas.com/onlinedoc/913/getDoc/en/lrdict.hlp/a002605538.htm
> >.
>
>--
>Jack Hamilton
>jfh@alumni.stanford.org
>Videtis illam spirare libertatis auram
>
>
>
>
>
>On Apr 8, 2009, at 10:14 am, Dave Brewer wrote:
>
>> Hi,
>>
>> I am processing a csv file and need to know if there is an informat to
>> process a variable containing values "Oct 3, 2007", "Sep 25, 2007",
>> etc.
>> (quotes are not part of the data. I need to create a SAS date from
>> this
>> value.
>>
>> I suppose I can read the data in as a $11 and parse it. If I did
>> that, how
>> would I create a SAS date when the month is not a number (Oct as
>> opposed to
>> 10)?
>>
>> Thanks for your help.
>> Dave
Jack,
your answer does not work.
Also, my day in the date field is always two digits (ex, Apr 08, 2009).
Thanks anyhow
Dave
|