Problem Note 31053: Threaded procedures might return incorrect values when the DESCENDING option is specified
 |  |  |  |  |  |
Threaded procedures (for example, PROC SORT and PROC SQL) might return incorrect values if the DESCENDING option is specified on the BY or ORDER BY statement.
The following error is then generated:
ERROR: BY variables are not properly sorted on data set WORK.XXX.DATA. NOTE: The SAS System stopped processing this step because of errors.
One solution is to turn off threading by specifying the NOTHREADS system option.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | Base SAS | z/OS | 9.1 TS1M3 | 9.2 TS1M0 |
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Microsoft Windows XP 64-bit Edition | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Microsoft® Windows® for x64 | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Microsoft Windows 2000 Advanced Server | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Microsoft Windows 2000 Datacenter Server | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Microsoft Windows 2000 Server | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Microsoft Windows 2000 Professional | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Microsoft Windows NT Workstation | 9.1 TS1M3 | |||
| Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Microsoft Windows XP Professional | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Windows Vista | 9.1 TS1M3 | 9.2 TS1M0 | ||
| 64-bit Enabled AIX | 9.1 TS1M3 | 9.2 TS1M0 | ||
| 64-bit Enabled HP-UX | 9.1 TS1M3 | 9.2 TS1M0 | ||
| 64-bit Enabled Solaris | 9.1 TS1M3 | 9.2 TS1M0 | ||
| HP-UX IPF | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Linux | 9.1 TS1M3 | 9.2 TS1M0 | ||
| OpenVMS Alpha | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Solaris for x64 | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Tru64 UNIX | 9.1 TS1M3 | 9.2 TS1M0 | ||
This test case demonstrates the problem using PROC SORT:
data foo;
length v1 $ 32767;
length v2 $ 10;
length v3 $ 32;
v1=repeat(" ",32765);
input v2 v3;
cards;
A 9
B 8
C 7
D 6
E 5
F 4
G 3
H 2
I 1
J 0
;
run;
option sortpgm=sas;
proc sort data=foo out=bar threads;
by DESCENDING v3 DESCENDING v2;
run;
proc print data=bar;
var v2 v3;
run;
data _NULL_;
set bar;
by DESCENDING v3 DESCENDING v2;
run;
A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:
http://www.sas.com/techsup/download/hotfix/e9_sbcs_prod_list.html#031053A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at:
http://www.sas.com/techsup/download/hotfix/e9_dbcs_prod_list.html#031053| Type: | Problem Note |
| Priority: |
| Date Modified: | 2008-04-03 18:57:12 |
| Date Created: | 2008-01-28 18:39:58 |