Creating a subset of observations

[m1986MM]

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.

[GreggB · Accepted solution]

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

[m1986MM]

Thank you.