Merge two data sets

GoBrewers14 — Mon, 17 Jun 2013 19:14:56 GMT

I have two data sets that look like this

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

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

Re: Merge two data sets

Reeza — Mon, 17 Jun 2013 21:05:29 GMT

Look into an update rather than a merge or join.

Re: Merge two data sets

GoBrewers14 — Mon, 17 Jun 2013 22:17:28 GMT

Rezza-

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

-John

topic Re: Merge two data sets in SAS Programming

Merge two data sets

Re: Merge two data sets

Re: Merge two data sets