Usage Note 43285: How SAS® Enterprise Guide® and the SAS® Add-In for Microsoft Office present data items from an information map
In SAS Enterprise Guide and the SAS Add-In for Microsoft Office, the order in which data items appear when you open an information map depends on which release of the software you are using.
Note: In SAS Enterprise Guide, this is the order in which the data items appear in the Available data items list. When using the SAS Add-In, this is the order in which the data items are inserted into a Microsoft Excel spreadsheet, for example.
Release 6.1 and SAS® 9.4 and later
The data items appear in the same order as they appear in SAS® Information Map Studio.
Release 5.1 and SAS 9.3_M2 and earlier
The data items are presented in the order in which they were originally added to the information map. This is the order in which the SAS Information Maps LIBNAME Engine
reads in the data. This means that the data items might not appear in the same order as they appear when you open the information map in SAS® Information Map Studio.
To determine the order in which data items appear in SAS Enterprise Guide and the SAS Add-In, you can submit the following code in a program window in SAS Enterprise Guide.