A00-250 practice question 12 of 15

Select the method for updating table meta data that provides for the most control over updating features and can be run in batch.

Full set: 65 questions
Answer options
A: Update Metadata option in Data Library Manager in SAS Management Console.
B: Update Library Metadata task in SAS Enterprise Guide.
C: Update Metadata option in SAS Data Integration Studio.
D: METALIB procedure using SAS code. Correct answer
Correct Answer:
D. METALIB procedure using SAS code.
Explanation

The METALIB procedure (PROC METALIB) is a SAS code-based utility for creating and updating metadata for SAS libraries and tables. Because it is executed as SAS code, it offers the most granular control over the update process through its various statements and options (e.g., UPDATERULE=, SELECT=, DELETE). This allows for precise specification of which tables to update, add, or remove from metadata. As a standard SAS procedure, it can be saved in a .sas program file and executed in batch mode, satisfying both requirements of the question.

Why Incorrect

A. This is a GUI-driven wizard in SAS Management Console. It is designed for interactive use and offers less granular control over the update process compared to code.
B. This is a point-and-click task within SAS Enterprise Guide. It is intended for interactive sessions and lacks the extensive customization and batch-native capabilities of PROC METALIB.
C. This is an interactive wizard within SAS Data Integration Studio. While jobs can be scheduled, this specific function is for interactive development and does not provide the deep control of a procedure. ---

References

1. SAS Institute Inc. (2020). SAS® 9.4 Language Interfaces to Metadata, Fifth Edition.

Location: Chapter 5, "METALIB Procedure".

Content: This chapter details the syntax and options for PROC METALIB. It explicitly states, "The METALIB procedure enables you to use the SAS language to create and update metadata for SAS libraries and tables... Because PROC METALIB is a SAS procedure, you can incorporate it into a SAS program and run it in batch." The numerous options described, such as UPDATERULE=, SELECT=, and DELETE, demonstrate the high degree of control available.

2. SAS Institute Inc. (2018). SAS® 9.4 Intelligence Platform: System Administration Guide, Fourth Edition.

Location: Chapter 12, "Registering and Updating Tables in SAS Management Console".

Content: This section describes the GUI-based "Update Metadata" wizard for SAS libraries. The process is presented as a series of interactive steps ("In the wizard, select the tables that you want to update..."), which contrasts with the batch-capable, code-driven nature of PROC METALIB.

3. SAS Institute Inc. (2020). SAS® Enterprise Guide® 8.3: User’s Guide.

Location: Chapter 11, "Working with Data," Section "Updating Table Metadata for a Library".

Content: This guide describes the "Update Library Metadata" task as an interactive tool within the SAS Enterprise Guide interface. The user selects a library and clicks a button to invoke a dialog box, confirming its design for interactive use rather than batch processing with fine-tuned control.

Scroll to Top