Merge Data Sets and Replacing variables

kippy_kips — Tue, 02 Aug 2022 21:40:40 GMT

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!

Re: Merge Data Sets and Replacing variables

Reeza — Tue, 02 Aug 2022 21:46:11 GMT

A straight merge will do this if the variable names are the same as in your example.

data want;
merge work sums;
by SEQN;
run;

topic Merge Data Sets and Replacing variables in SAS Programming

Merge Data Sets and Replacing variables

Re: Merge Data Sets and Replacing variables