topic creating a macro of month names in SAS Programming

creating a macro of month names

mona4u — Wed, 23 May 2018 16:13:29 GMT

Hi All,

I'm trying to create macros that create month names

l need the macro to be able to create the exact last month even though if it last year.

last time I created this macro to create last month # by the macro below but I also need the month name too

%let lastmonth1=%sysfunc(month(%sysfunc(intnx(month,%sysfunc(today()),-1,s))));

%put &lastmonth1;

Re: creating a macro of month names

Reeza — Wed, 23 May 2018 16:16:39 GMT

Use the MONNAME. format in the SYSFUNC() as the second parameter. See the doucmentstion for INTNX and SYSFUNC so you can see how to use it.

@mona4u wrote:

Hi All,

I'm trying to create macros that create month names

l need the macro to be able to create the exact last month even though if it last year.

last time I created this macro to create last month # by the macro below but I also need the month name too

%let lastmonth1=%sysfunc(month(%sysfunc(intnx(month,%sysfunc(today()),-1,s))));

%put &lastmonth1;

Re: creating a macro of month names

Tom — Wed, 23 May 2018 16:18:34 GMT

Use the WORDDAT format and parse out the name of the month.

%let lastmonth1=%scan(%sysfunc(intnx(month,%sysfunc(today()),-1),worddat),1) ;

Re: creating a macro of month names

mona4u — Wed, 23 May 2018 16:23:26 GMT

didn't work

Re: creating a macro of month names

Tom — Thu, 24 May 2018 01:02:18 GMT

@mona4u wrote:

didn't work

Two problems. (1) the format name is really WORDDATE (not sure when SAS started creating format names with more than 7 characters?). (2) The WORDDATE (and also the MONNAME) format add leading spaces which seem to really confuse the %SCAN() function when trying to process in single nested call.

So use %Qsysfunc() instead to quote the comma and leading spaces. Then the %SCAN() function works.

%let lastmonth=%scan(%qsysfunc(intnx(month,&today,-1),worddate),1);

Re: creating a macro of month names

mona4u — Thu, 24 May 2018 15:03:07 GMT

@Tom wrote:
@mona4u wrote:
didn't work
Two problems. (1) the format name is really WORDDATE (not sure when SAS started creating format names with more than 7 characters?). (2) The WORDDATE (and also the MONNAME) format add leading spaces which seem to really confuse the %SCAN() function when trying to process in single nested call.

So use %Qsysfunc() instead to quote the comma and leading spaces. Then the %SCAN() function works.
%let lastmonth=%scan(%qsysfunc(intnx(month,&today,-1),worddate),1);
this is what I tried and it works
%let lastmonthn1=%sysfunc(intnx(month,%sysfunc(today()),-1),MONNAME.);