topic Merging Uncommon Tables in ODS and Base Reporting

topic Merging Uncommon Tables in ODS and Base Reporting https://communities.sas.com/t5/ODS-and-Base-Reporting/Merging-Uncommon-Tables/m-p/77234#M8772 <HTML><HEAD></HEAD><BODY><P>I have 2 tables that have nothing in common, but I want to merge them together.  I think an illustration will work better than trying to explain it:</P><P></P><P><STRONG>Table 1</STRONG></P><TABLE border="1" class="jiveBorder" height="174" style="border: 1px solid #000000; width: 69px; height: 175px;" width="67"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>ID</STRONG></TH></TR><TR><TD style="padding: 2px;">0001</TD></TR><TR><TD style="padding: 2px;">0002</TD></TR><TR><TD style="padding: 2px;">0003</TD></TR><TR><TD style="padding: 2px;">0004</TD></TR><TR><TD style="padding: 2px;">0005</TD></TR><TR><TD style="padding: 2px;">0006</TD></TR></TBODY></TABLE><P></P><P><STRONG>Table 2</STRONG></P><TABLE border="1" class="jiveBorder" height="74" style="border: 1px solid rgb(0, 0, 0); width: 69px; height: 70px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Color</STRONG></TH></TR><TR><TD style="padding: 2px;">Red</TD></TR><TR><TD style="padding: 2px;">Yellow</TD></TR><TR><TD>Green</TD></TR></TBODY></TABLE><P></P><P><STRONG>Desired Table</STRONG></P><TABLE border="1" class="jiveBorder" height="474" style="border: 1px solid #000000; width: 164px; height: 445px;" width="162"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>ID</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Color</STRONG></TH></TR><TR><TD style="padding: 2px;">0001</TD><TD style="padding: 2px;">Red</TD></TR><TR><TD style="padding: 2px;">0001</TD><TD style="padding: 2px;">Yellow</TD></TR><TR><TD style="padding: 2px;">0001</TD><TD style="padding: 2px;">Green</TD></TR><TR><TD style="padding: 2px;">0002</TD><TD style="padding: 2px;">Red</TD></TR><TR><TD style="padding: 2px;">0002</TD><TD style="padding: 2px;">Yellow</TD></TR><TR><TD style="padding: 2px;">0002</TD><TD style="padding: 2px;">Green</TD></TR><TR><TD style="padding: 2px;">0003</TD><TD style="padding: 2px;">Red</TD></TR><TR><TD style="padding: 2px;">0003</TD><TD style="padding: 2px;">Yellow</TD></TR><TR><TD style="padding: 2px;">0003</TD><TD style="padding: 2px;">Green</TD></TR><TR><TD style="padding: 2px;">0004</TD><TD style="padding: 2px;">Red</TD></TR><TR><TD style="padding: 2px;">0004</TD><TD style="padding: 2px;">Yellow</TD></TR><TR><TD style="padding: 2px;">0004</TD><TD style="padding: 2px;">Green</TD></TR><TR><TD style="padding: 2px;">0005</TD><TD style="padding: 2px;">Red</TD></TR><TR><TD style="padding: 2px;">0005</TD><TD style="padding: 2px;">Yellow</TD></TR><TR><TD style="padding: 2px;">0005</TD><TD style="padding: 2px;">Green</TD></TR><TR><TD style="padding: 2px;">0006</TD><TD style="padding: 2px;">Red</TD></TR><TR><TD style="padding: 2px;">0006</TD><TD style="padding: 2px;">Yellow</TD></TR><TR><TD style="padding: 2px;">0006</TD><TD style="padding: 2px;">Green</TD></TR></TBODY></TABLE></BODY></HTML> Fri, 12 Jul 2013 19:44:44 GMT djbateman 2013-07-12T19:44:44Z Merging Uncommon Tables https://communities.sas.com/t5/ODS-and-Base-Reporting/Merging-Uncommon-Tables/m-p/77234#M8772 <HTML><HEAD></HEAD><BODY><P>I have 2 tables that have nothing in common, but I want to merge them together.  I think an illustration will work better than trying to explain it:</P><P></P><P><STRONG>Table 1</STRONG></P><TABLE border="1" class="jiveBorder" height="174" style="border: 1px solid #000000; width: 69px; height: 175px;" width="67"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>ID</STRONG></TH></TR><TR><TD style="padding: 2px;">0001</TD></TR><TR><TD style="padding: 2px;">0002</TD></TR><TR><TD style="padding: 2px;">0003</TD></TR><TR><TD style="padding: 2px;">0004</TD></TR><TR><TD style="padding: 2px;">0005</TD></TR><TR><TD style="padding: 2px;">0006</TD></TR></TBODY></TABLE><P></P><P><STRONG>Table 2</STRONG></P><TABLE border="1" class="jiveBorder" height="74" style="border: 1px solid rgb(0, 0, 0); width: 69px; height: 70px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Color</STRONG></TH></TR><TR><TD style="padding: 2px;">Red</TD></TR><TR><TD style="padding: 2px;">Yellow</TD></TR><TR><TD>Green</TD></TR></TBODY></TABLE><P></P><P><STRONG>Desired Table</STRONG></P><TABLE border="1" class="jiveBorder" height="474" style="border: 1px solid #000000; width: 164px; height: 445px;" width="162"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>ID</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Color</STRONG></TH></TR><TR><TD style="padding: 2px;">0001</TD><TD style="padding: 2px;">Red</TD></TR><TR><TD style="padding: 2px;">0001</TD><TD style="padding: 2px;">Yellow</TD></TR><TR><TD style="padding: 2px;">0001</TD><TD style="padding: 2px;">Green</TD></TR><TR><TD style="padding: 2px;">0002</TD><TD style="padding: 2px;">Red</TD></TR><TR><TD style="padding: 2px;">0002</TD><TD style="padding: 2px;">Yellow</TD></TR><TR><TD style="padding: 2px;">0002</TD><TD style="padding: 2px;">Green</TD></TR><TR><TD style="padding: 2px;">0003</TD><TD style="padding: 2px;">Red</TD></TR><TR><TD style="padding: 2px;">0003</TD><TD style="padding: 2px;">Yellow</TD></TR><TR><TD style="padding: 2px;">0003</TD><TD style="padding: 2px;">Green</TD></TR><TR><TD style="padding: 2px;">0004</TD><TD style="padding: 2px;">Red</TD></TR><TR><TD style="padding: 2px;">0004</TD><TD style="padding: 2px;">Yellow</TD></TR><TR><TD style="padding: 2px;">0004</TD><TD style="padding: 2px;">Green</TD></TR><TR><TD style="padding: 2px;">0005</TD><TD style="padding: 2px;">Red</TD></TR><TR><TD style="padding: 2px;">0005</TD><TD style="padding: 2px;">Yellow</TD></TR><TR><TD style="padding: 2px;">0005</TD><TD style="padding: 2px;">Green</TD></TR><TR><TD style="padding: 2px;">0006</TD><TD style="padding: 2px;">Red</TD></TR><TR><TD style="padding: 2px;">0006</TD><TD style="padding: 2px;">Yellow</TD></TR><TR><TD style="padding: 2px;">0006</TD><TD style="padding: 2px;">Green</TD></TR></TBODY></TABLE></BODY></HTML> Fri, 12 Jul 2013 19:44:44 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Merging-Uncommon-Tables/m-p/77234#M8772 djbateman 2013-07-12T19:44:44Z Re: Merging Uncommon Tables https://communities.sas.com/t5/ODS-and-Base-Reporting/Merging-Uncommon-Tables/m-p/77235#M8773 <HTML><HEAD></HEAD><BODY><P>Lookup cross join</P></BODY></HTML> Fri, 12 Jul 2013 19:52:57 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Merging-Uncommon-Tables/m-p/77235#M8773 Reeza 2013-07-12T19:52:57Z