DELETE_MULT_ROWS= LIBNAME Option

Indicates whether to let SAS delete multiple rows from a data source, such as a DBMS table.
Valid in: SAS/ACCESS LIBNAME statement
Default: NO
Data source: Aster nCluster, Greenplum, HP Neoview, Microsoft SQL Server, Netezza, ODBC, OLE DB, Sybase IQ
See: UPDATE_MULT_ROWS= LIBNAME option
Syntax
Details

Syntax

DELETE_MULT_ROWS=YES | NO

Syntax Description

YES
specifies that SAS/ACCESS processing continues if multiple rows are deleted. This might produce unexpected results.
NO
specifies that SAS/ACCESS processing does not continue if multiple rows are deleted.

Details

Some providers do not handle this DBMS SQL statement well and therefore delete more than the current row: 
DELETE…WHERE CURRENT OF CURSOR
Copyright © SAS Institute Inc. All rights reserved.