SAS/ACCESS Interface to SYSTEM 2000 Data Management Software: 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;

Description

The DBLOAD procedure enables you to

create a new database definition only
create a new database definition and load data
load new logical entries into an existing database
insert new data records into existing logical entries.

The procedure constructs SYSTEM 2000 statements to create a new database definition. You can specify an optimized load process to load new logical entries into the database or an insert process to add new records into existing entries.

The DBLOAD procedure associates each SAS variable with a SYSTEM 2000 item and assigns a default name, item type, and picture to each item. You can change the component names as necessary. Also, by default, each item is non-key at level 0; however, you can change the item to be a key item, and you can specify a level number, which causes the procedure to create records below level 0. When you are finished customizing the items, the procedure creates the new database definition and loads the data unless you have specified that you do not want to load any data at this time.

When you load data into an existing database, you must specify an existing view descriptor. You can specify optimized loading for new logical entries; insert mode must be used for adding new records to existing logical entries.

The DBLOAD procedure can run in interactive line or batch mode. For efficiency considerations, you may want to use batch mode for loads that process large amounts of data.

PROC DBLOAD Statement Options

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

DBMS= database-management-system: specifies the database management system you want to access. If you have only the Version 7 SAS/ACCESS interface to SYSTEM 2000 software installed on your machine, this option defaults to S2K. If you have more than one Version 7 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 data view. If the file is permanent, you must use its two-level name, libref.SAS-data-set. If you do not specify the DATA= option, the default is the last SAS data set created.

Procedure Statements

The statements you use with the DBLOAD procedure depend on whether you are creating a new database in which to load data or whether you are appending data to an existing database, and even then, most are optional.

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 allowed only when creating a new database; they produce warnings when used with an existing database. If the view descriptor exists, PROC DBLOAD assumes you are trying to add data to an existing database; therefore, it will not accept the statements used when creating a database.

The statements listed in DBLOAD Statements Used When Creating a Database apply only to creating a database.

DBLOAD Statements Used When Creating a Database
ACCDESC INDEX RESET

CREATE LABEL S2KMODE

DBN LEVEL S2KPW

DELETE RENAME S2KLEN

***DBLOAD Statements Used When Creating a Database***
ACCDESC	INDEX	RESET
CREATE	LABEL	S2KMODE
DBN	LEVEL	S2KPW
DELETE	RENAME	S2KLEN

Chapter Contents
Previous
Next
Top of Page