Previous Page | Next Page

The LIBNAME Statement for Relational Databases

LIBNAME Options for Relational Databases

When you specify an option in the LIBNAME statement, it applies to all objects (such as tables and views) in the database that the libref represents. For information about options that you specify on individual SAS data sets, see About the Data Set Options for Relational Databases. For general information about the LIBNAME statement, see LIBNAME Statement Syntax for Relational Databases.

Many LIBNAME options are also available for use with the SQL pass-through facility. See the section on the SQL pass-through facility in the documentation for your SAS/ACCESS interface to determine which LIBNAME options are available in the SQL pass-through facility for your DBMS. For general information about SQL pass-through, see Overview of the SQL Pass-Through Facility.

For a list of the LIBNAME options available in your SAS/ACCESS interface, see your SAS/ACCESS interface.

When a like-named option is specified in both the LIBNAME statement and after a data set name, SAS uses the value that is specified on the data set name.

Previous Page | Next Page | Top of Page