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.

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register now

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