Manage Columns

Sometimes a table will contain many miscellaneous columns that your information map does not need to reference. To avoid cluttering your Selected Resources pane with these extraneous columns, you can omit them from the data source so that they are ignored by the application. For this scenario, you have decided that the EMPINFO data source references a few extraneous columns.
To omit the extraneous columns:
  1. Open the Employee Statistics Sample information map.
  2. In the SAS Information Map Studio main window, select the Design tab.
  3. In the Selected Resources pane, right-click the EMPINFO data source, and then select Properties from the pop-up menu.
  4. In the Table Properties dialog box, select the Columns tab.
  5. Select Specify columns to omit. In the Keep these columns list box, all of the columns for EMPINFO are displayed.
  6. The extraneous columns are ADDR1, ADDR2, DIVISION, STATUS, and EDLEV. Select these columns and then click Omit.
    Note: You are not allowed to omit columns that are being used by data items, filters, or relationships, so those items are not selectable.
    Columns tab in Table Properties dialog box
  7. Click OK. The columns that you omitted are no longer displayed in the Selected Resources pane.
    Selected Resources pane without omitted columns
Copyright © SAS Institute Inc. All rights reserved.