|SAS/ACCESS Software for Relational Databases: Reference|
The SAS/ACCESS data set options are as follows:
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.
The REPLACE= data set option is not supported by SAS/ACCESS
engines. If this option is specified, the engine supervisor will print a warning
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;
Top of Page
Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.