{library} Directive
Defines a high-level qualifier that you use in the
names of tables and views in your SQL queries and statements
Syntax
{library sqlname="table-qualifier" path="library-path"}
Required Arguments
- sqlname="table-qualifier"
-
table-qualifier is the high-level qualifier that
you use in your SQL for the names of tables and views that reside
in this SAS library. This qualifier corresponds to the libref in a
SAS program. You can use the keyword libref as a synonym for sqlname.
- path="library-path"
-
library-path is the pathname of the SAS library.
Details
The {library} directive can be included in both the query
and update sections and defines a high-level qualifier that you use
in the names of tables and views in your SQL queries and statements.
Use this directive when the SAS library that contains the tables and
views that you want to access is
-
not predefined to the
SAS/SHARE
server through which the library is accessed and
-
not defined as part of a data source
that specifies that server.
Note:
-
The keyword
libname is a synonym for library.
-
When you specify a value for sqlname
(or libref), you can use that high-level qualifier for any update
or query section that specifies the same values for the datasrc= and
server= parameters.
-
You can also specify the same high-level
qualifier for two different libraries if they are on different servers.
If you specify the same high-level qualifier for two libraries that
are on the same server, then the second value overrides the first
one.