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.
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
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
Thank you.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.