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
The documentation states there is a limit of 25 data items you can specify in a custom sort:
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?
The documentation states there is a limit of 25 data items you can specify in a custom sort:
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?
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
Hi Rita,
Using the SAS Management Console, you can increase the limit for custom sort.
Login to the SMC.
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
Hi Torben,
Thank you. I have added that property.
The system will be restarted and fingers crossed it will work.
Thank you!
Cheers,
Rita
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
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.