Problem Note 17876: Creating index may cause SAS® to loop
When creating an index with the UNIQUE attribute, SAS may begin to
loop if all the following conditions are true:
- there are duplicate values in the column(s) being
indexed
- there are available pages on the index file (typically
from a previous index delete operation), and
- the duplicate value is encountered after some
index pages have been created in memory, but not
yet written to disk.
To prevent the problem, use PROC SORT with the NODUPKEY option prior
to index creation to remove duplicate values from the key variable(s).
This problem is corrected in SAS 9.2.
Select the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
SAS System | Base SAS | Microsoft Windows XP Professional | 9 TS M0 | 9.2 TS1M0 |
Microsoft Windows NT Workstation | 9 TS M0 | |
Microsoft® Windows® for 64-Bit Itanium-based Systems | 9 TS M0 | 9.2 TS1M0 |
Microsoft Windows Server 2003 Standard Edition | 9 TS M0 | 9.2 TS1M0 |
Microsoft Windows Server 2003 Datacenter Edition | 9 TS M0 | 9.2 TS1M0 |
Microsoft Windows Server 2003 Enterprise Edition | 9 TS M0 | 9.2 TS1M0 |
Microsoft Windows 2000 Server | 9 TS M0 | 9.2 TS1M0 |
Microsoft Windows 2000 Professional | 9 TS M0 | 9.2 TS1M0 |
Microsoft Windows 2000 Advanced Server | 9 TS M0 | 9.2 TS1M0 |
Microsoft Windows 2000 Datacenter Server | 9 TS M0 | 9.2 TS1M0 |
64-bit Enabled Solaris | 9 TS M0 | 9.2 TS1M0 |
Solaris | 9 TS M0 | 9.2 TS1M0 |
z/OS | 9 TS M0 | 9.2 TS1M0 |
HP-UX IPF | 9 TS M0 | 9.2 TS1M0 |
HP-UX | 9 TS M0 | 9.2 TS1M0 |
Linux | 9 TS M0 | 9.2 TS1M0 |
64-bit Enabled HP-UX | 9 TS M0 | 9.2 TS1M0 |
Tru64 UNIX | 9 TS M0 | 9.2 TS1M0 |
64-bit Enabled AIX | 9 TS M0 | 9.2 TS1M0 |
OpenVMS Alpha | 9 TS M0 | 9.2 TS1M0 |
AIX | 9 TS M0 | 9.2 TS1M0 |
*
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.
Type: | Problem Note |
Priority: | high |
Topic: | Data Management ==> Access ==> SAS I/O
|
Date Modified: | 2006-08-24 13:35:56 |
Date Created: | 2006-06-14 15:50:33 |