topic Re: Retaining data only if it contains... in SAS Programming

Retaining data only if it contains...

Bounce — Tue, 03 Sep 2019 04:20:37 GMT

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.

Re: Retaining data only if it contains...

PGStats — Tue, 03 Sep 2019 04:44:51 GMT

Try

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

Re: Retaining data only if it contains...

PGStats — Tue, 03 Sep 2019 04:47:53 GMT

You might do better with:

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

Re: Retaining data only if it contains...

Bounce — Tue, 03 Sep 2019 05:20:59 GMT

Thank you!

Re: Retaining data only if it contains...

Bounce — Tue, 03 Sep 2019 05:21:08 GMT

Thank you for this!