SAS Date MMM-YY

[KevinC_]

Hello Everyone,

I am trying to format a SAS date from MMMYY to MMM-YY  (i.e. OCT12 to OCT-12).

This is the code.  I can't figure out how to add a - between the month and the year.

Thank you for input you may have!

proc  format ;

picture fmt(default=5)

other='%b%y'(datatype=date);

run;

data _null_;

a=23234;

format a fmt.;

put a= ;

run;

[Linlin · Accepted solution]

Hi,

proc  format ;

picture fmt(default=6)

other='%b-%y'(datatype=date);

run;

data want;

a=23234;

format a fmt.;

proc print;run;

Message was edited by:Linlin

[KevinC_]

Hi Linlin,

Thank you very much for your reply and suggestions!  I really learned something new today.

Thank you guys!!

[Tom]

Just include the hyphen in the picture format text. You might also want to look at the built in format NLDATEYM.

proc  format ;

  picture fmtA(default=5) other='%b%y'(datatype=date);

  picture fmtB(default=6) other='%b-%y'(datatype=date);

run;

data _null_;

  a='13OCT2012'd ;

  put a= date9. / a fmtA. / a fmtB. / a  nldateym6. ;

run;

a=13OCT2012

OCT12

OCT-12

Oct 12

[KevinC_]

Tom,

That worked beautifully!  I really appreciate your input and suggestions.  That was awesome!!

Thank you again