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
data want;
merge have(in=a) have1(in=b);
by id;
if a and b;
run;
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
Yes, that is correct. I thought you don't want to see obs that are not contributing in merge.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.