LIBNAME Statement: PC Files on Linux, UNIX, and 64-Bit Microsoft Windows |
Specifies the number of errors that are allowed before SAS stops
processing and issues a rollback.
Valid in: |
DATA and PROC steps
|
Default value: |
1
|
- INTEGER
-
is a positive integer that represents the number of errors
after which SAS stops processing and issues a rollback.
SAS calls the data source to issue a rollback after a
specified number of errors occurs during the processing of inserts, deletes,
updates, and appends. If ERRLIMIT= is set to 0, SAS processes all rows, regardless
of the number of errors that occur. The SAS log displays the total number
of rows processed and the number of failed rows, if applicable.
The DBCOMMIT= option overrides the ERRLIMIT= option. If you specify
a nonzero value for the DBCOMMIT= option, rollbacks affected by the ERRLIMIT=
option might not be complete. Records already committed by DBCOMMIT= option
are not processed again.
Note: This option cannot be used from a SAS client session in a SAS/SHARE
environment. ![[cautionend]](../../../../common/63294/HTML/default/images/cautend.gif)
DBCOMMIT
SAS stops processing and issues a rollback to the data source at the
occurrence of the tenth error. The MyDBLib libref was assigned in a prior
LIBNAME statement.
DATA mydblib.employee3 (ERRLIMIT=10);
SET mydblib.employees;
WHERE salary>40000;
RUN;
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.