Usage Note 44271: Managing column names for output data sets created by SAS® Enterprise Guide® from SAS® Information Maps
When you open an information map in SAS Enterprise Guide, the Available data items list in the Open Information Map dialog box displays the values assigned to the Data item name property in the information map.

However, the names that you see in this dialog box are not used to create the column names in the output data set. Instead, the column names are derived either from the data item ID or the data item Description. The choice depends on whether you have selected the Use labels for columns names option in SAS Enterprise Guide.
Note: Data item names are not used because they are not guaranteed to be unique.
For example, suppose that the Student Age data item has the following properties in the information map:
- The Data item name is
Student Age
.
- The ID is
Age
.
- The Description is
Age information
.
If you do not select the Use labels for columns names option, then the column Name is the ID from the information map (Age
).

If you look at the column properties, you also see that the Label is the Description from the information map (Age information
).

If you want the column names to match the data item names, you can modify the information map to use the same text for both the data item Name and the data item Description. So, continuing with the example, you might modify the Student Age data item as follows:
- The Data item name is
Student Age
.
- The ID is
Age
.
- The Description is
Student Age
.
After you make this change, the column properties look like this:

Now, if you select the Use labels for column names option, the column name in the output data set matches the name that you see in the Open Information Map dialog box.

Note: To access the
Use labels for column names option, select
Tools ► Options ► Data General.
Operating System and Release Information
SAS System | SAS Enterprise Guide | Microsoft® Windows® for x64 | 4.2 | | 9.2 TS2M0 | |
Microsoft Windows Server 2003 Datacenter Edition | 4.2 | | 9.2 TS2M0 | |
Microsoft Windows Server 2003 Enterprise Edition | 4.2 | | 9.2 TS2M0 | |
Microsoft Windows Server 2003 Standard Edition | 4.2 | | 9.2 TS2M0 | |
Microsoft Windows Server 2003 for x64 | 4.2 | | 9.2 TS2M0 | |
Microsoft Windows Server 2008 for x64 | 4.2 | | 9.2 TS2M0 | |
Microsoft Windows XP Professional | 4.2 | | 9.2 TS2M0 | |
Windows Vista | 4.2 | | 9.2 TS2M0 | |
Windows Vista for x64 | 4.2 | | 9.2 TS2M0 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Date Modified: | 2011-09-13 11:53:48 |
Date Created: | 2011-09-12 16:53:20 |