topic Many to One Merge in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/Many-to-One-Merge/m-p/133487#M36239 <HTML><HEAD></HEAD><BODY><P><BR /><STRONG>Table1</STRONG></P><P><STRONG>Bee&nbsp;&nbsp;&nbsp; MM</STRONG></P><P>65&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 90</P><P></P><P><STRONG>Table2</STRONG></P><P><STRONG>Bee&nbsp;&nbsp;&nbsp; MM</STRONG></P><P><STRONG>42&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 90</STRONG></P><P><STRONG>81&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 90</STRONG></P><P><STRONG>60&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 90</STRONG></P><P></P><P><STRONG>When I merge table1 and Table2 bt MM I an not getting 65 under Bee Variable...Is it being overridden?????</STRONG></P><P></P><P><STRONG>Regards</STRONG></P></BODY></HTML> Wed, 13 Mar 2013 20:39:46 GMT robertrao 2013-03-13T20:39:46Z Many to One Merge https://communities.sas.com/t5/SAS-Procedures/Many-to-One-Merge/m-p/133487#M36239 <HTML><HEAD></HEAD><BODY><P><BR /><STRONG>Table1</STRONG></P><P><STRONG>Bee&nbsp;&nbsp;&nbsp; MM</STRONG></P><P>65&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 90</P><P></P><P><STRONG>Table2</STRONG></P><P><STRONG>Bee&nbsp;&nbsp;&nbsp; MM</STRONG></P><P><STRONG>42&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 90</STRONG></P><P><STRONG>81&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 90</STRONG></P><P><STRONG>60&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 90</STRONG></P><P></P><P><STRONG>When I merge table1 and Table2 bt MM I an not getting 65 under Bee Variable...Is it being overridden?????</STRONG></P><P></P><P><STRONG>Regards</STRONG></P></BODY></HTML> Wed, 13 Mar 2013 20:39:46 GMT https://communities.sas.com/t5/SAS-Procedures/Many-to-One-Merge/m-p/133487#M36239 robertrao 2013-03-13T20:39:46Z Re: Many to One Merge https://communities.sas.com/t5/SAS-Procedures/Many-to-One-Merge/m-p/133488#M36240 <HTML><HEAD></HEAD><BODY><P>Yes.&nbsp; What are you hoping to get?&nbsp; There are at least four possible outcomes that I can imagine.</P></BODY></HTML> Wed, 13 Mar 2013 20:42:56 GMT https://communities.sas.com/t5/SAS-Procedures/Many-to-One-Merge/m-p/133488#M36240 Astounding 2013-03-13T20:42:56Z