Search notes:
SAS dictionary tables
The SAS dictionary tables contain
metadata
. They are created during SAS' system startup.
The dictionary tables only can be accessed by
proc sql
and the reserved (longer than 8 character)
libname
dictionary
.
dictionary.dictionaries
The
metadata
about the dictionary tables itself is also stored in a dictionary table:
dictionary.dictionaries
.
The following statement returns all dictionary tables:
proc sql; select distinct memname from dictionary.dictionaries; quit;
Github repository
about-SAS
, path:
/programming/dictionary/dictionaries/show-members.sas
Some dictionaries
dictionary.catalogs
dictionary.check_constraints
dictionary.columns
dictionary.constraint_column_usage
dictionary.destinations
dictionary.dictionaries
dictionary.engines
dictionary.formats
dictionary.goptions
dictionary.libnames
dictionary.macros
dictionary.members
dictionary.options
dictionary.referential_constraints
dictionary.table_constraints
dictionary.tables
See also
SAS programming
Index