METALIB Procedure

Example 1: Synchronizing Metadata with the Data Source

Procedure features:

OMR statement with LIBID value

Default connection properties

UPDATE_RULE statement with DELETE argument

REPORT statement with MATCHING argument

Other features:

ODS

This example adds, updates, and deletes metadata to match the physical tables in a SAS library.

ods listing close;
ods html body="c:\test\updatereport.html";

proc metalib;

   omr (libid="A58LN5R2.AP000001" );

   update_rule=(delete);

   report(matching);
run;

ods html close;
ods listing;

[untitled graphic]