About the Data Set Options for Relational Databases

You can specify SAS/ACCESS data set options on a SAS data set when you access DBMS data with the SAS/ACCESS LIBNAME statement. A data set option applies only to the data set on which it is specified, and it remains in effect for the duration of the DATA step or procedure. For options that you can assign to a group of relational DBMS tables or views, see LIBNAME Options for Relational Databases.

Here is an example of how you can SAS/ACCESS data set options.

libname myoralib oracle;
proc print myoralib.mytable(data-set-option=value)

You can also use SAS/ACCESS data set options on a SAS data set when you access DBMS data using access descriptors, see Using Descriptors with the ACCESS Procedure . Here is an example.

proc print mylib.myviewd(data-set-option=value)

You cannot use most data set options on a PROC SQL DROP (table or view) statement.

You can use the CNTLLEV=, DROP=, FIRSTOBS=, IN=, KEEP=, OBS=, RENAME=, and WHERE= SAS data set options when you access DBMS data. SAS/ACCESS interfaces do not support the REPLACE= SAS data set option. For information about using SAS data set options, see SAS Data Set Options: Reference.

The information in this section explains all applicable data set options. The information includes DBMS support and the corresponding LIBNAME options, and refers you to documentation for your SAS/ACCESS interface when appropriate. For a list of the data set options available in your SAS/ACCESS interface with default values, see the reference section for your DBMS.

Specifying data set options in PROC SQL might reduce performance, because it prevents operations from being passed to the DBMS for processing. For more information, see Overview: Optimizing Your SQL Usage.