topic Re: Get day and abbreviated month of a date (e.g. 2 Nov) in SAS Programming

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

ywon111 — Tue, 02 Nov 2021 09:21:42 GMT

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.));

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

PeterClemmensen — Tue, 02 Nov 2021 09:29:47 GMT

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

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

ywon111 — Tue, 02 Nov 2021 09:47:28 GMT

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

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

PeterClemmensen — Tue, 02 Nov 2021 09:53:16 GMT

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

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

ErikLund_Jensen — Tue, 02 Nov 2021 10:37:18 GMT

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

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

Kurt_Bremser — Tue, 02 Nov 2021 10:51:59 GMT

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.

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

ywon111 — Tue, 02 Nov 2021 10:54:02 GMT

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

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

ErikLund_Jensen — Tue, 02 Nov 2021 10:55:31 GMT

Hi @ywon111

So you actually want 10 as day?

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

Kurt_Bremser — Tue, 02 Nov 2021 11:25:37 GMT

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

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

ywon111 — Tue, 02 Nov 2021 22:37:45 GMT

Thanks, that's exactly what I needed.