ERROR: Macro function %INDEX has too many arguments.

michellel — Fri, 13 May 2016 20:35:17 GMT

Hi,

I have a question about defining macro. I included input file 1, input file 2, and year in a macro. When I ran the macro, it always showed a error that Macro function %INDEX has too many arguments. If I cut this macro into several piece macros, there would no problem to run each of those macros. Here is my macro. Thanks so much in advance for your help!

%macro index(in1,in2,yy);

data carr&yy;

set &in1;

if ...(some conditions here)...

then interest = 1;

else interest=0;

if interest;

run;

proc sql;

create table finder&yy as

select distinct id

from carr&yy;

quit;

proc sort data=&in2;

by id;

run;

data merged&yy;

merge finder&yy(in=a)

&in2(in=b);

by id;

if a and b;

if (year(DEATH_DT)~=&yy and MONS=12)or (year(DEATH_DT)=&yy and MONS=month(DEATH_DT) )

then ff=1;

else ff=0;

*if ff=1;

run;

%mend;

%index(raw.myfile1,raw.myfile2,2012);

Re: ERROR: Macro function %INDEX has too many arguments.

ballardw — Fri, 13 May 2016 21:00:16 GMT

%INDEX is a SAS supplied macro function. You can't use that name for your macros. Change the name to something else.

Re: ERROR: Macro function %INDEX has too many arguments.

michellel — Mon, 16 May 2016 15:31:13 GMT

Thanks ballardw. It works now.

topic ERROR: Macro function %INDEX has too many arguments. in SAS Data Management

ERROR: Macro function %INDEX has too many arguments.

Re: ERROR: Macro function %INDEX has too many arguments.

Re: ERROR: Macro function %INDEX has too many arguments.