Only the 500 most frequent values are listed

[bobbyfajardo]

I am using the Path Analysis data object in SAS Visual Analytics version 8.4. I assigned a categorical variable with 3,000 observations, and I can only see the 500 most frequent observations(values). 

For example, default SAS report threshold will not allow me to find all observations beginning with “MATH”. Here are the problems that I’m currently seeing.

These are observations that exist in the categorical variable:

I need to be able to select the highlighted observations from above picture inside the path filter list below. But I’m only able to see at maximum 500 observations.  Those observations above are not visible here:

Please let me know if I can describe in more detail to help.

Thank you, Robert

[Sam_SAS]

Hi Robert,

It looks like you are encountering a limit on the value selector for the Path Filter dialog.

A workaround that you could try:

1. Temporarily create a data source filter to select only values that begin with "MATH". (Create a Data Source Filter )

2. Create your path filter. Hopefully at this point you will be able to select all the values you want.

3. Remove the data source filter. The path filter should remain in effect and in theory you should get the desired result.

Let us know if that helps,

Sam

[rodrigo_pereira]

Hi,

is it possible to change this configuration (to 1.500 rows limit) anywhere in the environment manager? 

I am working with the release V.03.05 and I would like to change this parameter to be able to create a custom category on a category with 1.200 cardinality.

Your help is much appreciated.

BRs,

Rodrigo

[Madelyn_SAS]

You might be able to get around the limitation by creating a custom category from a data selection. 

Create a Custom Category from a Data Selection