 |
|
| DBLOAD Procedure Reference |
DBLOAD Procedure and SYSTEM 2000
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).
Using the DBLOAD procedure you can
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.
|
|
Copyright © 2007 by SAS Institute Inc., Cary, NC, USA. All rights reserved.