Cedric Liem

  • Contact Me
  • About
  • Blog
    • Fatherhood
    • Personal
    • Small Business & Consulting
    • Brand Specialists
    • SAS Blog

SAS Dictionary Tables

April 3, 2017 By Cedric Liem Leave a Comment

This is a list of the SAS Dictionary Tables. These tables are accessible using PROC SQL or the corresponding SASHELP library. They are read-only and are useful to get information about libraries, datasets, system options, and other information relating to the current SAS session.

DICTIONARY NAMESASHELP
NAME
DESCRIPTION
CATALOGSVCATALGInformation on SAS catalogs.
CHECK_CONSTRAINTSVCHKCONInformation on known check constraints.
COLUMNSVCOLUMNMeta info on columns for all tables used in the session.
CONSTRAINT_COLUMN_USAGEVCNCOLUInformation about columns that are referred to by integrity constraints.
CONSTRAINT_TABLE_USAGEVCNTABUInformation about tables that have integrity constraints defined on them.
DATAITEMSVDATAITIinformation about known information map data items.
DESTINATIONSVDESTInformation about known ODS destinations.
DICTIONARIESVDCTNRYInformation about all DICTIONARY tables.
ENGINESVENGINEInformation about SAS engines.
EXTFILESVEXTFLInformation about known external files.
FILTERSVFILTERInformation about known information map filters.
FORMATSVFORMAT
VCFORMAT
Information about currently accessible formats and informats.
FUNCTIONSVFUNCInformation about currently accessible functions.
GOPTIONSGOPT
VALLOPT
Information about currently defined graphics options (SAS/GRAPH software). SASHELP.VALLOPT includes SAS system options as well as graphics options.
INDEXESVINDEXInformation about known indexes.
INFOMAPSVINFOMPInformation about known information maps.
LIBNAMESVLIBNAMInformation about currently defined SAS libraries.
MACROSVMACROInformation about currently defined macro variables.
MEMBERSVMEMBER
VSACCES
VSCATLG
VSLIB
VSTABLE
VSTABVW
VSVIEW
Information about all objects that are in currently defined SAS libraries. SASHELP.VMEMBER contains information for all member types; the other SASHELP views are specific to particular member types (such as tables or views).
OPTIONSVOPTION
VALLOPT
Information about SAS system options. SASHELP.VALLOPT includes graphics options as well as SAS system options.
REFERENTIAL_CONSTRAINTSVREFCONInformation about referential constraints.
REMEMBERVREMEMBContains information about known remembers.
STYLESVSTYLEInformation about known ODS styles.
TABLE_CONSTRAINTSVTABCONInformation about integrity constraints in all known tables.
TABLESVTABLEInformation about known tables.
TITLESVTITLEInformation about currently defined titles and footnotes.
VIEWSVVIEWInformation about known data views.
VIEW_SOURCESNot availableContains a list of tables (or other views) referenced by the SQL or DATASTEP view, and a count of the number of references.

Filed Under: SAS Blog

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

  • About
  • Contact Me

Copyright cedricliem.com 2009-2018.