How to View DICTIONARY Tables
About Dictionary Tables
You might want to view the contents of DICTIONARY tables in order to see information
about your current SAS session, before actually using the table in a DATA step or a SAS
Some DICTIONARY tables can become quite large. In this case, you might want to
view a part of a DICTIONARY table that contains only the data that you are interested
in. The best way to view part of a DICTIONARY table is to subset the table using a
PROC SQL WHERE clause.
How to View a DICTIONARY Table
Each DICTIONARY table has an associated PROC SQL view in the Sashelp library.
You can see the entire contents of a DICTIONARY table by opening its Sashelp view
with the VIEWTABLE or FSVIEW utilities. This method provides more detail than you
receive in the output of the DESCRIBE TABLE statement, as shown in “How to View a
Summary of a DICTIONARY Table” on page 690.
The following steps describe how to use the VIEWTABLE or FSVIEW utilities to view
a DICTIONARY table in a windowing environment.
1. Invoke the Explorer window in your SAS session.
2. Select the Sashelp library. A list of members in the Sashelp library appears.
3. Select a SAS view with a name that starts with V (for example, VMEMBER).
A VIEWTABLE window appears that contains its contents. (For z/OS, type the letter
'O' in the command field for the desired member and press Enter. The FSVIEW
window appears with the contents of the view.)
In the VIEWTABLE window the column headings are labels. To see the column names,
select View ð Column Names.
How to View a Summary of a DICTIONARY Table
The DESCRIBE TABLE statement in PROC SQL produces a summary of the contents
of a DICTIONARY table. The following example uses the DESCRIBE TABLE
statement in order to generate a summary for the table DICTIONARY.INDEXES. (The
Sashelp view for this table is Sashelp.VINDEX).
describe table dictionary.indexes;
The result of the DESCRIBE TABLE statement appears in the SAS log:
NOTE: SQL table DICTIONARY.INDEXES was created like:
create table DICTIONARY.INDEXES
libname char(8) label='Library Name',
memname char(32) label='Member Name',
690 Chapter 29 • DICTIONARY Tables