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
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| 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 | ||
A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:
http://www.sas.com/techsup/download/hotfix/e9_sbcs_prod_list.html#036592A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at:
http://www.sas.com/techsup/download/hotfix/e9_dbcs_prod_list.html#036592A fix for this issue for Base SAS 9.21 is available. However, if you install SAS Maintenance after applying this hot fix, files delivered in the hot fix will not receive the proper Maintenance update. Please contact SAS Technical Support at the link shown below for information on accessing the hot fix.
http://support.sas.com/techsup/contact/index.html| 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 |