Reference for the Metadata Engine

SAS Data Set Options for the Metadata Engine

Overview: METAOUT= Data Set Option

The METAOUT= data set option for the metadata engine specifies access to an individual table in the data source.

Note: While the METAOUT= data set option enables you to specify behavior for individual tables, you can use the METAOUT= argument for the LIBNAME statement to specify behavior for an entire library. However, for a library, the behavior applies to all members in the library, and remains for the duration of the library assignment. [cautionend]

Note: For library procedures such as PROC DATASETS, you must specify METAOUT= as an argument on the LIBNAME statement. You cannot specify it as a data set option. [cautionend]

Syntax: METAOUT= Data Set Option

METAOUT=ALL | DATA | DATAREG | META

Default:	ALL
Restriction:	The following descriptions refer to the physical table. Metadata is read-only with the metadata engine. When you create, update, or delete physical data with the metadata engine, you must perform an additional step if you want to update the metadata. You can use a product like SAS Management Console, or you can submit the METALIB procedure. For more information, see METALIB Procedure.
Interaction:	If metadata for a table is defined, any authorizations are enforced for that table, regardless of the METAOUT= value.

ALL

specifies that you can read, create, update, and delete observations in an existing physical table that is defined in metadata. You cannot create or delete a physical table. This is the default behavior.

Interaction:

The user is restricted to only the tables that have been defined in the repository.

DATA

specifies that you can read, create, update, and delete a physical table.

Interaction:

The user can access any table, regardless of whether it has been defined in the repository.

DATAREG

specifies that you can read, update, and delete a physical table that is defined in metadata. You can create a table, but you cannot read, update, or delete the new table until it is defined in metadata. This value is like ALL, but it adds the ability to create new tables.

Interaction:

The user is restricted to only the tables that have been defined in the repository.

META

specifies that you can read a physical table that is defined in metadata. You cannot create, update, or delete a physical table or observations. This value is like ALL, without the ability to create, update, and delete observations.

Interaction:	The user is restricted to only the tables that have been defined in the repository.
Caution:	The METAOUT=META value might not be supported in the future releases of the software.

OPTSET= Data Set Option

Overview: OPTSET= Data Set Option

If you do not specify the OPTSET= data set option, the default options for the constructed LIBNAME statement are used. For more information, see How the Metadata Engine Constructs Options. See also Examples: OPTSET= Data Set Option.

Syntax: OPTSET= Data Set Option

OPTSET=<">propertyset-object<">: specifies a PropertySet metadata object that is associated with the PhysicalTable object that corresponds to the table that is being referenced. The PropertySet object specifies data set options that will be applied to the table.

Top of Page