topic Re: Sysfunc with intnx in SAS Programming

Sysfunc with intnx

PatrykSAS — Wed, 10 Mar 2021 13:33:23 GMT

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;

Re: Sysfunc with intnx

PaigeMiller — Wed, 10 Mar 2021 13:39:13 GMT

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_&period;
run;

Re: Sysfunc with intnx

Tom — Wed, 10 Mar 2021 13:44:01 GMT

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;

Re: Sysfunc with intnx

PatrykSAS — Wed, 10 Mar 2021 13:47:46 GMT

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.

Re: Sysfunc with intnx

PatrykSAS — Wed, 10 Mar 2021 13:50:03 GMT

Thanks Tom, it works fine. I get it now