Data Set Options

You can specify SAS/ACCESS data set options on a SAS data set when you access PC files data with the 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.

This generic example illustrates 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. 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.  

SAS/ACCESS Interface to PC Files supports these data set options:

Copyright © 2009 by SAS Institute Inc., Cary, NC, USA. All rights reserved.