Using BULKLOAD=YES is the fastest way to insert rows into a DBMS table.
When BULKLOAD=YES, the
first error to be encountered causes the remaining rows (including
the erroneous row) in the buffer to be rejected. No other errors within
the same buffer will be detected. In addition, all rows before the
error are committed, even if DBCOMMIT= is set to be larger than the
number of the erroneous row.
For more information,
see bulk loading information in SAS FedSQL Language Reference.