topic Re: Subquery in Visual Analytics in SAS Visual Analytics https://communities.sas.com/t5/SAS-Visual-Analytics/Subquery-in-Visual-Analytics/m-p/190951#M1395 <HTML><HEAD></HEAD><BODY><P>Hi prenderj,</P><P></P><P>As you suspect, the query can only be done using the Visual Analytics Data Builder or within Enterprise Guide prior to loading the result table into SAS Visual Analytics.</P><P></P><P>Kind Regards,</P><P>Michelle</P></BODY></HTML> Mon, 20 Oct 2014 19:51:04 GMT MichelleHomes 2014-10-20T19:51:04Z Subquery in Visual Analytics https://communities.sas.com/t5/SAS-Visual-Analytics/Subquery-in-Visual-Analytics/m-p/190950#M1394 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have two data sources one with a list of customers and other information (Data Source A - SAS table), and another with a list of customers to be excluded (Data Source B -Excel Doc).</P><P></P><P>Is it possible to write a report in Visual Analytics based on Data Source A which excludes customers that are in Data Source B i.e. is there a facility in VA to do a subquery?</P><P></P><P>Or can this only be done in the Data Builder or another tool such as Enterprise Guide.</P><P></P><P>I am using version 6.4M1 of Visual Analytics.</P><P></P><P>Any guidance would be great.</P></BODY></HTML> Mon, 20 Oct 2014 13:58:32 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Subquery-in-Visual-Analytics/m-p/190950#M1394 prenderj 2014-10-20T13:58:32Z Re: Subquery in Visual Analytics https://communities.sas.com/t5/SAS-Visual-Analytics/Subquery-in-Visual-Analytics/m-p/190951#M1395 <HTML><HEAD></HEAD><BODY><P>Hi prenderj,</P><P></P><P>As you suspect, the query can only be done using the Visual Analytics Data Builder or within Enterprise Guide prior to loading the result table into SAS Visual Analytics.</P><P></P><P>Kind Regards,</P><P>Michelle</P></BODY></HTML> Mon, 20 Oct 2014 19:51:04 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Subquery-in-Visual-Analytics/m-p/190951#M1395 MichelleHomes 2014-10-20T19:51:04Z Re: Subquery in Visual Analytics https://communities.sas.com/t5/SAS-Visual-Analytics/Subquery-in-Visual-Analytics/m-p/190952#M1396 <HTML><HEAD></HEAD><BODY><P>Thanks Michelle.</P></BODY></HTML> Tue, 21 Oct 2014 13:53:01 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Subquery-in-Visual-Analytics/m-p/190952#M1396 prenderj 2014-10-21T13:53:01Z