DBLOAD Procedure Reference

DBLOAD Procedure Syntax

PROC DBLOAD <options>;

CREATE;

DBN= database-name;

ACCDESC= libref.access-descriptor;

DELETE variable-identifier <...variable-identifier-n>;

INDEX variable-identifier = Y|N <...variable-identifier-n= Y|N>;

LABEL;

LEVEL variable-identifier = n <...variable-identifier-n= n>;

LIST list-selection;

LOAD;

QUIT;

RENAME variable-identifier = name <...variable-identifier-n = name-n>;

RESET ALL|variable-identifier <...variable-identifier-n>;

S2KLEN variable-identifier = n <...variable-identifier-n = n>;

S2KLOAD;

S2KMODE= M|S;

S2KPW= password;

VIEWDESC= libref.view-descriptor;

WHERE SAS-where-expression;

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:

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 will not accept the preceding statements which apply only when creating a database.

Top of Page