• Print |
• E-mail  |
• Bookmark

PROC MEANS/SUMMARY may incorrectly assign a missing value to a weighted statistic. The problem occurs when there are multiple VAR statements, each with a different WEIGHT variable specified and one or more of the WEIGHT variable values is missing on a previous VAR statement.

In the example below, Z will have a missing weighted mean for some observations even though W1 has no missing values. W2 does have missing values, and they are incorrectly affecting the statistics for Z.

data test;
 input x y z w1 w2;
 cards;
2 3 4 1 1
2 3 4 1 .
;
run;

proc means data=test;
  var x / weight=w1;
  var y / weight=w2;
  var z / weight=w1;
run;

A Technical Support hot fix for Release 8.2 (TS2M0) for this issue is available at: http://www.sas.com/techsup/download/hotfix/82_sbcs_prod_list.html#014737

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

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

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

Operating System and Release Information

A fix for Release 8.2 (TS2M0) for this issue is available at:

A fix for Release 8.2 (TS2M0) with Asian Language Support (DBCS) for this issue is available at:

A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at :