https://communities.sas.com/t5/SAS-Programming/Intersection-of-two-macro/m-p/612944#M178947 <P>Scan iteratively through one macro variable and use findw into the second:</P> <PRE><CODE class=" language-sas">%let in1=A B C; %let in2=A B D; data _null_; length result $10; do i = 1 to countw("&amp;in1."); if findw("&amp;in2.",scan("&amp;in1.",i)) then result = catx(' ',result,scan("&amp;in1.",i)); end; call symputx('result',result); run; %put &amp;result.;</CODE></PRE> Thu, 19 Dec 2019 08:09:56 GMT Kurt_Bremser 2019-12-19T08:09:56Z https://communities.sas.com/t5/SAS-Programming/Intersection-of-two-macro/m-p/612941#M178945 I have two macro variables. Let's say the first includes A B C and the second includes A B D. Can I make the intersection of the two macro variables, which contains A and B? Thu, 19 Dec 2019 07:40:50 GMT https://communities.sas.com/t5/SAS-Programming/Intersection-of-two-macro/m-p/612941#M178945 braam 2019-12-19T07:40:50Z https://communities.sas.com/t5/SAS-Programming/Intersection-of-two-macro/m-p/612944#M178947 <P>Scan iteratively through one macro variable and use findw into the second:</P> <PRE><CODE class=" language-sas">%let in1=A B C; %let in2=A B D; data _null_; length result $10; do i = 1 to countw("&amp;in1."); if findw("&amp;in2.",scan("&amp;in1.",i)) then result = catx(' ',result,scan("&amp;in1.",i)); end; call symputx('result',result); run; %put &amp;result.;</CODE></PRE> Thu, 19 Dec 2019 08:09:56 GMT https://communities.sas.com/t5/SAS-Programming/Intersection-of-two-macro/m-p/612944#M178947 Kurt_Bremser 2019-12-19T08:09:56Z