METALIB Procedure

OMR Statement

Specifies the data source and connection parameters for the SAS Metadata Server.

OMR <=> (LIBID=<">identifier<"> | LIBRARY=<">name<"> | LIBRARY="/folder-pathname/name" | LIBURI="URI-format"

<server-connection-arguments>);

LIBID=<">identifier<"> | LIBRARY=<">name<"> | LIBRARY="/folder-pathname/name" | LIBURI="URI-format"

specifies a SASLibrary object, which defines a SAS library. This SAS library contains the tables whose metadata is updated.

Restriction:

In SAS Management Console, avoid the Pre-assigned Library template. When you pre-assign a library, choose the resource template that is specific to the type of data source library you are creating, and select the This library is pre-assigned check box. The Pre-assigned Library template is intended for certain system libraries only, and it will not work for other libraries. In addition, for PROC METALIB, you must submit the library pre-assignment in the current SAS session. You can store the LIBNAME statement in an autoexec file, or you can submit the LIBNAME statement in your SAS session before you submit the procedure.

LIBID=<">identifier<">

specifies the 8-character metadata identifier of the SASLibrary object that represents the library. The 8-character identifier is the second half of the 17-character identifier. For more information, see Metadata Object Identifiers and URIs.

LIBRARY=<">name<">

specifies the value in the SASLibrary object's Name= attribute. If you have more than one library with the same name, but they are stored in different SAS folders, then you must use the folder-pathname syntax.

LIBRARY="/folder-pathname/name"

specifies the folder pathname and the value in the SASLibrary object's Name= attribute. The pathname is the object's location in a SAS folder. The pathname begins with a forward slash. An example is library="/Users/Dmitri/My Folder/test/mylib" . For more information about how PROC METALIB uses folders, see FOLDER or FOLDERID Statement.

LIBURI="URI-format"

specifies a URI, which is a standard from SAS Open Metadata Architecture. For more information, see Metadata Object Identifiers and URIs. The following URI formats are supported:

LIBURI="identifier.identifier": specifies the full 17-character metadata identifier, which references both the repository and the object. This syntax is equivalent to specifying both LIBID= and REPID=. An example is liburi="A58LN5R2.A9000001".
LIBURI="SASLibrary/identifier.identifier": specifies the SASLibrary object type, followed by the full 17-character metadata identifier. This syntax is equivalent to specifying both LIBID= and REPID=. An example is liburi="SASLibrary/A58LN5R2.A9000001".
LIBURI="SASLibrary?@attribute='value'": specifies the SASLibrary object type, followed by a search string. Examples are liburi="SASLibrary?@libref='mylib'" and liburi=" SASLibrary?@engine='base'".

Requirement:

You must enclose the LIBURI= value in quotation marks.

Note: SAS Data Integration Studio can process Work tables that exist temporarily in the Work library. The metadata type is WorkTable. Usually, Work tables are not assigned to a library and have no library metadata, but they do have table and column metadata. A Work table that results from a generated transformation can be dynamic in nature. In other words, its structure might be modified by the transformation. PROC METALIB can be used to update the metadata to match the Work table.

If there is no library assignment, submit a blank library specification and identify the Work table with the SELECT statement. Here is an example with a blank library specification:

proc metalib;
    omr (libid="" repid="A5O7HLNB");
    select ("A5O7HLNB.A9000001");
run;

Server Connection Arguments

The server connection arguments establish communication with the metadata server. If you omit these arguments, then the values of the system options are used, or the values can be obtained interactively. For more information, see Connection Options.

PASSWORD=<">password<">

is the password for the authorized user ID on the metadata server. If you do not specify PASSWORD=, the value of the METAPASS= system option is used; for more information, see METAPASS= System Option. The maximum length is 256 characters.

Alias:

METAPASS=
PW=

PORT="number"

is the TCP port that the metadata server listens to for connections. This port number was used to start the metadata server. If you do not specify PORT=, the value of the METAPORT= system option is used; for more information, see METAPORT= System Option. The default for the METAPORT= system option is 8561. The range is 1-65535.

Alias:	METAPORT=
Requirement:	The value must be enclosed in quotation marks.

PROTOCOL=BRIDGE

specifies the network protocol for connecting to the metadata server. If you do not specify PROTOCOL=, the value of the METAPROTOCOL= system option is used; for more information, see METAPROTOCOL= System Option. In this release, the only supported value is BRIDGE, which specifies the SAS Bridge protocol.

Alias:	METAPROTOCOL=
Requirement:	Do not enclose the value in quotation marks.

REPID=<">identifier<"> | REPNAME=<">name<">

specifies the repository that contains the SASLibrary object. If you specify both REPID= and REPNAME=, REPID= takes precedence over REPNAME=. If you do not specify REPID= or REPNAME=, the value of the METAREPOSITORY= system option is used; for more information, see METAREPOSITORY= System Option. The default for the METAREPOSITORY= system option is Foundation.

REPID=<">identifier<">

specifies an 8-character identifier. This identifier is the first half of the SASLibrary's 17-character identifier, and is the second half of the repository's identifier. For more information, see Metadata Object Identifiers and URIs.

REPNAME=<">name<">

specifies the value in the repository's Name= attribute. The maximum length is 256 characters.

Alias:

METAREPOSITORY=

SERVER=<">host-name<">

is the host name or network IP address of the computer that hosts the metadata server. The value localhost can be used if the SAS session is connecting to a server on the same computer. If you do not specify SERVER=, the value of the METASERVER= system option is used; for more information, see METASERVER= System Option. The maximum length is 256 characters.

Alias:

HOST=
IPADDR=
METASERVER=

USER=<">authorized-user-ID<">

is an authorized user ID on the metadata server. An authorized user ID has ReadMetadata and WriteMetadata permission to the specified SASLibrary, and WriteMemberMetadata permission to the SAS folders that are affected by the update. SAS folders that can be affected by the update include the library's folder and the table's folder, if the table is in a different folder from the library. For more information, see SAS Intelligence Platform: Security Administration Guide. If you do not specify USER=, the value of the METAUSER= system option is used; for more information, see METAUSER= System Option. The maximum length is 256 characters.

Alias:

ID=
METAUSER=
USERID=

Top of Page