Dictionary.Dictionaries

From sasCommunity

Dictionary.Dictionaries (v9) contains data structure (metadata) of all SQL dictionaries. Use this code to review all available dictionaries:

%Let List =;
proc SQL noprint; 
         select distinct 
                cats('describe table Dictionary.'
                    ,MemName,';')
         into   :List   separated by ' '
         from   Dictionary.Dictionaries;
         &List.
         quit;

This is the code that's in macro variable List:

describe table DICTIONARY.CATALOGS;
describe table DICTIONARY.COLUMNS;
...
describe table DICTIONARY.TABLES;
...
describe table DICTIONARY.VIEWS;