Are you using proc template + gtl? If so there is dynamic variables - search this: http://support.sas.com/rnd/datavisualization/papers/sugi30/GTL.pdf
For dynamics as an example.
Unfortunately there isn't a way to have a dynamic data item control used in a report object. I raised this as a feature request in August 2013 with SAS Tech Support #77611064595. I envisage this may be very useful for people to use in reports where report objects roles can be dynamically assigned by the end user, similar to the variable selection list prompt type in SAS Enterprise Guide.
There is a way but it's not pretty. You have to load all the data in single column but use another field to indicate the record type. The first field can be used as an X axis and the record type can be set as a user selected filter. Its not ideal but it works.
This is a good requirement and we are planning for this kind of functionality in the future release. The idea is to empower business users with the ability to change the Measures, categories and filters, on a report object in a report, on-the-fly, without having to edit (re-author) the report. For example, end users can replace a measure or a category on a bar chart, from a list of variables and if satisfied, they can save this state of the report as a separate copy, without overwriting the original.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
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.