Smart way to insert multiple values into a filter in a SAS VA report

Nmkristensen — Fri, 12 May 2023 11:40:08 GMT

I am trying to figure out the easiest way to insert multiple values into a filter in a SAS VA report.

For example, if I have a list of identification numbers for some customers in Microsoft Excel, which I need to insert into a filter in my report, how do I do it the easiest?

I do not want to enter each individual identification number in SAS VA one by one.

There must be a smart way. Unfortunately, I just can't figure it out myself.

Re: Smart way to insert multiple values into a filter in a SAS VA report

Sam_SAS — Fri, 12 May 2023 12:57:33 GMT

Hello,

There might be a better way, but one approach would be:

1. Using a text editor or some other means, make the list of values into a comma-separated list. If the values are numerics, they can be like this: 1,2,3 if they are character values they should be like this: 'ABC','DEF','GHI'. Using regular expressions in your text editor is one way to perform the formatting.

2. In VA, create an advanced filter with the IN() or NOTIN() operator and select the "text" view in the expression editor.

3. Copy-paste the comma-separated values into the IN or NOTIN operator in the VA expression editor window.

This should work and should allow you to add a large number of values if needed.

I don't know if there is a way to programmatically read in the values and compare them within VA, but you could do this in your data preparation stage if you don't mind the filter being "baked in" to your VA table.

Someone else might have other ideas.

Sam

topic Smart way to insert multiple values into a filter in a SAS VA report in SAS Visual Analytics

Smart way to insert multiple values into a filter in a SAS VA report

Re: Smart way to insert multiple values into a filter in a SAS VA report