topic Re: Removing select cases from a dataset in SAS Procedures

Removing select cases from a dataset

Angi — Tue, 03 Feb 2015 02:43:40 GMT

Hi,

I have two datasets in long format that have a variable “ID” in common.

If DatasetB doesn’t have a matching ID with DatasetA, I want to delete unmatched cases in DatasetB.

Is there any way to do this without merging the two datasets?

Have DatasetA:

Have DatasetB:

Want new_DatasetB

Thank you for your help!

PGStats — Tue, 03 Feb 2015 03:48:31 GMT

The simplest way (create a new table, no sorting) would be:

proc sql;

create table new_datasetB as

select * from datasetB

where ID in (select ID from datasetA);

quit;

if you would prefer to modify datasetB (could be faster if datasetB is large) :

proc sql;

delete from datasetB

where ID not in (select ID from datasetA);

quit;

Angi — Tue, 03 Feb 2015 06:06:33 GMT

Thank you very much!