topic Join two tables - Flag and summarize common variables that have unequal pairs of values in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/Join-two-tables-Flag-and-summarize-common-variables-that-have/m-p/147528#M39066 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P></P><P>I join two datasets A and B on two common variables VARA and VARB.</P><P></P><P>Those two datasets have a number of common variables that after the join should have equal values across all joined records Var1_A = Var1_B, ,Var2_A = Var2_B ...etc.</P><P></P><P>Unfortunately that is not happening and I would like to summarize all these unequal pairs of values.</P><P></P><P>VARA&nbsp;&nbsp; VARB&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (&nbsp; Var1_A&nbsp;&nbsp; Var1_B )&nbsp; (Var2_A&nbsp;&nbsp; Var2_B)&nbsp;&nbsp; </P><P>&nbsp; 100&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50&nbsp;&nbsp;&nbsp; .&nbsp;&nbsp;&nbsp; 50&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20</P><P>&nbsp; 200&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 32&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 14pt;"><STRONG style="color: #ff0000;"> .</STRONG></SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 45&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 45</P><P>&nbsp; 300&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 300&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 67&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 67&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 14pt;"><STRONG style="color: #ff0000;"> .</STRONG></SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 53</P><P>&nbsp; 400&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 400&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 14pt;"><STRONG style="color: #ff0000;"> .</STRONG></SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 72&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 23&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 23</P><P>...............................................................................</P><P></P><P>In addition to the above the number of&nbsp; common variables that have unequal pairs of values&nbsp; is significant (&gt;100) which makes very cumbersome to search one by one.</P><P></P><P>Any hints most welcome.</P><P></P><P>Thank you in aFladvance.</P><P></P><P>Nikos</P></BODY></HTML> Tue, 06 May 2014 19:47:15 GMT Nikos 2014-05-06T19:47:15Z Join two tables - Flag and summarize common variables that have unequal pairs of values https://communities.sas.com/t5/SAS-Procedures/Join-two-tables-Flag-and-summarize-common-variables-that-have/m-p/147528#M39066 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P></P><P>I join two datasets A and B on two common variables VARA and VARB.</P><P></P><P>Those two datasets have a number of common variables that after the join should have equal values across all joined records Var1_A = Var1_B, ,Var2_A = Var2_B ...etc.</P><P></P><P>Unfortunately that is not happening and I would like to summarize all these unequal pairs of values.</P><P></P><P>VARA&nbsp;&nbsp; VARB&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (&nbsp; Var1_A&nbsp;&nbsp; Var1_B )&nbsp; (Var2_A&nbsp;&nbsp; Var2_B)&nbsp;&nbsp; </P><P>&nbsp; 100&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50&nbsp;&nbsp;&nbsp; .&nbsp;&nbsp;&nbsp; 50&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20</P><P>&nbsp; 200&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 32&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 14pt;"><STRONG style="color: #ff0000;"> .</STRONG></SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 45&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 45</P><P>&nbsp; 300&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 300&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 67&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 67&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 14pt;"><STRONG style="color: #ff0000;"> .</STRONG></SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 53</P><P>&nbsp; 400&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 400&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 14pt;"><STRONG style="color: #ff0000;"> .</STRONG></SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 72&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 23&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 23</P><P>...............................................................................</P><P></P><P>In addition to the above the number of&nbsp; common variables that have unequal pairs of values&nbsp; is significant (&gt;100) which makes very cumbersome to search one by one.</P><P></P><P>Any hints most welcome.</P><P></P><P>Thank you in aFladvance.</P><P></P><P>Nikos</P></BODY></HTML> Tue, 06 May 2014 19:47:15 GMT https://communities.sas.com/t5/SAS-Procedures/Join-two-tables-Flag-and-summarize-common-variables-that-have/m-p/147528#M39066 Nikos 2014-05-06T19:47:15Z Re: Join two tables - Flag and summarize common variables that have unequal pairs of values https://communities.sas.com/t5/SAS-Procedures/Join-two-tables-Flag-and-summarize-common-variables-that-have/m-p/147529#M39067 <HTML><HEAD></HEAD><BODY><P>Look at Proc Compare for starters.</P></BODY></HTML> Tue, 06 May 2014 19:50:21 GMT https://communities.sas.com/t5/SAS-Procedures/Join-two-tables-Flag-and-summarize-common-variables-that-have/m-p/147529#M39067 Reeza 2014-05-06T19:50:21Z