topic Re: Custom sort, is there a limit for the number of levels within the sorting in SAS Visual Analytics

Custom sort, is there a limit for the number of levels within the sorting

rmalcata — Thu, 08 Mar 2018 21:23:04 GMT

Hi,

I am using SAS VA 7.4 and have been able to use custom sort. The variable that I am trying to sort has 60 different levels and while I was editing my custom sort, after a certain number of levels, I could not longer pass them to the column on the right.

Does SAS limits the number of levels in the custom sort?

If not, can you please advice what may be happening.

Thaks

Rita

Re: Custom sort, is there a limit for the number of levels within the sorting

SASKiwi — Thu, 08 Mar 2018 23:29:10 GMT

The documentation states there is a limit of 25 data items you can specify in a custom sort:

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

An alternative approach would be to use user-defined formats to remap the order of the data. Unfortunately VA will still sort the formatted values in alphabetic order so you need to prefix the values with A, B C or 1, 2, 3 to get the required order.

What type of report do you want to use the custom sort on?

Re: Custom sort, is there a limit for the number of levels within the sorting

rmalcata — Thu, 08 Mar 2018 23:47:35 GMT

Hi I would like to sort a list of location from north to south and not alphabetical. But it is fine. At least now, I know that 25 is limit and I can get most of them done, with the combination between the custom sort and alphabetical.

Thanks!

Rita

Re: Custom sort, is there a limit for the number of levels within the sorting

Torben_Skov_SAS — Tue, 07 Aug 2018 12:37:19 GMT

Hi Rita,

Using the SAS Management Console, you can increase the limit for custom sort.

Under Plugins browse to

Application Management -> Configuration Manager -> SAS Application Infrastructure -> Visual Analytics 7.4

Right click Visual Analytics 7.4 and select properties.

Select the Advanced tab.

Add the following Property Name va.CustomSortMaxValueLimit and assign it the desired value.

I've had no problems setting it to 100.

You must restart the SAS services for the change to take effect.

Torben

Re: Custom sort, is there a limit for the number of levels within the sorting

rmalcata — Tue, 07 Aug 2018 20:40:45 GMT

Hi Torben,

Thank you. I have added that property.

The system will be restarted and fingers crossed it will work.

Thank you!

Cheers,

Rita