Because DICTIONARY tables are SAS data views, you can use a DESCRIBE TABLE statement in PROC SQL, or you can use the SAS Explorer window to examine their contents. Depending on how you use SAS, some ...

The next SQL*Plus snippet demonstrates this in use ... of the useful queries one can construct from the Oracle Data Dictionary views ALL_CONSTRAINTS and ALL_USER_CONS_COLUMNS.

You can use a PROC SQL query to retrieve or subset data from a DICTIONARY table. You can save that query as a PROC SQL view for use later. Or, you can use the existing SASHELP views that are created ...