topic Re: Current Month Macro with Zero? in SAS Programming

Current Month Macro with Zero?

IgawaKei29 — Tue, 23 Jul 2019 12:01:20 GMT

So I am trying to make a where statement that is dynamic however I am not 100% sure how to place a zero in front of the system month if it a single digit (i.e. 1, 2, 3, 4).

%let sysmonth= %sysfunc(month("&sysdate"d));
%let sysyear= %sysfunc(year("&sysdate"d));


where Year in ("&sysyear") and Month in ("&sysmonth")

I wasn't sure if you could do a CAT type function or not within the sysfunc

Re: Current Month Macro with Zero?

novinosrin — Tue, 23 Jul 2019 12:08:28 GMT

Are you asking for this?

%let sysmonth= %sysfunc(month("&sysdate"d),z2.);
%let sysyear= %sysfunc(year("&sysdate"d));

%put &=sysmonth  &=sysyear;

Re: Current Month Macro with Zero?

IgawaKei29 — Tue, 23 Jul 2019 12:10:14 GMT

Thanks so much! I kept trying to put something in front of the %sysfunc. I will be adding this one to my code library.

Re: Current Month Macro with Zero?

Tom — Tue, 23 Jul 2019 13:55:33 GMT

@IgawaKei29 wrote:
Thanks so much! I kept trying to put something in front of the %sysfunc. I will be adding this one to my code library.

Don't bother. Just remember how to use the Z format.