Sorting based on a not shown column

blert — Thu, 08 Feb 2018 14:29:27 GMT

Hi,

We are facing a situation maybe you can help us with. We are using SAS Visual Analytics 7.3 (maybe in a higher version is possible).

In SAS VA Designer we would like to sort a "List Table" table object but based on a column not shown in the "List Table". It's a requirement not to show that sorting variable.

We tried to build a "Custom Order" but we are facing limitation to less or equal 25 categories whereas we have many more categories so it does not seem we can address our requirement apparently with this approach.

Is there any way to sort the "List Table" based on a hidden column or anything we can do to fulfill our requirement?

Regards,

Re: Sorting based on a not shown column

Mo_NHS — Fri, 09 Feb 2018 10:31:31 GMT

Option 1:
You can try sorting the table by the field you want before loading it to the LASR library and see if it works.
Option 2:
Link your report to a stored process that sorts the data and outputs the list you want in a new page

topic Re: Sorting based on a not shown column in SAS Visual Analytics

Sorting based on a not shown column

Re: Sorting based on a not shown column