Incorrect macro logic

scify — Tue, 15 Jul 2014 15:59:06 GMT

I have a macro that is looping through datafiles from different years for a proc mean. I want it to run with a different var statement depending on which year it is currently looping through. At the moment, my code looks like this:

%macro varcheck;

%do i = &yrmin %to &yrmax;

%let yr = %substr(&i.,3,2);

proc means n mean median max data=&lib..&stem.&yr.;

%if 2000 <= &i <= 2011 %then

vars variables;

%else %if 2012 <= &i <= 2013 %then

vars other variables;

;

run;

%end;

%mend varcheck;

%varcheck;

When I run the code, however, the program returns the following on years 2012 and 2013:

SYMBOLGEN: Macro variable I resolves to 2012

MLOGIC(VARCHECK): %IF condition 2000 <= &i <= 2011 is TRUE

It works if I replace the if conditions with &i = 2000 or &i = 2001 etc., but that can get pretty cumbersome. Is there a way to get this to resolve correctly, or am I stuck with the clunky way?

Re: Incorrect macro logic

Reeza — Tue, 15 Jul 2014 16:04:13 GMT

THIS <= &i <= does not work as expected in macro language.

Change it to

%if 2000 <= &i AND &i <= 2011 or some variation thereof.

topic Incorrect macro logic in SAS Programming

Incorrect macro logic

Re: Incorrect macro logic