Month no as a two digit value

[madara155]

Hi

I have a SAS date as a macro variable as follows:

%let Date_selected = 01Feb2022

I want to extract the month as a two digit no from this.

(eg: FEB => month_no = 02,

       Mar => month_no = 03,

       Apr => month_no = 04

etc).

With SYMPUTX I can get the month as a digit but not in 2 digit format.

call symputx("month_no",put("&Date_selected"d,month.)); /*this gives month_no = 2*/

Can someone help me with this?

Thanks

[PeterClemmensen]

Try this

%let Date_selected = 01Feb2022;

data _null_;
   m = put(month("&Date_selected"d), z2.);
   call symputx('m', m);
run;

%put &m.;

[andreas_lds · Accepted solution]

Why call symputx?

%let Date_selected = 01Feb2022;
%let m = %sysfunc(month("&date_selected."d), z2.);

[madara155]

Thank you very much 🙏 You saved my life