METALIB Procedure

Requirements: The SAS Metadata Server must be running. The SAS library must already be defined in the metadata by using a product such as SAS Management Console or SAS Data Integration Studio.

If the data source is ADABAS, you must set the META_ADABAS environment variable to 1.

A user must have WriteMetadata permission to the SAS Metadata Repository and WriteMemberMetadata permission to the target SAS folder to create metadata. In addition, the user must have ReadMetadata permission to update metadata.

Syntax

PROC METALIB;
OMR <=> (library-identifier <server-connection-arguments>);
<EXCLUDE <=> (table-specification <table-specification-n>);>
| <SELECT (table-specification <READ=read-password>
<table-specification-n <READ=read-password-n>>);>
<FOLDER= "/pathname"; > | <FOLDERID= "identifier.identifier";>
<IMPACT_LIMIT = n;>
<NOEXEC;>
<PREFIX <=> <">text<">;>
<REPORT <<=> (report-arguments)>;>
<UPDATE_RULE <=> (<DELETE> <NOADD> <NODELDUP> <NOUPDATE>);>

Table of Procedure Tasks

Statement Task Example
PROC METALIB Statement Update metadata in the metadata server to match the tables in a library Ex. 1
OMR Statement Specify the data source and server connection parameters Ex. 1
EXCLUDE or SELECT Statement Exclude or select a table, or a list of tables, for processing Ex. 3
FOLDER= or FOLDERID= Statement Specify where new metadata is stored in SAS folders Ex. 6
IMPACT_LIMIT Statement Specify the maximum number of Job or Transformation objects that can be affected by updates to table definitions Ex. 4
NOEXEC Statement Suppress the metadata changes from being made Ex. 4
PREFIX Statement Specify a text string to add to the beginning of all new metadata object names Ex. 5
REPORT Statement Create a report that summarizes metadata changes Ex. 2
UPDATE_RULE Statement Override default update behavior Ex. 2