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>>);>
<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 |