Want to display all my values in the filter

[TestingSAS]

Hi,

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

[TriciaAanderud]

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.

[TestingSAS]

and if the values are Character type?

[TriciaAanderud]

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

http://support.sas.com/documentation/cdl/en/vaug/67500/HTML/default/viewer.htm#n133d7vjj5losnn0zber8...

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.