SQL DICTIONARY Tables for the Information Maps Engine

DICTIONARY.DATAITEMS Table

The SQL DICTIONARY.DATAITEMS table contains a row for each data item in all of the information maps that are available through the Information Maps engine. The table contains the following variables:

LIBNAME: Information Maps engine libref for the information maps that contains the data item
MEMNAME: SAS name for the information map that contains the data item
NAME: SAS name for the data item
DATAITEMNAME: Data item name
ID: Data item ID
PATH: Location of the data item within the metadata server
CLASS: Classification of the data item
AGGREGATION: Default aggregate function for the data item
ISCALC: Flag to indicate whether the data item contains a calculated expression (YES or NO)
ISUSABLE: Flag to indicate whether the underlying data for data item is available (YES or NO)
DESCRIPTION: Description of the data item

The following example shows how you can query the DICTIONARY.DATAITEMS table to retrieve information about the available data items:

libname mymaps infomaps mappath="/Users/myUserID/My Folder";

proc sql;
   select d.memname, d.dataitemname, d.id, d.class
      from DICTIONARY.DATAITEMS as d;

Output from DICTIONARY.DATAITEMS Table Query

Member Name                       Data Item Name        Data Item ID          Classification
--------------------------------------------------------------------------------------------
Employee Statistics Sample        Name                  Name                  CATEGORY
Employee Statistics Sample        Identification        Identification        CATEGORY
                                  Number                Number
Employee Statistics Sample        Job Code              Jobcode               CATEGORY
Employee Statistics Sample        Department            Deptcode              CATEGORY
Employee Statistics Sample        Location              Location              CATEGORY
Employee Statistics Sample        Average Salary        Salary_2              MEASURE
Employee Statistics Sample        Minimum Salary        Salary2               MEASURE
Employee Statistics Sample        Maximum Salary        Salary3               MEASURE
Employee Statistics Sample        Sum of Salaries       Salary4               MEASURE
Employee Statistics Sample        Hire Date             Hire Date             CATEGORY
Employee Statistics Sample        Number of Years       Number of Years       CATEGORY
                                  Employed              Employed

Top of Page