Retaining data only if it contains...

[Bounce]

Hi all, I am fairly new with SAS and I have two datasets.

One data-set is like a population data, the other is just a list of IDs. 

What I want is to match the data-sets or filter out the population data set in a quick way, so that population data set will only keep rows with the same ID as the ones in the other list. There are 85 unique IDs that don't follow any specific format (just 10 random characters) I wish to keep and I tried using:

Data want

set have

if find (ID, 'first ID', 'second ID', 'third ID', etc [up to the 85 unique IDs]...);

run;

But keep getting error The FIND function call has too many arguments.

[PGStats]

Try

Data want;
set have;
if ID in ( 'first ID', 'second ID', 'third ID', etc [up to the 85 unique IDs]...);
run;

[Bounce]

Thank you for this!

[PGStats · Accepted solution]

You might do better with:

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

[Bounce]

Thank you!