Question on Date Macro

[vomer]

Hi there, I would like some help with the following macro:

%let dt = %SYSFUNC(today(),MONYY.);

This outputs the result: MAY13

How can this code be modified to show the previous month? i.e. APR13?

Secondly, how can I make it look a bit different? Let's say like: April 2013

Thanks!

[data_null__ · Accepted solution]

17         %let dt = %sysfunc(intnx(MONTH,%SYSFUNC(today()),-1),MONYY.);
18         %put &=dt;
DT=APR13

[vomer]

Thank you!

[Tom]

I do not know of a single format to get "April 2013" output.  I think you will need to use two function calls.

%let dt = %sysfunc(intnx(MONTH,%SYSFUNC(today()),-1));

%let dt = %sysfunc(putn(&dt,monname.)) %sysfunc(putn(&dt,year.));

[ChrisNZ]

%let x=%sysfunc(nldate('01dec2013'd,%nrstr(%B %Y)));
%put x=&x;
x=December 2013