As the first step in the decommissioning of sasCommunity.org the site has been converted to read-only mode.


Here are some tips for How to share your SAS knowledge with your professional network.


Tips:Exploiting the Metadata in SAS Dictionary Tables and Views

From sasCommunity
Jump to: navigation, search

The SAS Dictionary Tables and SASHELP Library Views contain a gold-mine of metadata about your SAS environment and the files that you have allocated in it. They contain information about SAS data sets, SAS variables, SAS catalogs, external files, formats, indexes, views, macros, and lots more. The beauty of SAS Dictionary Tables and SASHELP Library Views is that information contained in them can easily be used in your SAS programs because it resides in SAS data sets and tables. You only need to know which table or view to access in order to surface the information.

The best reference for understanding and exploiting SAS Dictionary Tables and Views is the see also link to the SUGI 29 paper: "Dictionary Tables and Views: Essential Tools for Serious Applications," by Frank DiIorio and Jeff Abolafia.

If you are not already familiar with this powerful set of at-your-fingertips metadata, you are going to be pleasantly surprised!

Submitted by Michael A. Raithel, The man who wrote the book on performance. Contact me at my Discussion Page.

....read more