topic SAS Date Format Quesiton in SAS Programming

SAS Date Format Quesiton

buechler66 — Thu, 02 Apr 2020 21:12:39 GMT

Hi. Can I format an existing SAS Date variable to a format that looks like MON-YYYY (e.g. MAR-2020)?

If you can help I'd really appreciate it. Thanks.

PeterClemmensen — Thu, 02 Apr 2020 21:16:52 GMT

Like this?

data test;
   date = today();
   format date monyy7.;
run;

ChrisNZ — Thu, 02 Apr 2020 21:19:43 GMT

Yes you can.

buechler66 — Thu, 02 Apr 2020 21:21:08 GMT

Oh so close! Just missing the -

MAR-2020

Any option to get the dash - in there?

PeterClemmensen — Thu, 02 Apr 2020 21:24:02 GMT

@ChrisNZ said it..

proc format; 
  picture dtfmt (default=8)
    other = '%b-%Y' (datatype=date)
  ;
run;

data test;
   date = today();
   format date dtfmt.;
run;