topic merge but keep distinct in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/merge-but-keep-distinct/m-p/52870#M14566 <HTML><HEAD></HEAD><BODY><P> Sometimes you forget the simple ways... I over 'thought' it <img id="smileyhappy" class="emoticon emoticon-smileyhappy" src="https://communities.sas.com/i/smilies/16x16_smiley-happy.png" alt="Smiley Happy" title="Smiley Happy" /> .. thanks</P></BODY></HTML> Tue, 14 Feb 2012 01:41:14 GMT podarum 2012-02-14T01:41:14Z merge but keep distinct https://communities.sas.com/t5/SAS-Procedures/merge-but-keep-distinct/m-p/52868#M14564 <HTML><HEAD></HEAD><BODY><P>Hi, I'm trying to merge 2 sets, but keep them distinct .. better show what I mean:</P><P></P><P>HAVE</P><P>Data1:</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 128px; border-collapse: collapse;"><TBODY><TR style="height: 12.75pt;"><TD height="17" style="width: 48pt; height: 12.75pt;" width="64">CODE</TD><TD style="width: 48pt;" width="64">CompanyA</TD></TR><TR style="height: 12.75pt;"><TD height="17" style="height: 12.75pt;">A</TD><TD align="right">34</TD></TR><TR style="height: 12.75pt;"><TD height="17" style="height: 12.75pt;">C</TD><TD align="right">23</TD></TR><TR style="height: 12.75pt;"><TD height="17" style="height: 12.75pt;">D</TD><TD align="right">56</TD></TR><TR style="height: 12.75pt;"><TD height="17" style="height: 12.75pt;">E</TD><TD align="right">78</TD></TR><TR style="height: 12.75pt;"><TD height="17" style="height: 12.75pt;">F</TD><TD align="right">45</TD></TR><TR style="height: 12.75pt;"><TD height="17" style="height: 12.75pt;">G</TD><TD align="right">99</TD></TR><TR style="height: 12.75pt;"><TD height="17" style="height: 12.75pt;">H</TD><TD align="right">43</TD></TR></TBODY></TABLE><P></P><P>Data2</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 128px; border-collapse: collapse;"><TBODY><TR style="height: 12.75pt;"><TD height="17" style="width: 48pt; height: 12.75pt;" width="64">Code</TD><TD style="width: 48pt;" width="64">CompanyB</TD></TR><TR style="height: 12.75pt;"><TD height="17" style="height: 12.75pt;">A</TD><TD align="right">12</TD></TR><TR style="height: 12.75pt;"><TD height="17" style="height: 12.75pt;">B</TD><TD align="right">65</TD></TR><TR style="height: 12.75pt;"><TD height="17" style="height: 12.75pt;">C</TD><TD align="right">73</TD></TR><TR style="height: 12.75pt;"><TD height="17" style="height: 12.75pt;">D</TD><TD align="right">56</TD></TR><TR style="height: 12.75pt;"><TD height="17" style="height: 12.75pt;">E</TD><TD align="right">17</TD></TR><TR style="height: 12.75pt;"><TD height="17" style="height: 12.75pt;">F</TD><TD align="right">33</TD></TR><TR style="height: 12.75pt;"><TD height="17" style="height: 12.75pt;">J</TD><TD align="right">74</TD></TR></TBODY></TABLE><P></P><P>This is what I would like it to look:</P><P>WANT:</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 192px; border-collapse: collapse;"><TBODY><TR style="height: 12.75pt;"><TD height="17" style="width: 48pt; height: 12.75pt;" width="64">Code</TD><TD style="width: 48pt;" width="64">CompanyA</TD><TD style="width: 48pt;" width="64">CompanyB</TD></TR><TR style="height: 12.75pt;"><TD height="17" style="height: 12.75pt;">A</TD><TD>34</TD><TD>12</TD></TR><TR style="height: 12.75pt;"><TD height="17" style="height: 12.75pt;">B</TD><TD></TD><TD>65</TD></TR><TR style="height: 12.75pt;"><TD height="17" style="height: 12.75pt;">C</TD><TD>23</TD><TD>73</TD></TR><TR style="height: 12.75pt;"><TD height="17" style="height: 12.75pt;">D</TD><TD>56</TD><TD>56</TD></TR><TR style="height: 12.75pt;"><TD height="17" style="height: 12.75pt;">E</TD><TD>78</TD><TD>17</TD></TR><TR style="height: 12.75pt;"><TD height="17" style="height: 12.75pt;">F</TD><TD>45</TD><TD>33</TD></TR><TR style="height: 12.75pt;"><TD height="17" style="height: 12.75pt;">G</TD><TD>99</TD><TD></TD></TR><TR style="height: 12.75pt;"><TD height="17" style="height: 12.75pt;">H</TD><TD>43</TD><TD></TD></TR><TR style="height: 12.75pt;"><TD height="17" style="height: 12.75pt;">J</TD><TD></TD><TD>74</TD></TR></TBODY></TABLE><P><BR />Thank you..</P></BODY></HTML> Mon, 13 Feb 2012 21:47:33 GMT https://communities.sas.com/t5/SAS-Procedures/merge-but-keep-distinct/m-p/52868#M14564 podarum 2012-02-13T21:47:33Z merge but keep distinct https://communities.sas.com/t5/SAS-Procedures/merge-but-keep-distinct/m-p/52869#M14565 <HTML><HEAD></HEAD><BODY><P>data want ;</P><P>&nbsp;&nbsp; merge data1 data2;</P><P>&nbsp;&nbsp; by code;</P><P>run;</P></BODY></HTML> Mon, 13 Feb 2012 21:53:40 GMT https://communities.sas.com/t5/SAS-Procedures/merge-but-keep-distinct/m-p/52869#M14565 Tom 2012-02-13T21:53:40Z merge but keep distinct https://communities.sas.com/t5/SAS-Procedures/merge-but-keep-distinct/m-p/52870#M14566 <HTML><HEAD></HEAD><BODY><P> Sometimes you forget the simple ways... I over 'thought' it <img id="smileyhappy" class="emoticon emoticon-smileyhappy" src="https://communities.sas.com/i/smilies/16x16_smiley-happy.png" alt="Smiley Happy" title="Smiley Happy" /> .. thanks</P></BODY></HTML> Tue, 14 Feb 2012 01:41:14 GMT https://communities.sas.com/t5/SAS-Procedures/merge-but-keep-distinct/m-p/52870#M14566 podarum 2012-02-14T01:41:14Z