topic Re: 'in' operator after %if in macro in SAS Programming

'in' operator after %if in macro

swimmer — Fri, 06 Mar 2015 18:52:26 GMT

Hi,

Can I use 'in' operator in macros? It seems the following code doesn't work. Thanks.

%macro test(a);

%if %upcase(&a.) in (A, B, C) %then %let name = Mike;

%mend test;

Re: 'in' operator after %if in macro

swimmer — Fri, 06 Mar 2015 19:14:52 GMT

Well, I tried this in PC SAS and it worked.

%macro test(a) /minoperator;

%if %upcase(&a) in A B C %then %put Hello;

%mend test;

%test(a);

However, it doesn't work in SAS EG. Any other suggestion? Do I have to write them by ' xxx or xxx or xxx'? Thanks.

Re: 'in' operator after %if in macro

Haikuo — Fri, 06 Mar 2015 19:34:43 GMT

What SAS/EG version you have? It works for me on both SAS 9.3/9.4 with EG 5.1

On my test, it works even when parenthesis is present:

%macro test(a) /minoperator;

%if %upcase(&a) in (A B C) %then %put Hello;

%mend test;

%test(a)

Re: 'in' operator after %if in macro

SASMike — Fri, 06 Mar 2015 19:40:27 GMT

Here's a reference article I found handy for working with the in operator in macros. It entails listing the 'in' delimiter.

Hope this helps!

Sample 35591: How to use the new macro IN operator for SAS 9.2

http://support.sas.com/kb/35/591.html

Starting SAS 9.2, there is an IN operator for the macro language. The IN operator can now be used on the %IF statement when the MINOPERATOR option is set on the %MACRO statement or as a SAS system option.

options minoperator mlogic;

%macro test(value)/mindelimiter=',';

%if &value in 1,2,3,4,5,6 %then

%put Value found within list.;

%else %put Value not in list.;

%mend;

Re: 'in' operator after %if in macro

swimmer — Fri, 06 Mar 2015 19:40:30 GMT

It worked for me now. I probably did something wrong with the minoperator option. After I restart the SAS EG, it worked! Thanks.