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:
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.
-------------------------------------------------------------------------
Four tips to remember when you contact SAS Technical Support
Tricks for SAS Visual Analytics Report Builders
SAS Visual Analytics Learning Center
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.formated
details
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.
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.