topic Re: "not in" Statement does not work in Macro? in SAS Programming

"not in" Statement does not work in Macro?

MikeTurner — Wed, 17 Oct 2012 03:37:04 GMT

I defined one macro variable VAR, then I wrote the codes as below;

%if %UPCASE(&VAR) NOT IN ("ABC", "XYZ") %THEN %DO;

BLABLABLA;

%END;

It seems incorrect, is there one statement in MACRO equal to "not in" or "in" statement?

Thanks in advance.

Linlin — Wed, 17 Oct 2012 03:47:51 GMT

you need to use option:

example:

options minoperator;

%if &state in (NY NJ PA) %then %let &region = %eval(&region + 1);

MikeTurner — Wed, 17 Oct 2012 03:54:39 GMT

Got it. Thanks

art297 — Wed, 17 Oct 2012 04:05:17 GMT

Actually, since you are using macro code, I think you will also need a macro option as well:

%let var=ABC;

options minoperator;

%macro test/mindelimiter=',';

%if not(%upcase(&VAR) in (ABC,XYZ)) %THEN %DO;

%put met condition;

%END;

%else %do;

%put did not meet condition;

%end;

%mend test;

%test