![]() | ![]() | ![]() | ![]() | ![]() |
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.
Product Family | Product | System | SAS Release | |
Reported | Fixed* | |||
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 |