topic Re: Creating a subset of observations in SAS Procedures

Creating a subset of observations

m1986MM — Fri, 20 Feb 2015 16:10:29 GMT

Hello everyone,

I have two datasets which has the same variable (Uni_Id). I want to create a subset of dataset1 such that the new subset will contain the observations whose uni_id values are equal to the values for this variable in the other dataset, dataset2.

I appreciate any suggestion.

Re: Creating a subset of observations

GreggB — Fri, 20 Feb 2015 16:54:27 GMT

Do you want to keep the vars in both data sets? I will assume you do. If you want only those observations where the ID is the same in both datasets:

proc sql;

create table join1 as

select a.*, b.* from dataset1 as a

inner join dataset2 as b

on a.Uni_id=b.Uni_id

quit:

You will get a warning saying that Uni_id appears in both data sets and it will the value of Uni_id in dataset1

Re: Creating a subset of observations

m1986MM — Sat, 21 Feb 2015 02:07:30 GMT

Thank you.