Hi, I currently have 2 data sets. They are both quite large with up to 300 variables, but simplified, they look something like this:
John Var 1 Var2 Var3
Frank Var1 Var2 Var3
Joe Var1 Var2 Var3
Frank Var4 Var5
Joe Var5 Var6
How do I combine these data sets to make them look like:
John Var 1 Var 2 Var 3 Var 4 Var5 Var6
Frank Var 1 Var 2 Var 3 Var 4 Var5 Var6
Joe Var 1 Var 2 Var 3 Var 4 Var5 Var6
Thanks in advance!
First, you should sort both data sets by NAME (or whatever the variable is that holds the person's name). Then:
update set_a set_b;
This requires that SET_A never contains multiple observations for the same name.
View solution in original post
The early bird rate has been extended! Register by March 18 for just $695 - $100 off the standard rate.
Check out the agenda and get ready for a jam-packed event featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events.
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.
Select SAS Training centers are offering in-person courses. View upcoming courses for:
View all other training opportunities.