Usage Note 17847: SUM function and statement give incorrect output on HP Itanium
 |  |  |  |  |
The SUM function and statement may assign incorrect values to numeric variables due to a problem with floating point register management on HP Itanium. For example:
data a;
input a b c;
datalines;
100 1 1
100 1 2
100 2 3
100 2 4
100 2 5
;
data b;
retain a_num b_num 0;
set a;
num=c/b;
x_num+num;
y_num+num;
a_num=sum(a_num, num);
b_num=sum(b_num, num);
run;
proc print data=b;
var x_num y_num a_num b_num;
run;
produces the following incorrect results:
x_num y_num a_num b_num
1 1 1 1
3 4 5 3
4.5 8.5 13.5 4.5
6.5 15 28.5 6.5
9 24 52.5 9
The variables should all have the same value for each observation.
You can circumvent the problem by specifying the -NOCODEGEN system option.
Select the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | Base SAS | HP-UX IPF | 9.1 TS1M3 SP4 | 9.2 TS2M3 |
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#017847A 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#017847| Type: | Usage Note |
| Priority: | high |
| Topic: | Data Management ==> Access ==> SAS I/O |
| Date Modified: | 2006-09-13 10:04:51 |
| Date Created: | 2006-06-09 15:52:59 |