The INFOMAPS Procedure

LIST Statement

Lists the key properties of business data in the current information map. The definitions are printed to the SAS log or to the computer console.

LIST <DATAITEMS | DATASOURCES | FILTERS |RELATIONSHIPS | _ALL_>;

Options

DATAITEMS

lists the properties of all the data items defined in the current information map. The properties include the name, ID, folder location, description, expression text, expression type, classification, format, and the default aggregation (if the classification is a measure) of each data item.

DATASOURCES

lists the properties of all the data sources defined in the current information map. The properties include data source (library.physical-table), data source ID, table or cube name, and description.

FILTERS

lists the properties of all the filters defined in the current information map. The properties include the name, ID, folder location, description, and the conditional expression text of each filter.

RELATIONSHIPS

lists the properties of all the relationships that are defined in the current information map. The properties include the ID, left table, right table, cardinality, join type, and the join expression text.

_ALL_

lists the properties of all the data items, filters, data sources, and relationships defined in the current information map.

Default:

_ALL_ is the default if you do not specify an option.

Example

The following output shows the result of submitting the LIST statement for the information map in Example: Using the INFOMAPS Procedure and the Information Maps Engine.

Log the LIST Statement

1/* List all of the properties of the current information map. */
2   list;

Total datasources: 3

    Data source: HR.EMPINFO
    ID: Empinfo
    Name: EMPINFO
    Description:

    Data source: HR.JOBCODES
    ID: Jobcodes
    Name: JOBCODES
    Description:

    Data source: HR.SALARY
    ID: Salary
    Name: SALARY
    Description:

Total data items: 9

    Data item name: Annual Salary
    ID: Annual Salary
    Folder: /Salary Info
    Description: Physical column SALARY
    Expression: <<Salary.Salary>>
    Expression type: NUMERIC
    Classification: MEASURE
    Format: DOLLAR12.
    Default aggregation: Sum

    Data item name: Department Code
    ID: Dept_code
    Folder: /
    Description:
    Expression: SUBSTRN(<<root.Jobcode>>, 1, 3)
    Expression type: CHARACTER
    Classification: CATEGORY
    Format:

    Data item name: Division
    ID: Division
    Folder: /
    Description: Physical column DIVISION
    Expression: <<Empinfo.DIVISION>>
    Expression type: CHARACTER
    Classification: CATEGORY
    Format:

    Data item name: Enddate
    ID: Enddate
    Folder: /Salary Info
    Description: Physical column ENDDATE
    Expression: <<Salary.ENDDATE>>
    Expression type: DATE
    Classification: CATEGORY
    Format: DATE9.

    Data item name: Identification Number
    ID: Identification Number
    Folder: /
    Description: Physical column IDNUM
    Expression: <<Empinfo.Identification Number>>
    Expression type: NUMERIC
    Classification: CATEGORY
    Format: SSN11.

    Data item name: Jobcode
    ID: Jobcode
    Folder: /
    Description: Physical column JOBCODE
    Expression: <<Empinfo.JOBCODE>>
    Expression type: CHARACTER
    Classification: CATEGORY
    Format:

    Data item name: Location
    ID: Location
    Folder: /
    Description: Physical column LOCATION
    Expression: <<Empinfo.LOCATION>>
    Expression type: CHARACTER
    Classification: CATEGORY
    Format:

    Data item name: Monthly Salary
    ID: Monthly Salary
    Folder: /Salary Info
    Description:
    Expression: <<Salary.Salary>>/12
    Expression type: NUMERIC
    Classification: CATEGORY
    Format: DOLLAR12.

    Data item name: Title
    ID: Title
    Folder: /
    Description: Physical column TITLE
    Expression: <<Jobcodes.TITLE>>
    Expression type: CHARACTER
    Classification: CATEGORY
    Format: $F20.

Total filters: 4

    Filter name: Cary HQ
    ID: Cary HQ
    Folder: /
    Description: Located in Cary, North Carolina HQ
    Expression:  <<root.Location>>='Cary'

    Filter name: Education and Publications
    ID: Education and Publications
    Folder: /
    Description: Employees in Education and Publications
    Expression: SUBSTRN(<<root.Jobcode>>, 1, 3) IN ('EDU','PUB')

    Filter name: Host Systems Development
    ID: Host Systems Development
    Folder: /
    Description: Employees in Host Systems Development
    Expression:  <<root.Division>>='HOST SYSTEMS DEVELOPMENT'

    Filter name: Status is Current
    ID: Status is Current
    Folder: /Salary Info
    Description:
    Expression: <<root.Enddate>> IS NULL

Total Relationships: 2

    Relationship ID: JOIN_10
    Left table: HR.EMPINFO
    Right table: HR.JOBCODES
    Cardinality: UNKNOWN
    Join type: INNER
    Join expression: (<<Empinfo.JOBCODE>>=<<Jobcodes.JOBCODE>>)

    Relationship ID: JOIN_11
    Left table: HR.EMPINFO
    Right table: HR.SALARY
    Cardinality: UNKNOWN
    Join type: INNER
    Join expression: (<<Empinfo.Identification Number>>=<<Salary.Identification Number>>)

90   run;

Top of Page