topic Re: Sort data in SAS Visual Analytics 8.3 list by the column that is not in list in SAS Visual Analytics

Sort data in SAS Visual Analytics 8.3 list by the column that is not in list

hilal1422 — Tue, 03 Sep 2019 12:24:03 GMT

Hi,

I am creating one report in SAS Visual Analytics 8.3 on SAS Viya(03.04) platform. I want to sort list and cross tab object by column that is not there in list and cross-tab. Custom sort is not applicable here because values are more than 25. Column that I want to sort has character values and when I sort it values are sorted alphabetically. I have created new column which has numerical sequence of those character values. Customer don't want to see sequence column in the list or cross tab they want character column but sorted in correct sequence.

e.g.

Sort_Column Sequence

19Jan 1

19Feb 2

19Mar 3

19Apr 4

.... ....

Can anyone suggest me how to achieve this?

Re: Sort data in SAS Visual Analytics 8.3 list by the column that is not in list

Sam_SAS — Tue, 03 Sep 2019 15:00:37 GMT

Hello,

In VA 8.4, you can sort on a hidden column although the way you do it is a little clunky:

https://documentation.sas.com/?cdcId=vacdc&cdcVersion=8.4&docsetId=vaobj&docsetTarget=n0333twliqddfun13b8uf13e1ubg.htm&locale=en#p0dmg3othhnr7hn11sfdg3qhlwx1

In 8.3, I don't think it is possible to sort on a column that is not displayed in the table.

That said, the values in your example appear to be date values. You could parse these values as dates and apply a date sort.

Sam

Re: Sort data in SAS Visual Analytics 8.3 list by the column that is not in list

hilal1422 — Wed, 04 Sep 2019 08:49:33 GMT

Hi Sam, I can see version number here as 8.3 only. I will check with SAS Admin to install 8.4

Thank you for your reply.