Problem Note 36592: DELETE statement sometimes does not remove qualifying observations
When doing multiple additions and deletions on an indexed data set that also uses COMPRESS=YES and REUSE=YES, some qualifying observations can be missed and left in the data set after some number of iterations.
The following sample code is what we were using to stress the system. It ran correctly 23 times in a macro before a problem was surfaced:
proc sql;
delete from tmplib.temp where cdate="&TDate"d;
insert into tmplib.temp
select * from temp where cdate="&TDate"d;
quit;
The failure tends to happen after many iterations. The lowest number of iterations before failure that we have seen in testing is 23.
Open the Hot Fix tab for links to the Hot Fix.
Operating System and Release Information
SAS System | Base SAS | z/OS | 9.1 TS1M0 | 9.2 TS2M2 |
Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M0 | 9.2 TS2M2 |
Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.1 TS1M0 | 9.2 TS2M2 |
Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.1 TS1M0 | 9.2 TS2M2 |
Microsoft Windows 2000 Advanced Server | 9.1 TS1M0 | |
Microsoft Windows 2000 Datacenter Server | 9.1 TS1M0 | |
Microsoft Windows 2000 Server | 9.1 TS1M0 | |
Microsoft Windows 2000 Professional | 9.1 TS1M0 | |
Microsoft Windows NT Workstation | 9.1 TS1M0 | |
Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M0 | 9.2 TS2M2 |
Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M0 | 9.2 TS2M2 |
Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M0 | 9.2 TS2M2 |
Microsoft Windows XP Professional | 9.1 TS1M0 | 9.2 TS2M2 |
64-bit Enabled AIX | 9.1 TS1M0 | 9.2 TS2M2 |
64-bit Enabled HP-UX | 9.1 TS1M0 | 9.2 TS2M2 |
64-bit Enabled Solaris | 9.1 TS1M0 | 9.2 TS2M2 |
HP-UX IPF | 9.1 TS1M0 | 9.2 TS2M2 |
Linux | 9.1 TS1M0 | 9.2 TS2M2 |
OpenVMS Alpha | 9.1 TS1M0 | 9.2 TS2M2 |
Tru64 UNIX | 9.1 TS1M0 | 9.2 TS2M2 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
When using COMPRESS=YES and REUSE=YES repeated deletes can miss qualifying observations after several executions
Type: | Problem Note |
Priority: | alert |
Topic: | SAS Reference ==> Statements ==> Action ==> DELETE
|
Date Modified: | 2009-10-11 17:54:14 |
Date Created: | 2009-07-22 15:29:04 |