The DBLOAD procedure enables you to create and load a SYSTEM 2000
database using data from a
SAS data file, from a
view created with the SQL procedure, or from a SYSTEM 2000 database or another
DBMS (using a
view descriptor created by using the ACCESS procedure).
Use the DBLOAD procedure
to do the following:
-
-
create a new database definition and load data
-
load new logical entries into an existing database
-
insert new data records into existing
logical entries
PROC DBLOAD constructs SYSTEM 2000 statements to create a new database definition.
The 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 under level 0. When you are finished
customizing the items, PROC DBLOAD creates the new database
definition and loads the data unless you have specified that you do not want to load any data
at that time.
When you load data into an existing database, you must specify an existing view descriptor.
You can specify the optimized
load mode to load for new logical entries. Insert mode must be used for adding new records
to existing logical entries.
PROC DBLOAD can run in batch or interactive-
line mode. For efficiency, you might want to use
batch mode for loads that process large amounts of data.