topic Using "NOT IN" with macro code in SAS Programming

Using "NOT IN" with macro code

deleted_user — Tue, 24 Mar 2009 13:50:20 GMT

Hi all,
I was wondering is it possible to use "Not IN" in a conditional statement using the macro facility.

I have tried the code in a statement like this:
%IF &Variable NOT IN(Apples Oranges) %THEN %DO;
%IF (&Variable NOT IN Apples Oranges) % THEN %DO;
%IF (&Variable NOT IN (Apples Oranges)) %THEN %DO;

I have also tried quoting the variable and the list objects. Additionally, I have tried using commas as delimiters.

None of the above has run and all have given the error message in the log that "A character operand was found in the %EVAL function or %IF condition where a numeric operand is required."

Any help with this would be great!
Thanks

~Matt

Re: Using "NOT IN" with macro code

sbb — Tue, 24 Mar 2009 13:59:04 GMT

I would suggest using %SYSFUNC and the SAS INDEX function, given what you have shown for code.

Scott Barry
SBBWorks, Inc.

Re: Using "NOT IN" with macro code

PatrickG — Wed, 25 Mar 2009 15:26:30 GMT

Yes, but to do this you first must set the minoperator option (which tells the SAS Macro Facility to recognize "in" as an operator). Then to use the "not" you need to put the original expression in parens and place the "not" outside. See below.

160 options minoperator;
161
162 %macro testit;
163 %if fred in fred %then
164 %put yes;
165 %else %put no;
166 %mend;
167
168 %macro testitagain;
169 %if not(fred in joe chuck al) %then
170 %put yes;
171 %else %put no;
172 %mend;
173
174 %testit;
yes
175
176 %testitagain;
yes

Re: Using "NOT IN" with macro code

sbb — Wed, 25 Mar 2009 15:51:48 GMT

The option MINOPERATOR is new with SAS 9.2.

MINOPERATOR System Option
http://support.sas.com/documentation/cdl/en/mcrolref/61885/HTML/default/a003092012.htm

Scott Barry
SBBWorks, Inc.

Re: Using "NOT IN" with macro code

himself — Sat, 18 Apr 2020 20:08:29 GMT

%IF (&Variable NOT IN (Apples Oranges)) %THEN %DO;

can try this, for you to use not in in macro , you have to use the %eval; but you can create a call symputx that will store the values apple and oranges , eg. lets say the macro variable with the name apple,oranges is fruits, so the macro &fruits will resolve to apple and oranges. so i will have the following code

also remember to put the options statement at the top of the macro;

options minioperator mindelimiter=",";

like this

%if not %eval (%upcase(&fruits) in APPLES,ORANGES) %then %do;

Re: Using "NOT IN" with macro code

ChrisNZ — Sun, 19 Apr 2020 03:59:10 GMT

> I was wondering is it possible to use "Not IN" in a conditional statement using the macro facility.
Yes it is. Look at the minoperator and mindelimiter options.