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

[renjithr]

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.

[LinusH]

What do you get?

[renjithr]

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:(

[Shmuel]

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

[data_null__]

Get rid of the quote E not 'E'

[renjithr · Accepted solution]

Thank you!

[Ravikumarkummari]

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

Just remove the single quotation markes from e