Current Month Macro with Zero?

[IgawaKei29]

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

[novinosrin · Accepted solution]

Are you asking for this?

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

%put &=sysmonth  &=sysyear;

[IgawaKei29]

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

[Tom]

---

@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.