topic Re: Date Format in SAS Programming

Date Format

sallyjo — Fri, 28 Jun 2019 13:01:13 GMT

Hi, does anyone know how to format a SAS Date as MonDDYYYY, like JAN012018?

Re: Date Format

PeterClemmensen — Fri, 28 Jun 2019 13:30:54 GMT

Not sure if there is one 'out of the box', but you can roll out your own like this

proc format; 
  picture dtfmt (default=9)
    low - high = '%b%D%Y' (datatype=date)
  ;
run;

data test;
    date='01jan2018'd;
    format date dtfmt.;
run;

Re: Date Format

sallyjo — Fri, 28 Jun 2019 13:47:19 GMT

Thanks! How do I put a space between each, so it looks like Mon DD YYYY, JAN 01 2018?

Re: Date Format

PeterClemmensen — Fri, 28 Jun 2019 13:48:49 GMT

no problem 🙂 Change the length from 9 to 11 and add the spaces like this

proc format; 
  picture dtfmt (default=11)
    low - high = '%b %D %Y' (datatype=date)
  ;
run;

data test;
    date='01jan2018'd;
    format date dtfmt.;
run;

Re: Date Format

sallyjo — Fri, 28 Jun 2019 13:52:19 GMT

Thanks!!!!

Re: Date Format

PeterClemmensen — Fri, 28 Jun 2019 14:01:47 GMT

Anytime, glad to help 🙂 Please remember to mark the appropriate answer as an accepted solution. This helps future users navigate the community

Re: Date Format

ballardw — Fri, 28 Jun 2019 22:45:40 GMT

@sallyjo wrote:
Thanks! How do I put a space between each, so it looks like Mon DD YYYY, JAN 01 2018?

There is the SAS supplied WORDDATE12. format that displays as Jan 1, 2018 if interested. Wider widths such as WORDDATE18. spell out the month to January 1, 2018. Of course if you don't want a comma this isn't the format for you.

Re: Date Format

sallyjo — Fri, 28 Jun 2019 18:27:47 GMT

Thanks!