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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.