topic Re: Problem with using string IN operator in Macros in SAS Programming

Problem with using string IN operator in Macros

Lakshmisas — Thu, 07 Mar 2019 18:46:07 GMT

options minoperator mlogic;

%macro test(value)/mindelimiter=',';
Data _Null_;
CALL SYMPUT('Vendor',2);
run;

%DO I=1 %TO &Vendor; /* LOOP THRU ALL Vendors */
%PUT *** LOOP &I OF &Vendor;

%if &value&I in Hari RRR,John yy,Peter,Jai,Phano %then

%put Value found within list.;

%else %put Value not in list.;
%end;

%mend;
%test(Hari RRR);

Re: Problem with using string IN operator in Macros

novinosrin — Thu, 07 Mar 2019 18:56:59 GMT

Correction

options minoperator;
%macro test(value)/mindelimiter=',';
Data _Null_;
CALL SYMPUT('Vendor',2);
run;

%DO I=1 %TO &Vendor; /* LOOP THRU ALL Vendors */
%PUT *** LOOP &I OF &Vendor;
%if &value in (Hari RRR,John yy,Peter,Jai,Phano )%then

%put Value found within list.;

%else %put Value not in list.;
%end;

%mend;
%test(Hari RRR)

You don't need suffix &i in &value&I coz macro parameter value is the name of the macro var and the value is Hari RRR. You do not have a series here.

Re: Problem with using string IN operator in Macros

andreas_lds — Thu, 07 Mar 2019 19:52:47 GMT

Why do you have data in macro-variables?

Re: Problem with using string IN operator in Macros

Astounding — Thu, 07 Mar 2019 22:17:26 GMT

While you have received a good suggestion, the context is wrong.

You should use &VALUE, not &VALUE&I:

%if &value in ........;

However, do NOT add parentheses around your existing list of values. The corrected version would simply be:

%if &value in Hari RRR,John yy,Peter,Jai,Phano %then

%put Value found within list.;