DBLOAD Procedure Options Syntax

The PROC DBLOAD Statement

PROC DBLOAD <options>;

The following options can be used in the PROC DBLOAD statement:

DBMS= database-management-system

specifies the database management system to be accessed. If you have the SAS 7 or later SAS/ACCESS interface to SYSTEM 2000 installed on your computer, the DBMS= option defaults to S2K. If you have more than one SAS 7 or later SAS/ACCESS interface installed, you must specify DBMS=S2K to access the SYSTEM 2000 data management system.

DATA= libref.SAS-data-set

specifies the input data set. A SAS data set can be either a SAS data file or a SAS view. If the file is permanent, you must use its two-level name, libref.SAS-data-set. If you do not specify a data set in the DATA= option, the default is the last SAS data set that was created.

DBLOAD Procedure Statements

The statements that you use in the DBLOAD procedure depend on whether you are creating a new database to load data into or whether you are appending data to an existing database. The following statements are required:

DBN= and S2KPW= when creating and loading a new database
VIEWDESC= when appending data to an existing database
LOAD for both loading and appending
CREATE for creating a database without loading any data

Of the remaining statements, most are used only when creating a new database; warnings are issued if you use these statements with an existing database. The following statements (listed in alphabetical order) can be used only when creating a database:

Statements to Create a Database
ACCDESC	INDEX	RESET
CREATE	LABEL	S2KLEN
DBN	LEVEL	S2KMODE
DELETE	RENAME	S2KPW

If a view descriptor exists, PROC DBLOAD assumes that you are adding data to an existing database. Therefore, it does not accept the preceding statements, which apply only when creating a database.