Sysfunc with intnx

[PatrykSAS]

Hello

I want to refer to a specific table from the previous month. The tables have the following name structure: MY_TABLE_&DATE (in yymmn6. format) like LIB.MY_TABLE_202102 or LIB.MY_TABLE_202103 etc

Below is code that I've already done but It doesn't work

%let period=intnx("month",date(),-1,"same");
data TEST;
set LIB.MY_TABLE_%sysfunc(&period.,yymmn6.);
run;

[PaigeMiller]

No quotes or double-quotes inside of %SYSFUNC, these are not needed and wrong.

%let period=%sysfunc(intnx(month,date(),-1,same));
%let period=%sysfunc(putn(&period,yymmn6.));
data TEST;
    set LIB.MY_TABLE_.
run;

[PatrykSAS]

Still got errors
ERROR: Required operator not found in expression: date()
ERROR: Argument 2 to function INTNX referenced by the %SYSFUNC or %QSYSFUNC macro function is not a number.
ERROR: Invalid arguments detected in %SYSCALL, %SYSFUNC, or %QSYSFUNC argument list. Execution of %SYSCALL statement or %SYSFUNC or %QSYSFUNC function reference is terminated.

[Tom · Accepted solution]

Everything is text to the macro processor.  So if you add quotes around constant text strings they quotes are part of the string.

Each SAS function you want to use in macro code needs to be wrapped in its own %SYSFUNC() macro function call.

%let period=%sysfunc(intnx(month,%sysfunc(date()),-1),yymmn6.);
data TEST;
  set LIB.MY_TABLE_&period ;
run;

[PatrykSAS]

Thanks Tom, it works fine. I get it now