5、Mastering SAS SQL: Using Dictionary Tables and Joins

Mastering SAS SQL: Using Dictionary Tables and Joins

1. Introduction to Dictionary Tables

Metadata serves as a description or definition of data or information. In SAS, session metadata is stored in Dictionary tables. These are special, Read - Only SAS tables that hold information about SAS libraries, data sets, macros, and external files available in the current SAS session. They also contain settings for SAS system options, titles, and footnotes.

1.1 Key Features of Dictionary Tables

• Creation : They are created each time they are referenced in a SAS program.
• Update : Automatically updated.
• Access : Limited to Read - Only access.

When y