Specify
SAS/ACCESS data
set options on a SAS data set when accessing PC files data with the
LIBNAME statement, see
LIBNAME Statement Syntax. A data set option applies only to the data set on which
it is specified. The option remains in effect for the duration of
the DATA step or procedure.
This example illustrates
the format of data set options:
LIBNAME libref ENGINE-NAME;
PROC PRINT libref.data-set-name(DATA_SET_OPTION=value);
The CNTLLEV=, DROP=,
FIRSTOBS= , IN=, KEEP=, OBS=, RENAME=, and WHERE SAS data set options
can be used when you access PC files data.
SAS/ACCESS interfaces do
not support the REPLACE= SAS data set option.
Note: Specifying data set options
in PROC SQL might reduce performance, because it prevents operations
from being passed to the data source for processing.