Customizing the SAS/Warehouse Administrator Interface

User-Defined Formats and Informats

On the Columns and Column Roles tabs, when you select the down control widget, the default pop-up lists displayed for formats and informats are as follows:

For FORMAT:     Type C:       SASHELP.FSP.FMTC.HELP
                Type N:       SASHELP.FSP.FMTN.HELP
                Unknown Type:   SASHELP.FSP.FMT.HELP

For INFORMAT:   Type C:       SASHELP.FSP.IFMTC.HELP
                Type N:       SASHELP.FSP.IFMTN.HELP
                Unknown Type:   SASHELP.FSP.IFMT.HELP

To provide your own pop-up list, SAS/Warehouse Administrator searches for the following entry names in the search path:

For FORMAT:     Type C:       USERFMTC
                Type N:       USERFMTN
                Unknown Type:   USERFMT

For INFORMAT:   Type C:       USERIFMC
                Type N:       USERIFMN
                Unknown Type:   USERIFM

The entry type for any of these user-defined entries can be either HELP, LIST, or MENU. (The SCL command that will be used is LISTC.) The value returned should be the selected format or informat character string.

These same pop-up lists are also used in the pop-up lists on the Add Column and Define Statistics for Analysis Columns frames (the frames driven from the Column Roles tab). The Expression Builder frame for defining derived mappings does not use these user-written pop-up lists.

Top of Page