Merging two data sets and non-matched records

[Paul_NYS]

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

[stat_sas]

data want;

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

by id;

if a and b;

run;

[Paul_NYS]

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

[stat_sas]

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