DBLOAD Procedure
Example: Append a Data Set to a DBMS Table
Features: |
PROC DBLOAD option: APPEND
- Statements:
- PROC DBLOAD
- TABLE=
- COMMIT=
- ERRLIMIT=
- Database connection statements:
- USER
- password
- PATH
|
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.
The following example
appends new employee data from the NewEmp SAS data set to the Employees
DBMS table. The COMMIT statement causes a DBMS commit to be issued
after every 100 rows are inserted. The ERRLIMIT statement causes processing
to stop after 10 errors occur.
proc dbload dbms=oracle data=newemp append;
user=testuser;
password=testpass;
path='myorapath';
table=employees;
commit=100;
errlimit=10;
load;
run;
Copyright © SAS Institute Inc. All rights reserved.