topic Question on Date Macro in SAS Procedures

Question on Date Macro

vomer — Tue, 07 May 2013 16:09:43 GMT

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__ — Tue, 07 May 2013 16:16:46 GMT

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

vomer — Wed, 08 May 2013 13:46:40 GMT

Thank you!

Tom — Wed, 08 May 2013 15:18:20 GMT

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 — Wed, 05 Jun 2013 12:38:25 GMT

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