topic Re: SAS VA - how to filter on multiple values in a report in SAS Visual Analytics

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

gianfranco — Thu, 29 Apr 2021 07:18:52 GMT

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.

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

sbxkoenk — Sat, 01 May 2021 16:34:41 GMT

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.

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

sbxkoenk — Sat, 01 May 2021 16:44:24 GMT

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

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

SASKiwi — Sun, 02 May 2021 03:52:56 GMT

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.