Searching multiple variables for multiple character strings

[ballewnick]

Thanks Astounding!

Your last post clarified the last couple points I was getting hung up on and I was able to make the few changes I needed to get the program to run. Thanks for also explaining the different styles or arrays and the advantages of using the style you suggested.

[Reeza]

This is much, much easier if you have your data in a long format rather than a wide format. As mentioned, only exact matches will be found. 

If you transpose your data and place the codes you're looking for into a dataset, list_chosen then this would work:

proc sql;
create table want as
select *
from have 
where idx in (select idx from list_chosen);
quit;