topic date format in New SAS User

date format

Smitha9 — Wed, 09 Dec 2020 16:11:34 GMT

Hi,

I have a two different date formats:

07SEP03:00:00:00

2009-08-06 00:00:00.000

I want to change it to:

09/07/2020

08/06/2009

can I do it in sas?

thanks in advance.

Re: date format

ballardw — Wed, 09 Dec 2020 16:28:49 GMT

Neither of those is a date. Those are DATETIME values.

If they are an actual SAS datetime, meaning numeric with a datetime format of some sort attached then it would be easy to either extract the date part of the value using the DATEPART function and assign the MMDDYY format.

But you need to provide data step code of what you actually have.

Instructions here: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712 will show how to turn an existing SAS data set into data step code that can be pasted into a forum code box using the </> icon or attached as text to show exactly what you have and that we can test code against.

Re: date format

Reeza — Wed, 09 Dec 2020 16:51:30 GMT

Try this:

data want;
set have;
x = input(variable, anydtdtm.);
y = datepart(x);
format y mmddyy10.;
run;