| The LIBNAME Statement for PC Files on Microsoft Windows |
Specifies the number of errors that are allowed before SAS stops
processing and issues a rollback.
| Valid in: |
DATA and PROC steps (when accessing PC files
data using SAS/ACCESS software)
|
| 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 value for DBCOMMIT= other than zero, then rollbacks affected
by the ERRLIMIT= option might not include records that are processed unsuccessfully
because they were already committed by DBCOMMIT=.
Note: This option cannot be used from a SAS client session
in a SAS/SHARE environment. ![[cautionend]](../../../../common/61925/HTML/default/images/cautend.gif)
In the following example, 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 © 2007 by SAS Institute Inc., Cary, NC, USA. All rights reserved.
