SAS VIYA VA: export data to excel - specific order in details

[Muandre]

Hi,

I want to export my data from a list table to excel. When I export detailed data, they are sorted in alphabetical order, not in the specific order that I want. How can I change that?

My SAS version:

SAS® Visual Analytics, Release: 8.5.1

SAS® Viya® Release: V.03.05

Thank you!

Muandre

[Madelyn_SAS]

When you export detailed data, the columns are in alphabetical order. They are automatically placed in that order when the additional columns are added to the list. 

[Muandre]

Is it possible to change this automatically order? I need the order I see in my list.
And I need the detailed data, because I want to export all the rows in my data list.formateddetails

[acordes]

I think to order you see in VA is respected as well when exporting to excel.

Have in mind that you can order (toggle by descending | ascending clicking on the column) by several columns. Get this activated by holding ctrl while clicking additional columns to be sorted for.