Hi All,
this is a bit of a random question.
I am interested in selecting the data that is displayed in a graph using lists. Because this list, have several levels, in the ideal world the user could use something like this:
However, I do not think SAS VA currently allows for this.
So far I have two alternatives.
1- Multiple lists one for each level. It just gets a bit messy for the user to know what value is within each level.
2- Cross tab and hierarchy. This way the user can drill down to the different levels and by clicking in the number (measure), the filter will be activated. Although, this produce somehow the outcome, it would ideal to have something prettier, clear and easier to use (particular when you want to select multiple values within different levels of a list).
As I said, it is a bit of a random request.
Cheers,
Rita
I would go for the first one with multiple lists, one for each level and create interactions between them so that the sublists filters due to the selections in the lists above.
I have tried the cross tab, but as you say it a bit clumsy to use just for selection of the data.
//Fredrik
Thanks Fredrik.
I will show both to the user and let him decide what he prefers. Definitely a case of cleaner or more functionality.
Cheers,
Rita
Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!
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.