LIBNAME Statement: PC Files on Microsoft Windows

Data Set Options

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. 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