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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.