Chapter Contents

Previous

Next

SAS/ACCESS Data Set Options

The SAS/ACCESS data set options are as follows:

	DBCOMMIT=
	DBCONDITION=
	DBCREATE_TABLE_OPTS
	DBFORCE=
	DBGEN_NAME=
	DBINDEX=
	DBKEY=
	DBLABEL=
	DBNULL=
	DBPROMPT=
	DBTYPE=
	ERRLIMIT=
	NULLCHAR=
	NULLCHARVAL=
	READ_LOCK_TYPE=
	SASDATEFMT=
	UPDATE_LOCK_TYPE=

In addition to the SAS/ACCESS data set options that are described in this chapter, you can also use several other SAS data set options when you access DBMS data. The following list includes the SAS data set options that can be used with DBMS data. For a complete listing of data set options that can be used with data sets that are composed of SAS data, refer to the SAS Language Reference: Dictionary.

	CNTLLEV=
	DROP=
	FIRSTOBS=
	IN=
	KEEP=
	LABEL=
	OBS=
	RENAME=
	TYPE=
	WHERE=

Note:    The REPLACE= data set option is not supported by DBMS engines. If this option is specified, the engine supervisor will print a warning message.  

Note:    When used with DBMS data, the LABEL= and TYPE= options apply only to input for the duration of the SAS procedure in which they are used. The CONTENTS procedure uses these options as input options.   

In this example, the DROP= option causes the SAS/ACCESS engine to omit the SALARY column when it reads the MYDBLIB.EMPLOYEES table.

libname mydblib db2 ssid=db2 authid=sasdemo;

proc sql;
select * 
  from mydblib.employees(drop=salary)
  where dept='ACC024';
quit;

Chapter Contents

Previous

Next

Top of Page

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