Posted By

sarathannapareddy on 07/30/09


sql tables dictionary views proc Dictionarytables SASHELP Vcolumn Vtable DictionaryCoulumns VEXTFL VLIBNAM VTITLES

Versions (?)

Dictionary Tables and SASHELP Views (SAS metadata)

 / Published in: SAS


Most of the SAS programmers think that the Metadata concepts (Dictionary tables and SASHELP views) are advanced SAS topics, in fact it is not.

I tried here to explain the concept precise and clear……

Here, I will cover the following topics……

Introduction to SAS metadata How to see what’s in the tables How to use the tables, using several real-world examples Advantages

What are Dictionary Tables4?

  1. Dictionary tables are created and automatically maintained by SAS system at run time to store information related to SAS data libraries, SAS system options, SAS catalogs, and external files associated with the currently running SAS session. CATALOGS, COLUMNS, EXTFILES, INDEXES, MEMBERS, MACRO, OPTIONS, TABLES, TITLES, AND VIEW are these objects which provide detailed information about the SAS files.
  3. DICTIONARY tables are special read-only PROC SQL tables. They retrieve information about all the SAS data libraries, SAS data sets, SAS system options, and external files that are associated with the current SAS session.
  5. PROC SQL automatically assigns the DICTIONARY libref. To get information from DICTIONARY tables, specify DICTIONARY.table-name in the FROM clause.
  7. Read more at:

Report this snippet  

You need to login to post a comment.