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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.