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
Look into an update rather than a merge or join.
Look into an update rather than a merge or join.
Rezza-
I think this is what I am looking for. Thank you.
-John
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.