What's New in the SAS 9.1 and 9.1.3 Metadata LIBNAME Engine
Overview
The metadata engine provides secure access to SAS data. By incorporating
metadata, this engine augments and controls access to the data.
Note: This section describes the features of the SAS metadata engine that are new
or enhanced since SAS 9.0.
Details
- The metadata engine, in conjunction
with the SAS Open Metadata Architecture Authorization Facility, enables an administrator
to specify user privileges in order to control which data the users are allowed
to access.
- The new LIBURI= and LIBRARY=
options in the LIBNAME statement provide additional methods for referencing the SASLibrary
metadata object.
- The new METAOUT= option specifies access to tables in the data
source.
- The METAOUT= option in the LIBNAME statement enables you to specify access to a
library.
- The METAOUT= data set option enables you to
specify access to a specific table.
- Beginning with SAS 9.1.3 Service Pack 4, with the default behavior
of the engine (METAOUT=ALL), you can no longer create or delete tables or
their associated metadata. You can insert, update, and delete observations
in a table. Metadata must be present for you to access the table.
- Beginning with SAS 9.1.3 Service Pack 4, when METAOUT=DATA is
specified for a table, the metadata engine behaves more like the underlying
engine that is defined in the metadata; for example, data set options can
be passed directly to the underlying engine.
- Beginning with SAS 9.1.3 Service Pack 4, you are advised to use
the METALIB procedure instead of METAOUT=META to create, update, or delete
metadata. The METAOUT=META value is not expected to be supported in the next
release of the software. (For information about PROC METALIB, see the chapter
about SAS language metadata interfaces in
SAS Open Metadata Interface: Reference).
- Beginning with SAS 9.1.3 Service Pack 4, SQL implicit pass-through
is supported.