DBLOAD Procedure
PROC DBLOAD Statement
Sends data from SAS to a DBMS
Syntax
Optional Arguments
- DBMS=database-management-system
-
specifies which database
management system you want to access. This DBMS-specific option is
required. See the DBMS-specific reference in this document for details
about your DBMS.
- DATA=<libref.>SAS-data-set
-
specifies the input
data set. You can retrieve input data from a SAS data file, an SQL
view, a DATA step view, a SAS/ACCESS view descriptor, or another DBMS
table to which a SAS/ACCESS libref points. If the SAS data set is
permanent, you must use its two-level name, libref.SAS-data-set.
If you omit the DATA= option, the default is the last SAS data set
that was created.
- APPEND
-
appends data to an
existing DBMS table that you identify by using the TABLE= statement.
When you specify APPEND, the input data specified with the DATA= option
is inserted into the existing DBMS table. Your input data can be in
the form of a SAS data set, SQL view, or SAS/ACCESS view (view descriptor).
CAUTION:
When you
use APPEND, you must ensure that your input data corresponds exactly
to the columns in the DBMS table. If your input data does not include
values for all columns in the DBMS table, you might corrupt your DBMS
table by inserting data into the wrong columns. Use the COMMIT, ERRLIMIT,
and LIMIT statements to help safeguard against data corruption. Use
the DELETE and RENAME statements to drop and rename SAS input variables
that do not have corresponding DBMS columns.
All PROC DBLOAD statements
and options can be used with APPEND, except for the NULLS and TYPE
statements, which have no effect when used with APPEND. The LOAD statement
is required.
The following example
appends new employee data from the SAS data set NEWEMP to the DBMS
table EMPLOYEES. The COMMIT statement causes a DBMS commit to be issued
after every 100 rows are inserted. The ERRLIMIT statement causes processing
to stop after five errors occur.
proc dbload dbms=oracle
data=newemp append; user=testuser; password=testpass; path='myorapath';
table=employees; commit=100; errlimit=5; load; run;
By omitting the APPEND
option from the DBLOAD statement, you can use the PROC DBLOAD SQL
statements to create a DBMS table and append to it in the same PROC
DBLOAD step.
Copyright © SAS Institute Inc. All rights reserved.