DATA Step, Macro, Functions and more

Merging two data sets and non-matched records

Reply
Regular Contributor
Posts: 216

Merging two data sets and non-matched records

Hi

When combining two data sets with the same variables using Data/Merge and a By statement, the records that don't match on the variables in the By statement are just appended to the data set?

Paul

Trusted Advisor
Posts: 1,204

Re: Merging two data sets and non-matched records

data want;

merge have(in=a) have1(in=b);

by id;

if a and b;

run;

Regular Contributor
Posts: 216

Re: Merging two data sets and non-matched records

That will get me only those records in both record sets, I am presuming?

The below will get me the records that match on Id overlaying each other and will append those that don't?

data combine;

merge first second;

by Id;

run;

Paul

Trusted Advisor
Posts: 1,204

Re: Merging two data sets and non-matched records

Yes, that is correct. I thought you don't want to see obs that are not contributing in merge.

Ask a Question
Discussion stats
  • 3 replies
  • 179 views
  • 0 likes
  • 2 in conversation