topic Re: Subsetting a Data set in SAS Programming

Subsetting a Data set

rnmishra — Fri, 21 Sep 2012 13:11:46 GMT

Let;

data aa;

input Name $ Age Height;

datalines;

Adam 55 100

Jack 60 110

Stacy 42 105

Rabecca 32 100

Jacob 63 99

Jack 89 150

Don 100 140

;

data bb;

input Name $ Age;

datalines

Jack 50

Don 90

Tony 67

;

Here names Jack and Don are present in both the data sets. But have mismatching ages....which I do not care.

My question is

I want to create a new data set cc from aa such that it does not contain the the names which are in data set bb.

In above example jack( needs to deleted from both the rows) and don need to be deleted from data set aa to give data set cc.

Any suggestions?

Thanks.

Re: Subsetting a Data set

PGStats — Fri, 21 Sep 2012 13:16:48 GMT

Is SQL ok?

proc sql;

create table cc as

select * from aa where Name not in (select Name from bb);

quit;

Re: Subsetting a Data set

art297 — Fri, 21 Sep 2012 13:20:16 GMT

or, with datastep:

proc sort data=aa;

by name;

run;

proc sort data=bb;

by name;

run;

data want;

merge aa bb (in=inbb keep=name);

by name;

if not inbb;

run;

Re: Subsetting a Data set

rnmishra — Fri, 21 Sep 2012 13:20:27 GMT

Thanks PG Stats, Never thought I could get an answer this early...with in minutes. Thanks.

Re: Subsetting a Data set

rnmishra — Fri, 21 Sep 2012 13:25:13 GMT

Thanks Arthur.