Contents
About
Title Page
What's New in the SAS 9.3 Language Interfaces to Metadata
Accessibility Features of the SAS Language Interfaces to Metadata
Introduction
What Are the Metadata Language Elements?
Overview of Metadata Language Elements
When to Use Metadata Language Elements
What Can I Report on in a SAS Metadata Repository?
Using Language Elements That Read and Write Metadata
Overview of Using SAS Language Elements That Read and Write Metadata
Objects Included in the Dictionary
What is the SAS Type Dictionary?
How the Type Dictionary Affects SAS Language Elements
Metadata Object Identifiers and URIs
What Is a Metadata Identifier?
Obtaining Metadata Names and Identifiers
What Is a URI?
Examples: Using Metadata Language Elements to Create Reports
Overview of the Examples
Example: Creating a Report with the METADATA Procedure and the XML Engine
Example: Creating a Report with the DATA Step
System Options
Introduction to System Options for Metadata
Overview of System Options for Metadata
Connection Options
Encryption Options
Resource Option
System Options for Metadata
METAAUTORESOURCES System Option
METACONNECT= System Option
METAENCRYPTALG System Option
METAENCRYPTLEVEL System Option
METAPASS= System Option
METAPORT= System Option
METAPROFILE System Option
METAPROTOCOL= System Option
METAREPOSITORY= System Option
METASERVER= System Option
METASPN= System Option
METAUSER= System Option
Metadata LIBNAME Engine
Introduction to the Metadata LIBNAME Engine
Overview of the Metadata LIBNAME Engine
What Is Supported?
What Is Not Supported
Advantages of Using the Metadata Engine
The Metadata Engine and Authorization
How the Metadata Engine Constructs a LIBNAME Statement
Reference for the Metadata Engine
LIBNAME Statement for the Metadata Engine
SAS Data Set Options for the Metadata Engine
Examples for the Metadata Engine
Example: Submitting the LIBNAME Statement
Example: Before and After the Metadata Engine
Procedures
Introduction to Procedures for Metadata
Overview of Procedures for Metadata
Comparison of the METADATA Procedure and the METAOPERATE Procedure
METADATA Procedure
Syntax: METADATA Procedure
PROC METADATA
Overview: METADATA Procedure
Concepts: METADATA Procedure
Results: METADATA Procedure
Examples: METADATA Procedure
Example 1: Get Information about Metadata Repositories
Example 2: Change a Metadata Repository's Availability
Example 3: Filerefs with the IN= and OUT= Arguments
Example 4: Fileref to a Temporary File with the IN= Argument
Example 5: HEADER= Argument
Example 6: VERBOSE Argument
Example 7: Request the Metadata for One Object
Example 8: Request the Metadata for One Type of Object
Example 9: Use METHOD=STATUS to Get Backup Information
METALIB Procedure
Syntax: METALIB Procedure
PROC METALIB
OMR
EXCLUDE or SELECT
FOLDER= or FOLDERID=
IMPACT_LIMIT
NOEXEC
PREFIX
REPORT
UPDATE_RULE
Overview: METALIB Procedure
Concepts: METALIB Procedure
Results: METALIB Procedure with the REPORT Statement
Examples: METALIB Procedure
Example 1: Creating Metadata for a Data Source
Example 2: Synchronizing Metadata with the Data Source
Example 3: Selecting Tables for Processing
Example 4: Generating an Impact Analysis
Example 5: Adding a Prefix to New Metadata Names
Example 6: Specifying a Folder for the Metadata
METAOPERATE Procedure
Syntax: METAOPERATE Procedure
PROC METAOPERATE
Overview: METAOPERATE Procedure
Concepts: METAOPERATE Procedure
Examples: METAOPERATE Procedure
Example 1: Submitting ACTION=STATUS
Example 2: Submitting ACTION=PAUSE with a Pause Comment
Example 3: Submitting ACTION=REFRESH with ARM Logging
Example 4: Submitting ACTION=REFRESH to Pause and Resume the Metadata Server
Example 5: Submitting ACTION=RESUME
Example 6: Submitting ACTION=EMPTY
Example 7: Submitting ACTION=REFRESH with the Alert E-mail Test Option
Example 8: Submitting ACTION=REFRESH with Backup and Recover Options
DATA Step Functions
Introduction to DATA Step Functions for Metadata
Overview of DATA Step Functions for Metadata
Best Practices
Array Parameters
Understanding DATA Step Functions for Reading and Writing Metadata
What Are the DATA Step Functions for Reading and Writing Metadata?
Referencing a Metadata Object with a URI
Comparison of DATA Step Functions to Metadata Procedures
Examples: DATA Step Functions for Reading Metadata
DATA Step Functions for Reading and Writing Metadata
METADATA_DELASSN Function
METADATA_DELOBJ
METADATA_GETATTR Function
METADATA_GETNASL Function
METADATA_GETNASN Function
METADATA_GETNATR Function
METADATA_GETNOBJ Function
METADATA_GETNPRP Function
METADATA_GETNTYP Function
METADATA_GETPROP Function
METADATA_NEWOBJ Function
METADATA_PATHOBJ Function
METADATA_PAUSED Function
METADATA_PURGE Function
METADATA_RESOLVE Function
METADATA_SETASSN Function
METADATA_SETATTR Function
METADATA_SETPROP Function
METADATA_VERSION Function
Understanding DATA Step Functions for Metadata Security Administration
What Are the DATA Step Functions for Metadata Security Administration?
Transaction Contexts and URIs
Using the %MDSECCON() Macro
Examples: DATA Step Functions for Metadata Security Administration
DATA Step Functions for Metadata Security Administration
METASEC_APPLYACT Function
METASEC_BEGTRAN Function
METASEC_DELACT Function
METASEC_ENDTRAN Function
METASEC_GETACTA Function
METASEC_GETNACT Function
METASEC_GETNACTA Function
METASEC_GETNAUTH Function
METASEC_GETNID Function
METASEC_NEWACT Function
METASEC_REMACT Function
METASEC_SETACTA Function
METASEC_SETAUTH Function
Recommended Reading
Glossary
Product
Release
Base SAS
9.3
SAS Metadata Server
9.3
Type
Usage and Reference
Copyright Date
July 2011
Last Updated
28Aug2012