topic macro function question in SAS Programming

macro function question

swimmer — Wed, 13 Aug 2014 17:29:51 GMT

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.

Re: macro function question

stat_sas — Wed, 13 Aug 2014 17:38:22 GMT

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

Re: macro function question

swimmer — Wed, 13 Aug 2014 17:41:35 GMT

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

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

Re: macro function question

Astounding — Wed, 13 Aug 2014 17:44:22 GMT

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

Re: macro function question

swimmer — Wed, 13 Aug 2014 17:46:39 GMT

Thank you so much! It works!