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

Combining multiple values on 2 data sets

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

1 ACCEPTED SOLUTION

Accepted Solutions
PROC Star

Re: Combining multiple values on 2 data sets

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.

2 REPLIES 2
PROC Star

Re: Combining multiple values on 2 data sets

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.

Calcite | Level 5

Re: Combining multiple values on 2 data sets

Thank you!

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