BookmarkSubscribeRSS Feed
Obsidian | Level 7


In one of the report ( please see screen shot) i have a filter where values are more then 1000, but the VA is not displaying them, which is creating lots of issues in the Analysis,


is her a way to display all the values?


from the unlisted value my senior management want to select few and soe times all so what i need is following


1. is there a way to search the value ( as currently i am unable to search as VA throws an error if i want to search a value which is in unlisted bucket)

2. is there a way to search and select multiple values from the unlisted bucket as well from the main list?

3. can i display all

4. can i have another drop down filter where i can only display unlisted values from the previous filter?


many regards and thanks in advance to all who will respond

Lapis Lazuli | Level 10

Is it possible to another column to your table with additional catagorization.  For instance assign the station numbers to groups like (1000-1999, 2000-2999, 3000-3999) or prefilter to remove any stations that have smaller values? I realize this does not change the filters but it may allow you to better catagorize the data so the report drop-down could change it. 


Possibly it will just give you some ideas about how to resovle the issue.

Tricia Aanderud

Twitter: @taanderud - Follow me!

Obsidian | Level 7

and if the values are Character type?

Lapis Lazuli | Level 10

You can use the Custom Category option to organize the values.


Another option is to do it in SAS code.  If the station numbers look like numbers - then change it to a numeric value and create your new category.

Tricia Aanderud

Twitter: @taanderud - Follow me!



Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

Tips for filtering data sources in SAS Visual Analytics

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.

Discussion stats
  • 3 replies
  • 1 like
  • 2 in conversation