topic Re: How to test if a list in macro var2 is in a list in macro var1? in SAS Programming

How to test if a list in macro var2 is in a list in macro var1?

Macro — Mon, 13 Oct 2014 23:19:23 GMT

%let varlist1 =a b c d e f;

%let varlist2 = c d e;

How to use macro or function to test if var in varlist2 are in varlist1?

Say, I can use %scan() function and do loop to test, but I don't know if there is a macor counterpart of 'in' of sas base?

e.g, "%scan(&varlist2,1)" in &varlist1, but in SAS base, &varlist1 should be quoted for each element of &varlist2, how can I make it quoted so that I can use SAS base in operator?

Or alternatively is there other way to achieve this without sas base 'in' operator?

Re: How to test if a list in macro var2 is in a list in macro var1?

Reeza — Tue, 14 Oct 2014 00:15:44 GMT

Does order matter?

Re: How to test if a list in macro var2 is in a list in macro var1?

Tom — Tue, 14 Oct 2014 00:18:02 GMT

Do you want to test each value in VARLIST2 are in VARLIST1?

%let found=0;

%do i=1 %to %sysfunc(countw(&varlist2)) ;

%if %sysfunc(indexw(&varlist1,%scan(&varlist1,&i))) %then %let found=1;

%end;

Re: How to test if a list in macro var2 is in a list in macro var1?

Scott_Mitchell — Tue, 14 Oct 2014 00:22:18 GMT

If you have 9.2 onwards you can using the IN operator.

I have an older version so the following has not been tested.

%LET VARLIST1 = A B C D E F;
%LET VARLIST2 = C D E;

%MACRO TEST;
%DO I = 1 %TO %LENGTH(%SYSFUNC(COMPRESS(&VARLIST2.)));
%IF %SCAN(&VARLIST2,&I.) IN &VARLIST1. %THEN %DO
%LET EXIST&I. = Y;
%END;
%END;
%MEND;

%TEST;

Re: How to test if a list in macro var2 is in a list in macro var1?

Ksharp — Tue, 14 Oct 2014 13:02:42 GMT

Does the order matter ?

%LET VARLIST1 = A B C D E F;
%LET VARLIST2 = C D E;

data _null_;
 if find(symget('VARLIST1'),symget('VARLIST2')) then putlog "Found" ;
  else putlog "Not Found";
  stop;
run;

Xia Keshan