topic Problem of using in statement for macro in SAS Procedures

Problem of using in statement for macro

Mike_Davis — Wed, 22 Aug 2012 16:17:30 GMT

Hello everyone,

I want to use an alternative method to simplify "%if (&a=1 or &a=2 or &a=3)" in macro %test in the SAS code below

The %test macro works but the %test2 will cause error, the error parts caused by "%if &a in (1,2,3) %then....."

Please advise.

Thanks!

Mike

%macro test(a);
%if (&a=1 or &a=2 or &a=3) %then %do;%put a=1/2/3;%end;
%else %do;%put a=other;%end;
%mend test;

%test(a=2);
%test(a=5);

%macro test2(a);
%if &a in (1,2,3) %then %do;%put a=1/2/3;%end;
%else %do;%put a=other;%end;
%mend test2;

%test2(a=2);
%test2(a=5);

Reeza — Wed, 22 Aug 2012 16:26:19 GMT

you need to turn in 'on' in SAS for macros:

options minoperator;

See this SAS Note:

Tom — Wed, 22 Aug 2012 16:41:29 GMT

I find that using indexw is just as easy and compatible with older versions of SAS.

%if %sysfunc(indexw(1 2 3,&a)) %then %put a=1/2/3;

%else %put a=other;

Mike_Davis — Wed, 22 Aug 2012 17:38:51 GMT

Awesome!

thank you Tom,

Mike_Davis — Wed, 22 Aug 2012 17:43:08 GMT

Thank you Reeza,

very impressive solution (I will try it later,) but I use SAS9.1 which not support this nice option .