topic Re: Create filter from another data source in SAS Visual Analytics

Create filter from another data source

jpapaiac — Sun, 12 Jul 2015 22:16:26 GMT

I am creating a report and I need to create a filter using a variable from a different source. Both sources have a common key. If that is possible is there an example

Re: Create filter from another data source

TejaSurapaneni — Mon, 13 Jul 2015 05:12:08 GMT

Hello,

Unfortunately your requirement is not possible. Anyway can you explain bit more......

Which type of filter you want?

Thanks&Regards,

Teja Surapaneni.

Re: Create filter from another data source

Lorrie_SAS — Wed, 15 Jul 2015 20:39:35 GMT

Hi jpapaiac,

It sounds like a good solution for you would be to create a data query using the data builder (data preparation).

Here's some information about creating data queries:

SAS(R) Visual Analytics 7.2: User's Guide

You can also find information about filtering data here:

SAS(R) Visual Analytics 7.2: User's Guide

Best regards,

Lorrie

Re: Create filter from another data source

Explore_SAS — Thu, 16 Jul 2015 13:37:16 GMT

The Dataset from which you are creating a report, you want to filter that report using one of the column of another data set ?

I guess that is possible to do, Just add both datasets into your report. create report from your original data source then add a dropdown filter on section/report level and the assign the common column from another dataset to the dropdown.

The a prompt will appear that relation between to dataset, just map similar column between 2 datasets and I hope that will resolve your problem.