macro function question

[swimmer]

Hi,

I have following code.

%let m = 0;

%let cal_month = %eval(intnx('month', &min_monthdate, &m));

SAS gave me an error message of

ERROR: Required operator not found in expression: intnx('month',        15096, 0)

How should I fix it? Thank you.

[stat_sas]

let cal_month = %eval(intnx('month', "&min_monthdate"d, &m));

[swimmer]

Thank you for the reply, but I got the same error.

ERROR: Required operator not found in expression: intnx('month', "       15096"d, 0)

[Astounding · Accepted solution]

Macro language does not understand how to use INTNX.  You can force it to understand by adding %SYSFUNC.  In that case the quotes around 'month' disappear (macro language assumes that month is a character string and not a reference to a variable).  And there is no need for %EVAL since INTNX returns an integer.

%let cal_month = %sysfunc(intnx(month, &min_monthdate, &m));

[swimmer]

Thank you so much! It works!