METALIB Procedure

Example 4: Generating an Impact Analysis

Features:

IMPACT_LIMIT statement

REPORT statement

REPORT(TYPE=DETAIL) statement

To generate an impact analysis, specify IMPACT_LIMIT=0 and REPORT in PROC METALIB. The generated impact analysis shows which tables have associated Job or Transformation objects. Request a detailed report to determine which type of object is associated with each table. To update the tables regardless of impact, specify IMPACT_LIMIT with an integer representing the number of Transformation or Job objects returned.

IMPACT_LIMIT=0 and REPORT

The impact limit is set to zero. Any impact on a Job or Transformation object results in an impact limit exceeded entry in the output.
proc metalib;
   omr (libid=AZ000009);
   impact_limit=0;
   report;
run;
Default PROC METALIB Report with IMPACT_LIMIT=0
Summary Report of Tables That Have Associated Job or Transformation Objects

IMPACT_LIMIT=0 with REPORT (TYPE=DETAIL)

The detailed report identifies the type of object that is associated with each table.
proc metalib;
		OMR=(libid=AZ000009);
		impact_limit=0;
		report (type=detail);
run;
PROC METALIB Report with Report (Type=Detail)
Detailed Report of the Type of Object Associated with Each Table

IMPACT_LIMIT=2 and REPORT

Specifying that two objects can be affected (based on the previous example) allows PROC METALIB to modify the tables.
proc metalib;
		OMR=(libid=AZ000009);
		impact_limit=2;
		report;
run;
PROC METALIB Report with IMPACT_LIMIT=2
Report of Changes When Analysis Is Bypassed