topic Formatting a Date in SAS Procedures

Formatting a Date

Wickywick — Thu, 11 Aug 2011 03:50:30 GMT

Hi all,

In one of the tables I refer to, the date appears as 31MAR2012:00:00:00.

How do I drop the time component of this and get the date as '31MAR2012'?

Thank you

art297 — Thu, 11 Aug 2011 03:56:15 GMT

If the field is already a SAS date_time field, then you only have to refer to it with a function, namely:

date_you_want=datepart(whateverthedatetimefieldiscalled);

You also may want to add a format statement of the nature:

format date_you_want date9.

Of course, if the field is really only a string in a character variable, you would first have to input it using a datetime informat.

Wickywick — Thu, 11 Aug 2011 04:13:35 GMT

thank you Art, it worked. much appreciated.