topic Re: Month no as a two digit value in SAS Enterprise Guide

Month no as a two digit value

madara155 — Mon, 04 Jul 2022 07:31:51 GMT

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 — Mon, 04 Jul 2022 07:43:40 GMT

Try this

%let Date_selected = 01Feb2022;

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

%put &m.;

andreas_lds — Mon, 04 Jul 2022 08:29:12 GMT

Why call symputx?

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

madara155 — Mon, 04 Jul 2022 23:33:02 GMT

Thank you very much 🙏 You saved my life