SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 13617: PROC MEANS/SUMMARY/TABULATE/REPORT might generate a warning in SAS® 9 related to the use of WEIGHT and STD or STDERR

DetailsHotfixAboutRate It

The MEANS, SUMMARY, TABULATE, or REPORT procedure might generate the messages below in SAS 9 and higher if a WEIGHT statement is used and the STD or STDERR statistics are requested:

WARNING: An error has occurred while adjusting the second moment for variable xxx. NOTE: The affected statistics will be missing from the corresponding classification levels. WARNING: Overflow has occurred while summing the first moment for the variable xxx.

In addition, PROC TABULATE might issue the following error messages:

ERROR: Invalid Operation ERROR: Termination due to Floating Point Exception.

This problem is memory related and can be circumvented by removing the WEIGHT statement and/or the STD or STDERR statistics.

The expected behavior is to generate the warning below. Sometimes this warning is caused by a value that is out of range from the other values.

WARNING: An error has occurred while adjusting the second moment for variable xxx.

The fix provided below addresses the overflow and invalid operation messages.

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#013617

For customers running SAS with Asian Language Support (DBCS), this fix should be downloaded from: http://www.sas.com/techsup/download/hotfix/e9_dbcs_prod_list.html#013617

Operating System and Release Information

Product FamilyProductSystemSAS Release
ReportedFixed*
SAS SystemBase SASMicrosoft Windows XP Professional9 TS M09.1 TS1M3 SP1
Microsoft Windows NT Workstation9 TS M09.1 TS1M3 SP1
Microsoft Windows Server 2003 Enterprise Edition9 TS M09.1 TS1M3 SP1
Microsoft Windows Server 2003 Standard Edition9 TS M09.1 TS1M3 SP1
Microsoft® Windows® for 64-Bit Itanium-based Systems9 TS M09.1 TS1M3 SP1
Microsoft Windows 2000 Professional9 TS M09.1 TS1M3 SP1
Microsoft Windows 2000 Server9 TS M09.1 TS1M3 SP1
Microsoft Windows Server 2003 Datacenter Edition9 TS M09.1 TS1M3 SP1
Solaris9 TS M09.1 TS1M3 SP1
Microsoft Windows 2000 Advanced Server9 TS M09.1 TS1M3 SP1
Microsoft Windows 2000 Datacenter Server9 TS M09.1 TS1M3 SP1
HP-UX9 TS M09.1 TS1M3 SP1
Linux9 TS M09.1 TS1M3 SP1
64-bit Enabled Solaris9 TS M09.1 TS1M3 SP1
z/OS9 TS M09.1 TS1M3 SP1
HP-UX IPF9 TS M09.1 TS1M3 SP1
64-bit Enabled HP-UX9 TS M09.1 TS1M3 SP1
OpenVMS Alpha9 TS M09.1 TS1M3 SP1
64-bit Enabled AIX9 TS M09.1 TS1M3 SP1
Tru64 UNIX9 TS M09.1 TS1M3 SP1
AIX9 TS M09.1 TS1M3 SP1
* 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.