topic Re: Only the 500 most frequent values are listed in SAS Visual Analytics

Only the 500 most frequent values are listed

bobbyfajardo — Thu, 08 Apr 2021 19:57:57 GMT

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

Re: Only the 500 most frequent values are listed

Sam_SAS — Fri, 09 Apr 2021 14:26:19 GMT

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

Re: Only the 500 most frequent values are listed

rodrigo_pereira — Tue, 14 Dec 2021 08:53:22 GMT

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

Re: Only the 500 most frequent values are listed

Madelyn_SAS — Tue, 14 Dec 2021 15:53:44 GMT

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