BookmarkSubscribeRSS Feed
deleted_user
Not applicable
I've created several Information Maps so that business users can easily import ( and refresh) the data in Excel. One Info. Map has just under 200 columns and there's a certain ordering of the columns that end users would prefer. I've tried to order the variables as I created the Maps but this ordering is not preserved when the users pull the data into an Excel spreadsheet.

I know a user can order the columns as the items from the Info. Map are selected but it would be nice if the default order is as they are in the Info. Map.

So, my question: Is it possible to preserve the order of the variables/colum when the Info. Map data is pulled into Excel ?

Thanks.
1 REPLY 1
AkilanR
Fluorite | Level 6

check this link http://support.sas.com/kb/20/672.html

Hope this will resolve your issue.

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

Discussion stats
  • 1 reply
  • 1160 views
  • 0 likes
  • 2 in conversation