Problem Note 1390: UNIQUE option does not work with SET KEY= using LIBNAME engine
Specifying the UNIQUE option on a SET statement causes the KEY=
search to always begin at the "top" of the index. Starting in
Version 8 TSLEVEL D1, if there are consecutive duplicate KEY= values
in the transaction data set and unique KEY= values in the master data
set, SAS incorrectly matches only the first occurrence.
To circumvent this problem, specify the LIBNAME option
REREAD_EXPOSURE=YES and the data set option CNTLLEV=REC. Note that
using REREAD_EXPOSURE=YES may cause data integrity issues. With
REREAD_EXPOSURE=YES, the SAS/ACCESS engine behaves like a random
access engine when rereading a row, so there is no guarantee that
the same row will be returned each time. Thus there is the
potential for data integrity exposures within the scope of your SAS
session.
This problem is corrected in Release 8.1 TS1M0.
Operating System and Release Information
| Product Family | Product | System | Reported Release | Fixed Release* |
| SAS System | SAS/ACCESS Interface to Teradata | Solaris | 8 TSD1 | 8.1 TS1M0 |
| 64-bit Enabled Solaris | 8 TSD1 | 8.1 TS1M0 |
| IRIX | 8 TSD1 | 8.1 TS1M0 |
| HP-UX | 8 TSD1 | 8.1 TS1M0 |
| 64-bit Enabled HP-UX | 8 TSD1 | 8.1 TS1M0 |
| CMS | 8 TSD1 | 8.1 TS1M0 |
| 64-bit Enabled AIX | 8 TSD1 | 8.1 TS1M0 |
| AIX | 8 TSD1 | 8.1 TS1M0 |
| SAS System | SAS/ACCESS Interface to R/3 | Solaris | 8 TSD1 | 8.1 TS1M0 |
| 64-bit Enabled Solaris | 8 TSD1 | 8.1 TS1M0 |
| IRIX | 8 TSD1 | 8.1 TS1M0 |
| HP-UX | 8 TSD1 | 8.1 TS1M0 |
| 64-bit Enabled HP-UX | 8 TSD1 | 8.1 TS1M0 |
| CMS | 8 TSD1 | 8.1 TS1M0 |
| 64-bit Enabled AIX | 8 TSD1 | 8.1 TS1M0 |
| AIX | 8 TSD1 | 8.1 TS1M0 |
| SAS System | SAS/ACCESS Interface to SAP BW | Solaris | 8 TSD1 | 8.1 TS1M0 |
| 64-bit Enabled Solaris | 8 TSD1 | 8.1 TS1M0 |
| IRIX | 8 TSD1 | 8.1 TS1M0 |
| HP-UX | 8 TSD1 | 8.1 TS1M0 |
| 64-bit Enabled HP-UX | 8 TSD1 | 8.1 TS1M0 |
| CMS | 8 TSD1 | 8.1 TS1M0 |
| 64-bit Enabled AIX | 8 TSD1 | 8.1 TS1M0 |
| AIX | 8 TSD1 | 8.1 TS1M0 |
| SAS System | SAS/ACCESS Interface to Sybase | Solaris | 8 TSD1 | 8.1 TS1M0 |
| 64-bit Enabled Solaris | 8 TSD1 | 8.1 TS1M0 |
| IRIX | 8 TSD1 | 8.1 TS1M0 |
| HP-UX | 8 TSD1 | 8.1 TS1M0 |
| 64-bit Enabled HP-UX | 8 TSD1 | 8.1 TS1M0 |
| 64-bit Enabled AIX | 8 TSD1 | 8.1 TS1M0 |
| AIX | 8 TSD1 | 8.1 TS1M0 |
| CMS | 8 TSD1 | 8.1 TS1M0 |
| SAS System | SAS/ACCESS Interface to PeopleSoft | Solaris | 8 TSD1 | 8.1 TS1M0 |
| 64-bit Enabled Solaris | 8 TSD1 | 8.1 TS1M0 |
| IRIX | 8 TSD1 | 8.1 TS1M0 |
| HP-UX | 8 TSD1 | 8.1 TS1M0 |
| 64-bit Enabled HP-UX | 8 TSD1 | 8.1 TS1M0 |
| CMS | 8 TSD1 | 8.1 TS1M0 |
| 64-bit Enabled AIX | 8 TSD1 | 8.1 TS1M0 |
| AIX | 8 TSD1 | 8.1 TS1M0 |
| SAS System | SAS/ACCESS Interface to PC Files | Solaris | 8 TSD1 | 8.1 TS1M0 |
| 64-bit Enabled Solaris | 8 TSD1 | 8.1 TS1M0 |
| IRIX | 8 TSD1 | 8.1 TS1M0 |
| HP-UX | 8 TSD1 | 8.1 TS1M0 |
| 64-bit Enabled HP-UX | 8 TSD1 | 8.1 TS1M0 |
| CMS | 8 TSD1 | 8.1 TS1M0 |
| 64-bit Enabled AIX | 8 TSD1 | 8.1 TS1M0 |
| AIX | 8 TSD1 | 8.1 TS1M0 |
| SAS System | SAS/ACCESS Interface to Oracle Rdb | Solaris | 8 TSD1 | 8.1 TS1M0 |
| 64-bit Enabled Solaris | 8 TSD1 | 8.1 TS1M0 |
| IRIX | 8 TSD1 | 8.1 TS1M0 |
| HP-UX | 8 TSD1 | 8.1 TS1M0 |
| 64-bit Enabled HP-UX | 8 TSD1 | 8.1 TS1M0 |
| CMS | 8 TSD1 | 8.1 TS1M0 |
| 64-bit Enabled AIX | 8 TSD1 | 8.1 TS1M0 |
| AIX | 8 TSD1 | 8.1 TS1M0 |
| SAS System | SAS/ACCESS Interface to Oracle | Solaris | 8 TSD1 | 8.1 TS1M0 |
| 64-bit Enabled Solaris | 8 TSD1 | 8.1 TS1M0 |
| IRIX | 8 TSD1 | 8.1 TS1M0 |
| HP-UX | 8 TSD1 | 8.1 TS1M0 |
| 64-bit Enabled HP-UX | 8 TSD1 | 8.1 TS1M0 |
| CMS | 8 TSD1 | 8.1 TS1M0 |
| 64-bit Enabled AIX | 8 TSD1 | 8.1 TS1M0 |
| AIX | 8 TSD1 | 8.1 TS1M0 |
| SAS System | SAS/ACCESS Interface to ODBC | Solaris | 8 TSD1 | 8.1 TS1M0 |
| 64-bit Enabled Solaris | 8 TSD1 | 8.1 TS1M0 |
| IRIX | 8 TSD1 | 8.1 TS1M0 |
| HP-UX | 8 TSD1 | 8.1 TS1M0 |
| 64-bit Enabled HP-UX | 8 TSD1 | 8.1 TS1M0 |
| CMS | 8 TSD1 | 8.1 TS1M0 |
| 64-bit Enabled AIX | 8 TSD1 | 8.1 TS1M0 |
| AIX | 8 TSD1 | 8.1 TS1M0 |
| SAS System | SAS/ACCESS Interface to OLE DB | Solaris | 8 TSD1 | 8.1 TS1M0 |
| 64-bit Enabled Solaris | 8 TSD1 | 8.1 TS1M0 |
| IRIX | 8 TSD1 | 8.1 TS1M0 |
| HP-UX | 8 TSD1 | 8.1 TS1M0 |
| 64-bit Enabled HP-UX | 8 TSD1 | 8.1 TS1M0 |
| CMS | 8 TSD1 | 8.1 TS1M0 |
| 64-bit Enabled AIX | 8 TSD1 | 8.1 TS1M0 |
| AIX | 8 TSD1 | 8.1 TS1M0 |
| SAS System | SAS/ACCESS Interface to MySQL | Solaris | 8 TSD1 | 8.1 TS1M0 |
| 64-bit Enabled Solaris | 8 TSD1 | 8.1 TS1M0 |
| IRIX | 8 TSD1 | 8.1 TS1M0 |
| HP-UX | 8 TSD1 | 8.1 TS1M0 |
| 64-bit Enabled HP-UX | 8 TSD1 | 8.1 TS1M0 |
| CMS | 8 TSD1 | 8.1 TS1M0 |
| 64-bit Enabled AIX | 8 TSD1 | 8.1 TS1M0 |
| AIX | 8 TSD1 | 8.1 TS1M0 |
| SAS System | SAS/ACCESS Interface to IMS-DL/I | Solaris | 8 TSD1 | 8.1 TS1M0 |
| 64-bit Enabled Solaris | 8 TSD1 | 8.1 TS1M0 |
| IRIX | 8 TSD1 | 8.1 TS1M0 |
| HP-UX | 8 TSD1 | 8.1 TS1M0 |
| 64-bit Enabled HP-UX | 8 TSD1 | 8.1 TS1M0 |
| CMS | 8 TSD1 | 8.1 TS1M0 |
| 64-bit Enabled AIX | 8 TSD1 | 8.1 TS1M0 |
| AIX | 8 TSD1 | 8.1 TS1M0 |
| SAS System | SAS/ACCESS Interface to Informix | Solaris | 8 TSD1 | 8.1 TS1M0 |
| 64-bit Enabled Solaris | 8 TSD1 | 8.1 TS1M0 |
| IRIX | 8 TSD1 | 8.1 TS1M0 |
| HP-UX | 8 TSD1 | 8.1 TS1M0 |
| 64-bit Enabled HP-UX | 8 TSD1 | 8.1 TS1M0 |
| CMS | 8 TSD1 | 8.1 TS1M0 |
| 64-bit Enabled AIX | 8 TSD1 | 8.1 TS1M0 |
| AIX | 8 TSD1 | 8.1 TS1M0 |
| SAS System | SAS/ACCESS Interface to DB2 Server for VM | Solaris | 8 TSD1 | 8.1 TS1M0 |
| 64-bit Enabled Solaris | 8 TSD1 | 8.1 TS1M0 |
| IRIX | 8 TSD1 | 8.1 TS1M0 |
| HP-UX | 8 TSD1 | 8.1 TS1M0 |
| 64-bit Enabled HP-UX | 8 TSD1 | 8.1 TS1M0 |
| CMS | 8 TSD1 | 8.1 TS1M0 |
| 64-bit Enabled AIX | 8 TSD1 | 8.1 TS1M0 |
| AIX | 8 TSD1 | 8.1 TS1M0 |
| SAS System | SAS/ACCESS Interface to CA-OpenIngres | Solaris | 8 TSD1 | 8.1 TS1M0 |
| 64-bit Enabled Solaris | 8 TSD1 | 8.1 TS1M0 |
| IRIX | 8 TSD1 | 8.1 TS1M0 |
| HP-UX | 8 TSD1 | 8.1 TS1M0 |
| 64-bit Enabled HP-UX | 8 TSD1 | 8.1 TS1M0 |
| CMS | 8 TSD1 | 8.1 TS1M0 |
| 64-bit Enabled AIX | 8 TSD1 | 8.1 TS1M0 |
| AIX | 8 TSD1 | 8.1 TS1M0 |
| SAS System | SAS/ACCESS Interface to DB2 | Solaris | 8 TSD1 | 8.1 TS1M0 |
| 64-bit Enabled Solaris | 8 TSD1 | 8.1 TS1M0 |
| IRIX | 8 TSD1 | 8.1 TS1M0 |
| HP-UX | 8 TSD1 | 8.1 TS1M0 |
| 64-bit Enabled HP-UX | 8 TSD1 | 8.1 TS1M0 |
| CMS | 8 TSD1 | 8.1 TS1M0 |
| 64-bit Enabled AIX | 8 TSD1 | 8.1 TS1M0 |
| AIX | 8 TSD1 | 8.1 TS1M0 |
| SAS System | SAS/ACCESS Interface to CA-IDMS | Solaris | 8 TSD1 | 8.1 TS1M0 |
| 64-bit Enabled Solaris | 8 TSD1 | 8.1 TS1M0 |
| IRIX | 8 TSD1 | 8.1 TS1M0 |
| HP-UX | 8 TSD1 | 8.1 TS1M0 |
| 64-bit Enabled HP-UX | 8 TSD1 | 8.1 TS1M0 |
| CMS | 8 TSD1 | 8.1 TS1M0 |
| 64-bit Enabled AIX | 8 TSD1 | 8.1 TS1M0 |
| AIX | 8 TSD1 | 8.1 TS1M0 |
| SAS System | SAS/ACCESS Interface to CA-Datacom/DB | Solaris | 8 TSD1 | 8.1 TS1M0 |
| 64-bit Enabled Solaris | 8 TSD1 | 8.1 TS1M0 |
| IRIX | 8 TSD1 | 8.1 TS1M0 |
| HP-UX | 8 TSD1 | 8.1 TS1M0 |
| 64-bit Enabled HP-UX | 8 TSD1 | 8.1 TS1M0 |
| CMS | 8 TSD1 | 8.1 TS1M0 |
| 64-bit Enabled AIX | 8 TSD1 | 8.1 TS1M0 |
| AIX | 8 TSD1 | 8.1 TS1M0 |
| SAS System | SAS/ACCESS Interface to Baan | Solaris | 8 TSD1 | 8.1 TS1M0 |
| 64-bit Enabled Solaris | 8 TSD1 | 8.1 TS1M0 |
| IRIX | 8 TSD1 | 8.1 TS1M0 |
| HP-UX | 8 TSD1 | 8.1 TS1M0 |
| 64-bit Enabled HP-UX | 8 TSD1 | 8.1 TS1M0 |
| CMS | 8 TSD1 | 8.1 TS1M0 |
| 64-bit Enabled AIX | 8 TSD1 | 8.1 TS1M0 |
| AIX | 8 TSD1 | 8.1 TS1M0 |
| SAS System | SAS/ACCESS Interface to Adabas | Solaris | 8 TSD1 | 8.1 TS1M0 |
| 64-bit Enabled Solaris | 8 TSD1 | 8.1 TS1M0 |
| IRIX | 8 TSD1 | 8.1 TS1M0 |
| HP-UX | 8 TSD1 | 8.1 TS1M0 |
| 64-bit Enabled HP-UX | 8 TSD1 | 8.1 TS1M0 |
| CMS | 8 TSD1 | 8.1 TS1M0 |
| 64-bit Enabled AIX | 8 TSD1 | 8.1 TS1M0 |
| AIX | 8 TSD1 | 8.1 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: | SAS Reference ==> LIBNAME Engines
|
| Date Modified: | 2003-04-29 15:53:12 |
| Date Created: | 1999-11-15 00:00:00 |