Problem Note 45589: An index might be ignored in BY processing after importing the indexed data set from transport format from another operating system
An index might be ignored in BY processing after importing the indexed data set from transport format using PROC CIMPORT. This is most likely to occur if the transport file containing the indexed data set was created on a different operating system.
This can generate an error message and cause SAS to stop further processing. The error message is shown in the SAS Log example below.
175? data new;
176? merge class1 class2;
177? by age;
178? run;
ERROR: BY variables are not properly sorted on data set WORK.CLASS1.
Name=Mary Sex=F Age=15 Height=66.5 Weight=112 FIRST.Age=1 LAST.Age=0 _ERROR_=1
_N_=9
NOTE: The SAS System stopped processing this step because of errors.
NOTE: There were 10 observations read from the data set WORK.CLASS1.
NOTE: There were 1 observations read from the data set WORK.CLASS2.
WARNING: The data set WORK.NEW may be incomplete. When this step was stopped
there were 8 observations and 5 variables.
WARNING: Data set WORK.NEW was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
real time 7.31 seconds
cpu time 0.01 seconds
|
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
SAS System | Base SAS | Windows 7 Professional x64 | 9.2 TS2M3 | 9.3 TS1M2 |
Windows 7 Professional 32 bit | 9.2 TS2M3 | 9.3 TS1M2 |
Windows 7 Home Premium x64 | 9.2 TS2M3 | 9.3 TS1M2 |
Microsoft Windows Server 2008 | 9.2 TS2M3 | 9.3 TS1M2 |
Microsoft Windows Server 2003 for x64 | 9.2 TS2M3 | 9.3 TS1M2 |
Microsoft Windows Server 2003 Enterprise Edition | 9.2 TS2M3 | 9.3 TS1M2 |
Microsoft Windows Server 2003 Datacenter Edition | 9.2 TS2M3 | 9.3 TS1M2 |
Microsoft® Windows® for x64 | 9.2 TS2M3 | 9.3 TS1M2 |
Microsoft Windows XP 64-bit Edition | 9.2 TS2M3 | 9.3 TS1M2 |
Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.2 TS2M3 | 9.3 TS1M2 |
Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.2 TS2M3 | 9.3 TS1M2 |
Windows 7 Home Premium 32 bit | 9.2 TS2M3 | 9.3 TS1M2 |
Windows 7 Enterprise x64 | 9.2 TS2M3 | 9.3 TS1M2 |
Windows 7 Enterprise 32 bit | 9.2 TS2M3 | 9.3 TS1M2 |
Microsoft Windows XP Professional | 9.2 TS2M3 | 9.3 TS1M2 |
Microsoft Windows Server 2008 for x64 | 9.2 TS2M3 | 9.3 TS1M2 |
Microsoft Windows Server 2003 Standard Edition | 9.2 TS2M3 | 9.3 TS1M2 |
Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.2 TS2M3 | 9.3 TS1M2 |
z/OS | 9.2 TS2M3 | 9.3 TS1M2 |
Windows 7 Ultimate 32 bit | 9.2 TS2M3 | 9.3 TS1M2 |
Windows 7 Ultimate x64 | 9.2 TS2M3 | 9.3 TS1M2 |
Windows Vista | 9.2 TS2M3 | 9.3 TS1M2 |
Windows Vista for x64 | 9.2 TS2M3 | 9.3 TS1M2 |
64-bit Enabled AIX | 9.2 TS2M3 | 9.3 TS1M2 |
64-bit Enabled HP-UX | 9.2 TS2M3 | 9.3 TS1M2 |
64-bit Enabled Solaris | 9.2 TS2M3 | 9.3 TS1M2 |
HP-UX IPF | 9.2 TS2M3 | 9.3 TS1M2 |
Linux | 9.2 TS2M3 | 9.3 TS1M2 |
Linux for x64 | 9.2 TS2M3 | 9.3 TS1M2 |
OpenVMS on HP Integrity | 9.2 TS2M3 | 9.3 TS1M2 |
Solaris for x64 | 9.2 TS2M3 | 9.3 TS1M2 |
*
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 you use PROC CIMPORT to import a transport file created on another operating system and the file contains an indexed data set, the index might be ignored in subsequent processing. This can generate an error and stop SAS from further processing.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2012-02-10 08:55:04 |
Date Created: | 2012-02-06 15:40:16 |