The DICTIONARY tables component is specified in the FROM clause of a SELECT statement. DICTIONARY is a reserved libref for use only in PROC SQL. Data from DICTIONARY tables are generated at run time.

This example uses DICTIONARY tables to show a list of the SAS files in a SAS data library. If you do not know the names of the columns in the DICTIONARY table that you are querying, use a DESCRIBE ...

Some of those tools include Visual Studio, Toad, Oracle SQL Developer, etc. However, sometimes you just want to run a script to fetch the data dictionary. Perhaps you want to modify the script to log ...

Then, use tools like SQL queries, data profiling, and metadata extraction to explore databases, files, tables ... and locations in a structured data dictionary. Regularly update this documentation ...