Help using Base SAS procedures

Merging 2 or More Data Sets

Not applicable
Posts: 0

Merging 2 or More Data Sets

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.

Super User
Posts: 23,700

Re: Merging 2 or More Data Sets

Posted in reply to deleted_user
Yes Smiley Happy 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;

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

Re: Merging 2 or More Data Sets

Thanks Reeza I will try this.

Ask a Question
Discussion stats
  • 2 replies
  • 2 in conversation