Formatting a Date

[Wickywick]

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 · Accepted solution]

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]

thank you Art, it worked. much appreciated.