BookmarkSubscribeRSS Feed
Muandre
Obsidian | Level 7

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
3 REPLIES 3
Madelyn_SAS
SAS Super FREQ

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
Obsidian | Level 7

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.formatedformateddetailsdetails

acordes
Rhodochrosite | Level 12

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.

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

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.

Discussion stats
  • 3 replies
  • 875 views
  • 0 likes
  • 3 in conversation