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
Hello,
Unfortunately your requirement is not possible. Anyway can you explain bit more......
Which type of filter you want?
Thanks&Regards,
Teja Surapaneni.
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
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.