- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
I have a report in SAS VA and I would like the users of the report to be able to filter on multiple values of an identifier: maybe a few values, maybe several hundreds.
Is there a way to to this in SAS VA? Maybe by importing an Excel or a csv with the list of values? Or by copy/pasting somewhere the list of values?
Thank you in advance for your help.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Hello,
I assume you want a 'Basic Report Filter'.
You can put a button bar with all your identifiers but a button bar only allows single selection.
Drop down lists allow multiple selections however!!
Instead of a button bar with all your identifiers: A similar look and feel can be achieved with a Tree Map where you use a measure that always returns 1, the Tree Map does allow multiple selection. Your Tree Map can filter another object.
See also the discussion in this entry:
Button Bar VA 8.2 - select more then 1 but less then All
Cheers,
Koen
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Or do you want your users to enter the ID's?
See
Paper SAS4138-2020
Data Entry in SAS® Visual Analytics: Is It Possible?
Xavier Bizoux, SAS Institute Inc.
https://www.sas.com/content/dam/SAS/support/en/sas-global-forum-proceedings/2020/4138-2020.pdf
You might need the
- Data-Driven Content (DDC) object AND
- the SAS Job Execution Web Application
in that case.
Good luck,
Koen
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Filtering on hundreds of values is unmanageable in an interactive user interface. Perhaps there is a way of grouping these values into a hierarchy of categories like this: State -> County -> zip / post code. Then you create the categories as separate list boxes and link them together. That means when you select a state or county you will only get the zip codes for that area. So a list of hundreds is then a list of say no more than 20 which is much more manageable.