Chapter Contents


SAS/ACCESS Interface to SYSTEM 2000 Data Management Software: Reference

DBLOAD Procedure Syntax

PROC DBLOAD <options>;
DBN= database-name;
ACCDESC= libref.access-descriptor;
DELETE variable-identifier
INDEX variable-identifier = Y|N
<...variable-identifier-n= Y|N>;
LEVEL variable-identifier = n
<...variable-identifier-n= n>;
LIST list-selection;
RENAME variable-identifier = name
<...variable-identifier-n = name-n>;
RESET ALL|variable-identifier
S2KLEN variable-identifier = n
<...variable-identifier-n = n>;
S2KPW= password;
VIEWDESC libref.view-descriptor;
WHERE SAS-where-expression;


The DBLOAD procedure enables you to

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:

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

Chapter Contents



Top of Page

Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.