METALIB Procedure

Example 3: Selecting Tables for Processing

Features:

SELECT statement

This example adds or updates metadata for a specific table.

Specify a table name. The SELECT statement identifies a table definition that contains the value MYTABLE in its SASTableName= attribute. Because the UPDATE_RULE statement is omitted, the default is to update or add the specified metadata. Therefore, if a MYTABLE definition does not exist, a new table definition is created.

proc metalib;
   omr (liburi="SASLibrary?@name='MyTestLibrary'");
   select (mytable);
   report;
run;

Specify a table ID.This example uses the SELECT statement, but specifies the table definition’s metadata identifier instead of its name. This syntax is preferred because metadata identifiers are unique. The first part of the two-part metadata identifier (A7892350) identifies the repository that contains the table definition. The second part (B00265DX) identifies the table definition in the repository.

proc metalib;
   omr (liburi="SASLibrary?@name='MyTestLibrary'");
  select (A7892350.B00265DX);
  report;
run;