SQL DICTIONARY Tables for the Information Maps Engine

Using SQL DICTIONARY Tables

An SQL DICTIONARY table is a read-only SAS view that contains information about a SAS library or SAS data set. The Information Maps engine makes an information map appear like a SAS data set within a SAS library. For the engine, an information map contains one or more data items, as well as zero or more filters. The following SQL DICTIONARY tables are available for use in conjunction with the Information Maps engine:

DICTIONARY.INFOMAPS: contains metadata about the information maps that are available in the current SAS session
DICTIONARY.DATAITEMS: contains metadata about the data items that are defined in the available information maps
DICTIONARY.FILTERS: contains metadata about the filters that are defined in the available information maps

You can use the SQL procedure in Base SAS to query these tables and retrieve information about the information maps.

Top of Page