topic Re: Reformatting of Date (DD-MMM-YYYY HH:MM) format in SAS Programming

Reformatting of Date (DD-MMM-YYYY HH:MM) format

1239 — Fri, 12 Nov 2021 07:10:39 GMT

Hi All,

How to change the date&time fromat from 09SEP21:00:00:00 to 09-SEP-2021 00:00 (DD-MMM-YYYY HH:MM). Please help.

Re: Reformatting of Date (DD-MMM-YYYY HH:MM) format

PeterClemmensen — Fri, 12 Nov 2021 07:22:50 GMT

I don't know of such a format out-the-box.

However, you can roll out your own format like this

proc format; 
  picture dtfmt (default=20)
    other = '%0d-%b-%Y %0H:%0M' (datatype = datetime)
  ;
run;

data _null_;
   dt = '09SEP2021 00:00:0'dt;
   put dt dtfmt.;
run;

Re: Reformatting of Date (DD-MMM-YYYY HH:MM) format

Tom — Fri, 12 Nov 2021 15:26:08 GMT

You mentioned formatting of dates, but your description of what you want is for DATETIME values (number of seconds) not DATE values (number of days).

Do any of the datetime values you need to display contain actual non-zero value for the time of day component? If not then why not just convert the values from seconds to days by using the DATEPART() function and then use the DATE11 format to display the dates in DD-MON-YYYY style?