Get day and abbreviated month of a date (e.g. 2 Nov)

[ywon111]

I have a macro to get the latest month as below and trying to use this to get day and month.

%let Latest_month = %sysfunc(intnx(month, %sysfunc(today()), -1, END), date9.);;

This is what I have tried:

%let day = %sysfunc(month("&Latest_month"d),DAYw.);
%let sysmonth= %sysfunc(put(month("&Latest_month "d),monname3.));

[PeterClemmensen]

I'm not sure what your desired result is here?

[ywon111]

Latest_month is a macro to get the previous month (e.g. 31OCT2021) and I am trying to get the day (31) and abbreviated month (Oct) based on this macro,.

[PeterClemmensen · Accepted solution]

Try this

%let Latest_month = %sysfunc(intnx(month, %sysfunc(today()), -1, END), date9.);

%let day = %sysfunc(month("&Latest_month"d));
%let month = %sysfunc(putn("&Latest_month"d, monname3.));

%put &day.;
%put &month.;

[ErikLund_Jensen]

Hi @ywon111 

Try this. The main difference is that day and not month is assigned to the &day macro variable. 

%put %sysfunc(propcase(%sysfunc(putn(&Latest_month,date5.))));
%let day = %sysfunc(day(&Latest_month));
%let month = %sysfunc(putn(&Latest_month, monname3.));

%put &day.;
%put &month.;

[ywon111]

Thanks, all worked great.

Adding this into title for proc report also and looks like when export to excel then the space in between day, month and year disappeared (e.g. 31OCT2021) instead of 31 OCT 2021.

Any trick to fix this?

This is what I have

Title1 j=left "Graph1 blah blah blah as at &day &month &year";
proc report data=want
...

[Kurt_Bremser]

Please post your report code, from ODS EXCEL to ODS EXCEL CLOSE.

[Kurt_Bremser]

Is this for display purposes?

If yes, do this:

%let Latest_month = %sysfunc(intnx(month,%sysfunc(today()),-1,e));
%let day = %sysfunc(putn(&Latest_month.,day2.));
%let sysmonth = %sysfunc(putn(&Latest_month.,monname3.));
%put &=day. &=sysmonth.;

Log:

 69         %let Latest_month = %sysfunc(intnx(month,%sysfunc(today()),-1,e));
 70         %let day = %sysfunc(putn(&Latest_month.,day2.));
 71         %let sysmonth = %sysfunc(putn(&Latest_month.,monname3.));
 72         %put &=day. &=sysmonth.;
 DAY=31 SYSMONTH=Oct

Note that macro variables used in calculations need no formats, see Maxim 28.

[ywon111]

Thanks, that's exactly what I needed.

[ErikLund_Jensen]

Hi @ywon111 

So you actually want 10 as day?