topic Re: Date Format in SAS Procedures

Date Format

deleted_user — Wed, 05 Mar 2008 20:50:59 GMT

I am a new SAS user and was wondering how I would convert a date format that is 7FEB2008HH:MM:SS to 200802. Any help will be great! Thanks.

Re: Date Format

1162 — Wed, 05 Mar 2008 22:03:24 GMT

I'm not strong on date formats, but I came up with this suggestion:

I didn't see a built-in SAS date format that you could use, so maybe you can create a picture format using
[pre]
proc format library=work;
picture mydate low-high = '%Y0%m' (datatype=date);
run;
[/pre]

If the date is already in SAS as a date formated value (I think you missed a colon after the year), then you could just apply the picture format . . .
[pre]
data work.date;
format date_in mydate6.;
date_in = '7FEB2008:10:27:59'd;
run;
[/pre]

Then, if the date is literally what you've written, then I would select the date part from this text string and reformat that to the picture format.
[pre]
data work.date;
input date_txt $24.;
format date_new mydate6.;
date_new = input(scan(date_txt,1,"H"), date9.);
cards;
7FEB2008HH:MM:SS
;
run;
[/pre]

Re: Date Format

Bill — Thu, 06 Mar 2008 17:28:44 GMT

I don't think you need to use the picture method. It looks like yymm7. should work for you (untested)

wd

Re: Date Format

advoss — Thu, 06 Mar 2008 17:34:29 GMT

Do you want to create the datetime value to a new variable with just the date portion, or are you only interested in displaying the year/month portion of the datetime? If the latter, then you'll need to do the picture format as suggested by Christopher. If the former, then you can do something like:

justdate = datepart(dtvar);
format justdate yymmn6.;