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

[hilal1422]

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?

[Sam_SAS]

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=n0333twliqddfu...

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

[hilal1422]

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.