topic Merging two data sets and non-matched records in SAS Programming https://communities.sas.com/t5/SAS-Programming/Merging-two-data-sets-and-non-matched-records/m-p/180090#M34421 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>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?</P><P></P><P>Paul</P></BODY></HTML> Fri, 29 Aug 2014 15:51:59 GMT Paul_NYS 2014-08-29T15:51:59Z Merging two data sets and non-matched records https://communities.sas.com/t5/SAS-Programming/Merging-two-data-sets-and-non-matched-records/m-p/180090#M34421 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>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?</P><P></P><P>Paul</P></BODY></HTML> Fri, 29 Aug 2014 15:51:59 GMT https://communities.sas.com/t5/SAS-Programming/Merging-two-data-sets-and-non-matched-records/m-p/180090#M34421 Paul_NYS 2014-08-29T15:51:59Z Re: Merging two data sets and non-matched records https://communities.sas.com/t5/SAS-Programming/Merging-two-data-sets-and-non-matched-records/m-p/180091#M34422 <HTML><HEAD></HEAD><BODY><P>data want;</P><P>merge have(in=a) have1(in=b);</P><P>by id;</P><P>if a and b;</P><P>run;</P></BODY></HTML> Fri, 29 Aug 2014 16:17:55 GMT https://communities.sas.com/t5/SAS-Programming/Merging-two-data-sets-and-non-matched-records/m-p/180091#M34422 stat_sas 2014-08-29T16:17:55Z Re: Merging two data sets and non-matched records https://communities.sas.com/t5/SAS-Programming/Merging-two-data-sets-and-non-matched-records/m-p/180092#M34423 <HTML><HEAD></HEAD><BODY><P>That will get me only those records in both record sets, I am presuming?</P><P></P><P>The below will get me the records that match on Id overlaying each other and will append those that don't?</P><P></P><P>data combine;</P><P>merge first second;</P><P>by Id;</P><P>run;</P><P></P><P>Paul</P></BODY></HTML> Fri, 29 Aug 2014 16:30:40 GMT https://communities.sas.com/t5/SAS-Programming/Merging-two-data-sets-and-non-matched-records/m-p/180092#M34423 Paul_NYS 2014-08-29T16:30:40Z Re: Merging two data sets and non-matched records https://communities.sas.com/t5/SAS-Programming/Merging-two-data-sets-and-non-matched-records/m-p/180093#M34424 <HTML><HEAD></HEAD><BODY><P>Yes, that is correct. I thought you don't want to see obs that are not contributing in merge.</P></BODY></HTML> Fri, 29 Aug 2014 16:34:53 GMT https://communities.sas.com/t5/SAS-Programming/Merging-two-data-sets-and-non-matched-records/m-p/180093#M34424 stat_sas 2014-08-29T16:34:53Z