Administrator Tasks — Creating Metadata

Metadata Feature

In SAS/ASSIST software, Release 8.2, metadata is either generated at startup or generated prior to startup in batch mode. When users invoke the software, the batch- generated metadata is immediately available and can be appended to the metadata generated at startup by the user.

Metadata is created in batch mode by using an SQL program. A sample program is provided with SAS/ASSIST software, Release 8.2. It is located in the SASHELP library at SASHELP.QASSIST.METADICT.SOURCE. The batch program must also contain a list of LIBNAME statements. When a library is both defined in the batch program and assigned in a user session, metadata for data sources located in this library is made available to the user. Conversely, if a library is defined in the batch program but not assigned in an individual user session, data sources located in this library are not visible to this particular user.

The batch-generated metadata and the user-generated metadata are stored together in two SAS tables, _ASTDCOL and _ASTDTAB, which are automatically created in the SASUSER library the first time a user invokes the software.

The advantages of creating metadata in batch mode are

Use of resources is reduced when users invoke SAS/ASSIST software: If metadata is created at startup by the individual user, the software accesses all available data in order to gather information. Creating metadata in batch mode avoids the need for each user to access remote hosts in order to examine the data.
Metadata can be customized to suit the needs of individual users and groups: You can subset metadata generation in the sample program provided with Release 8.2 so that users only see metadata for the information they normally work with. This simplifies the process of searching for tables or columns.
Processing time is significantly reduced when users update metadata during a session: Creating metadata at startup can be time consuming, especially when a large number of tables are accessed or when data resides on remote hosts. Batch-generated metadata, however, is stored in two tables in a shared location. These tables are appended to the user-generated metadata.

Chapter Contents
Previous
Next
Top of Page