SAS Date Format Quesiton

[buechler66]

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]

Like this?

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

[buechler66]

Oh so close! Just missing the -

MAR-2020

Any option to get the dash - in there?

[PeterClemmensen]

@ChrisNZ said it..

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

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

[ChrisNZ]

Yes you can.

Create a picture format.