Long SAS Date to Shorter Output Date

[eer_seer]

I have a column titled "Birth_Date" with long SAS date values.

The dates look like this: 01MAR1993:00:00:00

All I want is to convert those values to the following format: 01-MAR-1993.

So, long story short. I just want to convert the date to a different format. I've seen other solutions that are close, but I can't seem to get to the finish line on this one. Spare me the judgment please 🙂

[PaigeMiller]

Use the DATE11. format.

[Kurt_Bremser · Accepted solution]

Convert the datetime value to a date:

birth_date = datepart(birth_date);
format birth_date date11.;

[eer_seer]

Perfect!  Thank you so much!

[Tom]

You can use the DTDATE format to print just the date part of a datetime value, but it does not support printing the hyphens.

Or you could convert your datetime value (number of seconds) into a date value (number of days) and then use the DATE11. format.

287  data _null_;
288    dt='01MAR1993:00:00:00'dt;
289    date=datepart(dt);
290    put dt= dt datetime20. +1 dt dtdate9. ;
291    put date=  date date11. ;
292  run;

dt=1046563200   01MAR1993:00:00:00 01MAR1993
date=12113 01-MAR-1993