For Winsorized binning, PROC HPBIN provides both the bucket binning and the basic Winsorized statistical information for the input data. The following statements include both the WINSOR and WINSORRATE=0.05 options and generate tables for both Winsor and trimmed statistics.
data ex12; length id 8; do id=1 to 10000; x1 = ranuni(101); x2 = 10*ranuni(201); x3 = 100*ranuni(301); output; end; run;
ods output Winsor=Winsor; ods output Trim=Trim; ods listing close; proc hpbin data=ex12 NUMBIN=10 WINSOR WINSORRATE=0.05; input x1-x2; run; ods listing;
The preceding statements generate Output 3.3.1 and Output 3.3.2.
Output 3.3.1: PROC HPBIN Winsorized Statistics
Winsorized Statistics | |||||||
---|---|---|---|---|---|---|---|
Variable | Mean | Std Error Mean |
N Left Tail |
Percent Left Tail |
N Right Tail |
Percent Right Tail |
DF |
x1 | 0.50176 | 0.00316 | 500 | 5.00000 | 501 | 5.01000 | 8998 |
x2 | 5.03026 | 0.03185 | 500 | 5.00000 | 501 | 5.01000 | 8998 |
Output 3.3.2: PROC HPBIN Trimmed Statistics
Trimmed Statistics | |||||||
---|---|---|---|---|---|---|---|
Variable | Mean | Std Error Mean |
N Left Tail |
Percent Left Tail |
N Right Tail |
Percent Right Tail |
DF |
x1 | 0.50209 | 0.00316 | 500 | 5.00000 | 501 | 5.01000 | 8998 |
x2 | 5.03201 | 0.03185 | 500 | 5.00000 | 501 | 5.01000 | 8998 |