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

Data item identifier

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