DICTIONARY TABLES in Advanced SAS

SAS dictionary tables contain the data at the back the scenes in SAS a.k.a. the metadata. The dictionary tables are only directly available from PROC SQL. There is also a corresponding set of data step views but it is much less competent to use these due to where statements not are getting short of back to the dictionary tables. Following is a list of dictionary tables and their contents.

DICTIONARY.CATALOGS

 LIBNAME char(8) label='Library Name',

 MEMNAME char(8) label='Member Name',

 MEMTYPE char(8) label='Member Type',

 OBJNAME char(8) label='Object Name',

 OBJTYPE char(8) label='Object Type',

 OBJDESC char(40) label='Object Description',

 MODIFIED char(8) label='Date Modified',

 ALIAS char(8) label='Object Alias'

DICTIONARY.COLUMNS

 LIBNAME char(8) label='Library Name',

 MEMNAME char(8) label='Member Name',

 MEMTYPE char(8) label='Member Type',

 NAME char(8) label='Column Name',

 TYPE char(4) label='Column Type',

 LENGTH num label='Column Length',

 NPOS num label='Column Position',

 VARNUM num label='Column Number in Table',

 LABEL char(40) label='Column Label',

 FORMAT char(16) label='Column Format',

 INFORMAT char(16) label='Column Informat',

 IDXUSAGE char(9) label='Column Index Type'

DICTIONARY.EXTFILES

 FILEREF char(8) label='Fileref',

 XPATH char(80) label='Path Name',

 XENGINE char(8) label='Engine Name'

DICTIONARY.INDEXES

LIBNAME char(8) label='Library Name',

 MEMNAME char(8) label='Member Name',

 MEMTYPE char(8) label='Member Type',

 NAME char(8) label='Column Name',

 IDXUSAGE char(9) label='Column Index Type',

 INDXNAME char(8) label='Index Name',

 INDXPOS num label='Pos. of Column in Concatenated Key',

 NOMISS char(3) label='Nomiss Option',

 UNIQUE char(3) label='Unique Option'

DICTIONARY.MEMBERS

 LIBNAME char(8) label='Library Name',

 MEMNAME char(8) label='Member Name',

 MEMTYPE char(8) label='Member Type',

 ENGINE char(8) label='Engine Name',

 INDEX char(8) label='Indexes',

 PATH char(80) label='Path Name'

DICTIONARY.OPTIONS

 OPTNAME char(16) label='Session Option Name',

 SETTING char(200) label='Session Option Setting',

 OPTDESC char(80) label='Option Description'

DICTIONARY.TABLES

 LIBNAME char(8) label='Library Name',

 MEMNAME char(8) label='Member Name',

 MEMTYPE char(8) label='Member Type',

 MEMLABEL char(40) label='Dataset Label',

 TYPEMEM char(8) label='Dataset Type',

 CRDATE num format=DATETIME label='Date Created',

 MODATE num format=DATETIME label='Date Modified',

 NOBS num label='Number of Observations',

 OBSLEN num label='Observation Length',

 NVAR num label='Number of Variables',

 PROTECT char(3) label='Type of Password Protection',

 COMPRESS char(8) label='Compression Routine',

 REUSE char(3) label='Reuse Space',

 BUFSIZE num label='Bufsize',

 DELOBS num label='Number of Deleted Observations',

 INDXTYPE char(9) label='Type of Indexes'

DICTIONARY.VIEWS

 LIBNAME char(8) label='Library Name',

 MEMNAME char(8) label='Member Name',

 MEMTYPE char(8) label='Member Type',

 ENGINE char(8) label='Engine Name'

DICTIONARY.TITLES

 TYPE char(1) label='Title Location',

 NUMBER num label='Title Number',

 TEXT char(200) label='Title Text'

DICTIONARY.MACROS

 SCOPE char(9) label='Macro Scope',

 NAME char(8) label='Macro Variable Name',

 OFFSET num label='Offset into Macro Variable',

 VALUE char(200) label='Macro Variable Value'