topic Re: Long SAS Date to Shorter Output Date in SAS Programming

Long SAS Date to Shorter Output Date

eer_seer — Mon, 22 Jan 2018 14:24:26 GMT

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 🙂

Re: Long SAS Date to Shorter Output Date

PaigeMiller — Mon, 22 Jan 2018 14:26:37 GMT

Use the DATE11. format.

Re: Long SAS Date to Shorter Output Date

Kurt_Bremser — Mon, 22 Jan 2018 14:30:38 GMT

Convert the datetime value to a date:

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

Re: Long SAS Date to Shorter Output Date

eer_seer — Mon, 22 Jan 2018 14:32:17 GMT

Perfect! Thank you so much!

Re: Long SAS Date to Shorter Output Date

Tom — Mon, 22 Jan 2018 18:01:20 GMT

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