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=
	OBS=
	RENAME=
	WHERE=

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

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.