This package contains a new task that reports on and updates library metadata using the METALIB procedure. It replicates some of the function of the Import Tables feature in SAS Management Console.

SAS libraries that are defined in metadata can contain definitions for tables (SAS datasets or views) that reside in those libraries. Some SAS BI applications (such as SAS Information Map Studio) hold it as an absolute requirement that those tables are registered in metadata before they can be used.

Other applications that utilize the META libname engine, such as SAS Enterprise Guide and SAS Add-In for Microsoft Office, can use metadata libraries in a special mode such that tables that are physically present in the library are automatically surfaced. By default though, these applications show only those tables that are registered in metadata.

The typical methods for registering tables are:

• Use SAS Management Console to Import Tables.
• Use Data Integration to register the tables as part of an ETL process.
• With SAS 9.1.3 Service Pack 3, programmatically registering tables, and synchronizing metadata about existing tables, using PROC METALIB. This task uses that mechanism.

Activities supported by this task:

• Report on contents of a library, as far as metadata is concerned.
• Report on differences between physical tables and what is in metadata.
• Synchronize metadata entries with what is in the physical tables.
• Option: -- sychronize just tables currently defined in metadata, or synchronize and add new tables that might be present.
• Delete obsolete entries from metadata -- those tables that no longer exist.

Update Library Metadata -- Add-on Task for Enterprise Guide Download Packages

Update Library Metadata -- Add-on Task for Enterprise Guide download package is listed by platform in the table below. Selecting the Request Download button will allow you to see the license terms and download Update Library Metadata -- Add-on Task for Enterprise Guide.

Update Library Metadata -- Add-on Task for Enterprise Guide Platforms Description File Name Size Release Date README Formats   Windows This task reports on and updates library metadata using PROC METALIB. It replicates some of the function of the Import Tables feature in SAS Management Console. SASMetalibWizard.zip 23 KB 2007-05 pdf, txt

To view PDF files, you need the free Adobe Acrobat Reader

For questions you may have about this product, please contact our Product Support Group