I have two data sets WORK and SUMS. WORK is my working data set and SUMS is half the size and contains the same exact IDs as WORK. SUMS has the variables I want for the observations I was analyzing, so I want to merge the data sets and replace the observations in WORK with those in SUMS.
Example of a small portion what they look like:
WORK
SEQN | alcohol | legumes | meat |
10001 | 1.5 | 3.0 | 2.3 |
10002 | 1.4 | 2.3 | 3.5 |
10003 | 0 | 5.0 | 2.3 |
10004 | 3.0 | 2.0 | 2.0 |
SUMS
SEQN | alcohol | legumes | meat |
10002 | 2.2 | 3.3 | 5.0 |
10004 | 5.5 | 3.8 | 2.2 |
So the observations in the SUMS would replace the existing ones in WORK.
Thanks for your time!