LIBNAME Statement: 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.
|
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 occur 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 DBCOMMIT value other than zero, then the ERRLIMIT option might
not include records that are processed unsuccessfully. This is because they
were already committed in the DBCOMMIT option.
Note: DBCOMMIT cannot be used from a SAS client session in a SAS/SHARE
environment. ![[cautionend]](../../../../common/63294/HTML/default/images/cautend.gif)
DBCOMMIT
/*MyDBLib libref was assigned in a prior LIBNAME statement*/.
/*SAS stops processing at the occurrence of the tenth error data */
DATA mydblib.employee3 (ERRLIMIT=10);
SET mydblib.employees;
WHERE salary>40000;
RUN;
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.