DATA Step, Macro, Functions and more

Merge two data sets

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 9
Accepted Solution

Merge two data sets

I have two data sets that look like this

1)

========================================

ColumnA     ||  ColumnB     ||  ColumnC     ||  Column D

========================================

     x                    x                    x                    .

     y                    y                    .                    y

     z                    z                    .                    z

and 2)....

========================================

ColumnA     ||  ColumnB     ||  ColumnC     ||  Column D

========================================

     x                    x                    .                    x

     y                    y                    y                    .

     z                    z                    z                    .

I have missing values in the last two columns in each data set.  I want to merge (1-to-1) the two data sets and I want the values from table 1 to go in the cells with the missing values in table 2 and the values in table 2 to go into the cells with missing values in table 1.  I tried to use MERGE but this one-to-one match replaces all columns with just the columns from the 2nd data set which just ends up being the same thing.  Any ideas?

Thank you.

-john


Accepted Solutions
Solution
‎06-17-2013 05:05 PM
Super User
Posts: 17,745

Re: Merge two data sets

Look into an update rather than a merge or join.

View solution in original post


All Replies
Solution
‎06-17-2013 05:05 PM
Super User
Posts: 17,745

Re: Merge two data sets

Look into an update rather than a merge or join.

Occasional Contributor
Posts: 9

Re: Merge two data sets

Rezza-

I think this is what I am looking for.  Thank you.

-John

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 164 views
  • 0 likes
  • 2 in conversation