BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Whonka
Calcite | Level 5

Hi, I currently have 2 data sets. They are both quite large with up to 300 variables, but simplified, they look something like this:

 

Set A:

 

John                  Var 1      Var2     Var3

Frank                 Var1       Var2     Var3

Joe                    Var1       Var2      Var3

etc. etc.

 

 

Set B:

 

John                  Var4

John                              Var5

John                                          Var6

Frank                 Var4    Var5

Frank                                         Var6

Joe                    Var4    

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!

1 ACCEPTED SOLUTION

Accepted Solutions
Astounding
PROC Star

First, you should sort both data sets by NAME (or whatever the variable is that holds the person's name).  Then:

 

data want;

update set_a set_b;

by name;

run;

 

This requires that SET_A never contains multiple observations for the same name.

View solution in original post

2 REPLIES 2
Astounding
PROC Star

First, you should sort both data sets by NAME (or whatever the variable is that holds the person's name).  Then:

 

data want;

update set_a set_b;

by name;

run;

 

This requires that SET_A never contains multiple observations for the same name.

Whonka
Calcite | Level 5

Thank you!

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

What is Bayesian Analysis?

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 821 views
  • 2 likes
  • 2 in conversation