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;