topic How to union multiple data query in SAS VA in SAS Visual Analytics https://communities.sas.com/t5/SAS-Visual-Analytics/How-to-union-multiple-data-query-in-SAS-VA/m-p/202920#M1852 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I would like to ask how to union multiple data query in SAS VA. Please see example table below. Thank you.</P><P></P><P>Input Table 1</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">ID</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Level</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Group</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Amount</TH></TR><TR><TD style="padding: 2px;">01</TD><TD style="padding: 2px;">Level 1</TD><TD style="padding: 2px;">Group 1</TD><TD style="padding: 2px;">51</TD></TR><TR><TD style="padding: 2px;">02</TD><TD style="padding: 2px;">Level 1</TD><TD style="padding: 2px;">Group 1</TD><TD style="padding: 2px;">35</TD></TR><TR><TD style="padding: 2px;">03</TD><TD style="padding: 2px;">Level 1</TD><TD style="padding: 2px;">Group 2</TD><TD style="padding: 2px;">21</TD></TR></TBODY></TABLE><P></P><P>Input Table 2</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><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">Level</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Group</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Amount</STRONG></TH></TR><TR><TD style="padding: 2px;">04</TD><TD style="padding: 2px;">Level 2</TD><TD style="padding: 2px;">Group 3</TD><TD style="padding: 2px;">11</TD></TR><TR><TD style="padding: 2px;">05</TD><TD style="padding: 2px;">Level 2</TD><TD style="padding: 2px;">Group 3</TD><TD style="padding: 2px;">26</TD></TR></TBODY></TABLE><P></P><P>Input Table 3</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><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">Level</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Group</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Amount</TH></TR><TR><TD style="padding: 2px;">06</TD><TD style="padding: 2px;">Level 3</TD><TD style="padding: 2px;">Group 4</TD><TD style="padding: 2px;">17</TD></TR><TR><TD style="padding: 2px;">07</TD><TD style="padding: 2px;">Level 3</TD><TD style="padding: 2px;">Group 5</TD><TD style="padding: 2px;">18</TD></TR><TR><TD style="padding: 2px;">08</TD><TD style="padding: 2px;">Level 3</TD><TD style="padding: 2px;">Group 5</TD><TD style="padding: 2px;">19</TD></TR></TBODY></TABLE><P></P><P><STRONG>Expected Output</STRONG></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><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">Level</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Group</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Amount</TH></TR><TR><TD style="padding: 2px;">01</TD><TD style="padding: 2px;">Level 1</TD><TD style="padding: 2px;">Group 1</TD><TD style="padding: 2px;">51</TD></TR><TR><TD style="padding: 2px;">02</TD><TD style="padding: 2px;">Level 1</TD><TD style="padding: 2px;">Group 1</TD><TD style="padding: 2px;">35</TD></TR><TR><TD style="padding: 2px;">03</TD><TD style="padding: 2px;">Level 1</TD><TD style="padding: 2px;">Group 2</TD><TD style="padding: 2px;">21</TD></TR><TR><TD style="padding: 2px;">04</TD><TD style="padding: 2px;">Level 2</TD><TD style="padding: 2px;">Group 3</TD><TD style="padding: 2px;">11</TD></TR><TR><TD style="padding: 2px;">05</TD><TD style="padding: 2px;">Level 2</TD><TD style="padding: 2px;">Group 3</TD><TD style="padding: 2px;">26</TD></TR><TR><TD style="padding: 2px;">06</TD><TD style="padding: 2px;">Level 3</TD><TD style="padding: 2px;">Group 4</TD><TD style="padding: 2px;">17</TD></TR><TR><TD style="padding: 2px;">07</TD><TD style="padding: 2px;">Level 3</TD><TD style="padding: 2px;">Group 5</TD><TD style="padding: 2px;">18</TD></TR><TR><TD style="padding: 2px;">08</TD><TD style="padding: 2px;">Level 3</TD><TD style="padding: 2px;">Group 5</TD><TD style="padding: 2px;">19</TD></TR></TBODY></TABLE><P></P><P>Regards,</P></BODY></HTML> Thu, 11 Jun 2015 05:52:37 GMT Carrot17 2015-06-11T05:52:37Z How to union multiple data query in SAS VA https://communities.sas.com/t5/SAS-Visual-Analytics/How-to-union-multiple-data-query-in-SAS-VA/m-p/202920#M1852 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I would like to ask how to union multiple data query in SAS VA. Please see example table below. Thank you.</P><P></P><P>Input Table 1</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">ID</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Level</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Group</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Amount</TH></TR><TR><TD style="padding: 2px;">01</TD><TD style="padding: 2px;">Level 1</TD><TD style="padding: 2px;">Group 1</TD><TD style="padding: 2px;">51</TD></TR><TR><TD style="padding: 2px;">02</TD><TD style="padding: 2px;">Level 1</TD><TD style="padding: 2px;">Group 1</TD><TD style="padding: 2px;">35</TD></TR><TR><TD style="padding: 2px;">03</TD><TD style="padding: 2px;">Level 1</TD><TD style="padding: 2px;">Group 2</TD><TD style="padding: 2px;">21</TD></TR></TBODY></TABLE><P></P><P>Input Table 2</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><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">Level</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Group</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Amount</STRONG></TH></TR><TR><TD style="padding: 2px;">04</TD><TD style="padding: 2px;">Level 2</TD><TD style="padding: 2px;">Group 3</TD><TD style="padding: 2px;">11</TD></TR><TR><TD style="padding: 2px;">05</TD><TD style="padding: 2px;">Level 2</TD><TD style="padding: 2px;">Group 3</TD><TD style="padding: 2px;">26</TD></TR></TBODY></TABLE><P></P><P>Input Table 3</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><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">Level</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Group</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Amount</TH></TR><TR><TD style="padding: 2px;">06</TD><TD style="padding: 2px;">Level 3</TD><TD style="padding: 2px;">Group 4</TD><TD style="padding: 2px;">17</TD></TR><TR><TD style="padding: 2px;">07</TD><TD style="padding: 2px;">Level 3</TD><TD style="padding: 2px;">Group 5</TD><TD style="padding: 2px;">18</TD></TR><TR><TD style="padding: 2px;">08</TD><TD style="padding: 2px;">Level 3</TD><TD style="padding: 2px;">Group 5</TD><TD style="padding: 2px;">19</TD></TR></TBODY></TABLE><P></P><P><STRONG>Expected Output</STRONG></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><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">Level</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Group</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Amount</TH></TR><TR><TD style="padding: 2px;">01</TD><TD style="padding: 2px;">Level 1</TD><TD style="padding: 2px;">Group 1</TD><TD style="padding: 2px;">51</TD></TR><TR><TD style="padding: 2px;">02</TD><TD style="padding: 2px;">Level 1</TD><TD style="padding: 2px;">Group 1</TD><TD style="padding: 2px;">35</TD></TR><TR><TD style="padding: 2px;">03</TD><TD style="padding: 2px;">Level 1</TD><TD style="padding: 2px;">Group 2</TD><TD style="padding: 2px;">21</TD></TR><TR><TD style="padding: 2px;">04</TD><TD style="padding: 2px;">Level 2</TD><TD style="padding: 2px;">Group 3</TD><TD style="padding: 2px;">11</TD></TR><TR><TD style="padding: 2px;">05</TD><TD style="padding: 2px;">Level 2</TD><TD style="padding: 2px;">Group 3</TD><TD style="padding: 2px;">26</TD></TR><TR><TD style="padding: 2px;">06</TD><TD style="padding: 2px;">Level 3</TD><TD style="padding: 2px;">Group 4</TD><TD style="padding: 2px;">17</TD></TR><TR><TD style="padding: 2px;">07</TD><TD style="padding: 2px;">Level 3</TD><TD style="padding: 2px;">Group 5</TD><TD style="padding: 2px;">18</TD></TR><TR><TD style="padding: 2px;">08</TD><TD style="padding: 2px;">Level 3</TD><TD style="padding: 2px;">Group 5</TD><TD style="padding: 2px;">19</TD></TR></TBODY></TABLE><P></P><P>Regards,</P></BODY></HTML> Thu, 11 Jun 2015 05:52:37 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/How-to-union-multiple-data-query-in-SAS-VA/m-p/202920#M1852 Carrot17 2015-06-11T05:52:37Z Re: How to union multiple data query in SAS VA https://communities.sas.com/t5/SAS-Visual-Analytics/How-to-union-multiple-data-query-in-SAS-VA/m-p/202921#M1853 <HTML><HEAD></HEAD><BODY><P>Hi <STRONG><A _jive_internal="true" class="jiveTT-hover-user jive-username-link" data-avatarid="-1" data-externalid="" data-presence="null" data-userid="876107" data-username="Carrot17" href="https://communities.sas.com/people/Carrot17" id="jive-87610749500519518064186">Carrot17</A></STRONG>,</P><P></P><P>Did you get your answer in this thread?</P><H1 style="font-size: 26px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: #ffffff;"><A _jive_internal="true" href="https://communities.sas.com/message/232336#232336" style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #0e66ba;">How to do Union in Data preparation</A></H1><P></P><P>If so, please mark the correct or helpful answer as you see fit.</P><P></P><P>Best,</P><P>Anna</P></BODY></HTML> Fri, 12 Jun 2015 14:49:59 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/How-to-union-multiple-data-query-in-SAS-VA/m-p/202921#M1853 AnnaBrown 2015-06-12T14:49:59Z