"not in" Statement does not work in Macro?

[MikeTurner]

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 · Accepted solution]

you need to use option:

example:

options minoperator;

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

more detail at http://support.sas.com/documentation/cdl/en/mcrolref/61885/HTML/default/viewer.htm#a003092012.htm

[MikeTurner]

Got it. Thanks

[art297]

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