Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Subquery in Visual Analytics

Reply
Occasional Contributor
Posts: 9

Subquery in Visual Analytics

Hi,

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).

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?

Or can this only be done in the Data Builder or another tool such as Enterprise Guide.

I am using version 6.4M1 of Visual Analytics.

Any guidance would be great.

Super User
Posts: 1,205

Re: Subquery in Visual Analytics

Hi prenderj,

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.

Kind Regards,

Michelle

Occasional Contributor
Posts: 9

Re: Subquery in Visual Analytics

Thanks Michelle.

Post a Question
Discussion Stats
  • 2 replies
  • 320 views
  • 3 likes
  • 2 in conversation