SAS VA - how to filter on multiple values in a report

[gianfranco]

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.

[sbxkoenk]

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

https://communities.sas.com/t5/SAS-Visual-Analytics/Button-Bar-VA-8-2-select-more-then-1-but-less-th...

Cheers,

Koen

[sbxkoenk]

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

[SASKiwi]

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.