LIBNAME Statement: PC Files on Linux, UNIX, and 64-Bit Microsoft Windows

Data Set Options for PC Files on Linux and UNIX, and 64-Bit Windows

You can specify SAS/ACCESS data set options on a SAS data set when you access PC files data with the LIBNAME Statement Syntax for PC Files on Linux and UNIX. 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. See Data Set Options and Syntax for PC Files on Linux, UNIX, and 64-Bit Microsoft Windows.

This generic example shows the format of data set options:

LIBNAME libref engine-name;
PROC PRINT libref.data-set-name(DATA_SET_OPTION=value)

You can use the CNTLLEV=, DROP=, FIRSTOBS=, IN=, KEEP=, OBS=, RENAME=, and WHERE= SAS data set options when you access PC files data. The REPLACE= SAS data set option is not supported by SAS/ACCESS interfaces. For information about using SAS data set options, refer to the SAS Language Reference: Dictionary.

Note: Specifying data set options in PROC SQL might reduce performance, because it prevents operations from being passed to the data source for processing. [cautionend]

Top of Page