topic merge by variable and all in New SAS User

merge by variable and all

Smitha9 — Thu, 12 Nov 2020 16:30:29 GMT

Hi,

I have a two datasets D1 and D2:

name fnumber name ID

a 1 b 3

b 3 c 4

c e 9

d 11 g 12

e 9 h 15

I want to merge by name and I want all the observations from both of the datasets

final dataset F1:

name fnumber ID

a 1

b 3 3

c 4

d 11

e 9 9

g 12

h 15

how to merge the datasets? please let me know the code.

thank you in advance

Re: merge by variable and all

ballardw — Thu, 12 Nov 2020 17:05:05 GMT

Basic data set merge with a BY statement.

Proc sort data=d1;
   by name;
run;
Proc sort data=d2;
   by name;
run;

data want;
   merge d1 d2;
   by name;
run;

If you have other variables of the same name in both sets you need to let us know as the behavior with merge is the properties of the common variable will come from the first data set on the merge statement but the values from the second.

If common named variables are different in type you will get an error and the merge will fail.

Re: merge by variable and all

ssills24 — Tue, 17 Nov 2020 16:09:11 GMT

Hi Smitha9, as long as both data sets have a common variable name with the same characteristics and are sorted before hand, merging can be done in one of two ways.

The first is using a Data step:

DATA WORK.Merge;
MERGE WORK.D1
WORK.D2;
BY name;
RUN;

You could also use the PROC SQL statement.