topic Re: MOD in macro error in SAS Programming

MOD in macro error

hhchenfx — Tue, 27 Mar 2018 17:04:55 GMT

Hi Everyone,

I run a macro and would like to do proc copy whenever the count is even number.

I received error notice and am not sure how to fix it.

NOTE: %INCLUDE (level 1) ending.
ERROR: Required operator not found in expression: MOD(&GROUP,2)=0
ERROR: The macro OUTER_LOOP will stop executing.

Any help is very appreciated.

HHCFX

%MACRO OUTER_LOOP;
%DO GROUP=1 %TO &MAX_GROUP;
... Mycode

 %include "C:\mysas_code.sas" /lrecl=500;

	*export subsample of final file;
	%if MOD(&GROUP,2)=0 %then %do;
	data F2_&group; set F2; run;
	proc copy in=work out=myfolder; select F2_&group;run;
	%end;
%END;

%MEND;

%OUTER_LOOP; run;

Re: MOD in macro error

novinosrin — Tue, 27 Mar 2018 17:14:06 GMT

a quick look tells me you need %sysfunc to invoke sas functions

%MACRO OUTER_LOOP;
%DO GROUP=1 %TO &MAX_GROUP;
... Mycode
 %include "C:\mysas_code.sas" /lrecl=500;
	*export subsample of final file;
	%if %sysfunc(MOD(&GROUP,2)=0 )%then %do;
	data F2_&group; set F2; run;
	proc copy in=work out=myfolder; select F2_&group;run;
	%end;
%END;

%MEND;

%OUTER_LOOP; run;

Re: MOD in macro error

Astounding — Tue, 27 Mar 2018 17:31:56 GMT

Alternatively, you could take advantage of this combination. %IF always applies %EVAL, and %EVAL performs integer arithmetic. So you could code:

%if &group = &group / 2 * 2 %then %do;

Re: MOD in macro error

hhchenfx — Tue, 27 Mar 2018 22:54:07 GMT

Thanks a lot!

It works perfectly.