topic Re: How to get the end of previous month in a macro variable using %sysfunc? in SAS Programming

How to get the end of previous month in a macro variable using %sysfunc?

renjithr — Fri, 11 Nov 2016 20:21:25 GMT

Hi,

I am trying to get the end of previoius month using this macro, but guess I am missing something.

%let date=%sysfunc(intnx(month, %sysfunc(today()),-1,'e'), yymmdd10.);
%put &date.;

Please help.

Re: How to get the end of previous month in a macro variable using %sysfunc?

LinusH — Fri, 11 Nov 2016 20:23:47 GMT

What do you get?

Re: How to get the end of previous month in a macro variable using %sysfunc?

renjithr — Fri, 11 Nov 2016 20:27:56 GMT

I get the below message:

67 %let date=%sysfunc(intnx(month, %sysfunc(today()),-1,'e'), yymmdd10.);
WARNING: Argument 4 to function INTNX referenced by the %SYSFUNC or %QSYSFUNC macro function
is out of range.
NOTE: Mathematical operations could not be performed during %SYSFUNC function execution. The
result of the operations have been set to a missing value.
68 %put &date.;

Not sure what I need to do or missing:(

Re: How to get the end of previous month in a macro variable using %sysfunc?

Shmuel — Fri, 11 Nov 2016 20:44:00 GMT

Without %sysfunc you can calculate date with data step inside the macro program, just as:

data _NULL_;

date = today() - day(today());

call symput('date', left(date));

run;

with %sysfunc,you can try:

%let date = %sysfunc( today() - day(today()) );

Re: How to get the end of previous month in a macro variable using %sysfunc?

data_null__ — Fri, 11 Nov 2016 21:26:43 GMT

Get rid of the quote E not 'E'

Re: How to get the end of previous month in a macro variable using %sysfunc?

renjithr — Fri, 11 Nov 2016 21:28:53 GMT

Thank you!

Re: How to get the end of previous month in a macro variable using %sysfunc?

Ravikumarkummari — Mon, 14 Nov 2016 06:43:09 GMT

%let date=%sysfunc(intnx(month, %sysfunc(today()),-1,e), yymmdd10.);
%put &date.;

Just remove the single quotation markes from e