topic Merging 2 or More Data Sets in SAS Procedures

Merging 2 or More Data Sets

deleted_user — Mon, 07 Feb 2011 23:02:35 GMT

Hi All,

I want to find out if I can merge 2 or more data sets by "Name".

Eg. John So appears in 2 different data sets, I want to merge these 2 data sets by John So's name.

Is this possible.

cheers.

Re: Merging 2 or More Data Sets

Reeza — Tue, 08 Feb 2011 00:39:59 GMT

Yes 🙂 You do need to make sure your data is the EXACT same in each of the datasets when merging by character variables. I usually upcase everything to avoid cases not matching.

You can use the merge and by statement;

data want;
merge have1 have2 have3;
by name;
run;

Or you could do some joins in SQL. Basically an extension of a two way join. Search either SAS Support or LexJansen.com for papers on joining if you need details on joining.

Re: Merging 2 or More Data Sets

deleted_user — Tue, 08 Feb 2011 03:06:34 GMT

Thanks Reeza I will try this.

cheers