topic SAS Date MMM-YY in SAS Procedures

SAS Date MMM-YY

KevinC_ — Sat, 13 Oct 2012 12:36:52 GMT

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;

Re: SAS Date MMM-YY

Linlin — Sat, 13 Oct 2012 13:28:06 GMT

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

Re: SAS Date MMM-YY

Tom — Sat, 13 Oct 2012 14:26:28 GMT

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

Re: SAS Date MMM-YY

KevinC_ — Sat, 13 Oct 2012 14:38:15 GMT

Tom,

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

Thank you again

Re: SAS Date MMM-YY

KevinC_ — Sat, 13 Oct 2012 14:40:20 GMT

Hi Linlin,

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

Thank you guys!!