ERRLIMIT

Specifies the number of errors that are allowed before SAS stops processing and issues a rollback.

Valid in:	DATA and PROC steps
Default:	1

Syntax

Details

Example

Syntax

ERRLIMIT=integer

Syntax Description

INTEGER: is a positive integer that represents the number of errors after which SAS stops processing and issues a rollback.

Details

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.

Example: Specify Error Limit

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;

ERRLIMIT

Syntax

Syntax Description

Details

Example: Specify Error Limit

See Also