Problem Note 35613: Hash data set load fails when reading SAS data set
A SAS data set read using Cross Environment Data Access (CEDA) and has integrity constraints defined directly cannot be loaded directly into a HASH table DATASET parameter of the DECLARE statement.
The following message is the result:
WARNING: Integrity constraints cannot be processed for
file (SAS data set name ) because its encoding does not
match the session encoding or the file is in a format
native to another host, such as HP_UX_64, RS_6000_AIX_64,
SOLARIS_64, HP_IA64.
ERROR: Hash data set load failed at line nnn column nn.
ERROR: DATA STEP Component Object failure. Aborted during the
EXECUTION phase.
Known work-arounds:
- Use the SET statement to read the data set and the ADD method to build the hash table.
- Copy the original SAS data set to the WORK library, load the HASH table from the WORK data set.
Operating System and Release Information
| SAS System | Base SAS | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.1 TS1M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.1 TS1M3 | 9.3 TS1M0 |
| Microsoft Windows XP 64-bit Edition | 9.1 TS1M3 | 9.3 TS1M0 |
| Microsoft Windows 2000 Advanced Server | 9.1 TS1M3 | |
| Microsoft Windows 2000 Datacenter Server | 9.1 TS1M3 | |
| Microsoft Windows 2000 Server | 9.1 TS1M3 | |
| Microsoft Windows 2000 Professional | 9.1 TS1M3 | |
| Microsoft Windows NT Workstation | 9.1 TS1M3 | |
| Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 | 9.3 TS1M0 |
| Microsoft Windows XP Professional | 9.1 TS1M3 | 9.3 TS1M0 |
| Windows Vista | 9.1 TS1M3 | 9.3 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.
Hash table load from SAS data set read with CEDA fails when SAS data set has integrity constraints.
| Type: | Problem Note |
| Priority: | medium |
| Topic: | SAS Reference ==> Component Objects ==> hash object
|
| Date Modified: | 2011-06-06 14:11:55 |
| Date Created: | 2009-04-17 18:32:51 |
