topic Re: date in dd-mon-yyyy in SAS Programming

date in dd-mon-yyyy

dan999 — Tue, 26 Feb 2013 19:47:46 GMT

I'm using SAS 9.1. I want the date in the format 15-OCT-2012. I found a piece of code here that gets the year in a 2 digit format rather than 4 and I don't know how to change it.

proc format;

picture date9x other='%0d-%b-%0y' (datatype=date);

run;

data _null_;

call symputx('enddt',put(intnx('month',today(),-2,'end'),date9x.));

run;

%put enddt = &enddt.;

I get 31-DEC-12. I changed the last part to %Y and now I get 31-DEC-20.

How do I get 2012?

Re: date in dd-mon-yyyy

Haikuo — Tue, 26 Feb 2013 19:58:39 GMT

proc format;

picture date9x other='%0d-%b-%Y' (datatype=date);

run;

data _null_;

call symputx('enddt',put(intnx('month',today(),-2,'end'),date9x11.));

run;

%put enddt = &enddt.;

Haikuo

Re: date in dd-mon-yyyy

dan999 — Wed, 27 Feb 2013 19:22:29 GMT

That works. Thanks Haikuo.