topic Merge with condition in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/Merge-with-condition/m-p/105853#M29497 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have two datasets and "variable name" TIME differs in both</P><P>I want to merge by ID and TIME and want to delete if its a duplicate occuring&nbsp; in both.</P><P></P><P></P><P>How can this be the log?????????when only 14 records were common then I was expecting the WANT dataset to have (93+68=161)-14=147???????????</P><P>DATASET1 has 93 records</P><P>DATASET2 has 68 records</P><P>WANT has 133 records</P><P>TEST has 14 records</P><P></P><P>Please correct me???</P><P></P><P></P><P>data want test;</P><P>merge dataset1(in=a)&nbsp;&nbsp; dataset2( in=b rename=(time1=time));</P><P>by ID TIME;</P><P>if a and b then output test;else output want;</P><P>run;</P><P></P><P></P><P></P><P><STRONG>DATASET1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />ID&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>TIME</STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />101&nbsp;&nbsp; 27JUN2013:11:24</P><P></P><P><STRONG>DATASET2</STRONG><BR />ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>TIME1</STRONG><BR />101&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 27JUN2013:11:24</P></BODY></HTML> Thu, 08 Aug 2013 21:19:11 GMT robertrao 2013-08-08T21:19:11Z Merge with condition https://communities.sas.com/t5/SAS-Procedures/Merge-with-condition/m-p/105853#M29497 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have two datasets and "variable name" TIME differs in both</P><P>I want to merge by ID and TIME and want to delete if its a duplicate occuring&nbsp; in both.</P><P></P><P></P><P>How can this be the log?????????when only 14 records were common then I was expecting the WANT dataset to have (93+68=161)-14=147???????????</P><P>DATASET1 has 93 records</P><P>DATASET2 has 68 records</P><P>WANT has 133 records</P><P>TEST has 14 records</P><P></P><P>Please correct me???</P><P></P><P></P><P>data want test;</P><P>merge dataset1(in=a)&nbsp;&nbsp; dataset2( in=b rename=(time1=time));</P><P>by ID TIME;</P><P>if a and b then output test;else output want;</P><P>run;</P><P></P><P></P><P></P><P><STRONG>DATASET1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />ID&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>TIME</STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />101&nbsp;&nbsp; 27JUN2013:11:24</P><P></P><P><STRONG>DATASET2</STRONG><BR />ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>TIME1</STRONG><BR />101&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 27JUN2013:11:24</P></BODY></HTML> Thu, 08 Aug 2013 21:19:11 GMT https://communities.sas.com/t5/SAS-Procedures/Merge-with-condition/m-p/105853#M29497 robertrao 2013-08-08T21:19:11Z Re: Merge with condition https://communities.sas.com/t5/SAS-Procedures/Merge-with-condition/m-p/105854#M29498 <HTML><HEAD></HEAD><BODY><P>If there are 14 records in common, then the total of non-matches will be (93-14)+(68-14)=133.</P></BODY></HTML> Thu, 08 Aug 2013 22:13:55 GMT https://communities.sas.com/t5/SAS-Procedures/Merge-with-condition/m-p/105854#M29498 Fugue 2013-08-08T22:13:55Z