This example shows how you can use PROC HPBIN in single-machine mode.
The following DATA step creates the SAS data set as the input for the example:
data ex12;
length id 8;
do id=1 to 1000;
x1 = ranuni(101);
x2 = 10*ranuni(201);
x3 = 100*ranuni(301);
output;
end;
run;
The following statements show the basic usage:
proc hpbin data=ex12 output=out numbin=10 bucket ;
input x1-x3;
run;
proc print data=out(obs=10); run;
PROC HPBIN generates several ODS tables, which are shown in Output 4.1.1 through Output 4.1.2.
Output 4.1.2: PROC HPBIN Mapping Table
| Mapping | ||||
|---|---|---|---|---|
| Variable | Binned Variable | Range | Frequency | Proportion |
| x1 | BIN_x1 | x1 < 0.099925 | 108 | 0.10800000 |
| 0.099925 <= x1 < 0.199399 | 94 | 0.09400000 | ||
| 0.199399 <= x1 < 0.298872 | 90 | 0.09000000 | ||
| 0.298872 <= x1 < 0.398345 | 95 | 0.09500000 | ||
| 0.398345 <= x1 < 0.497818 | 90 | 0.09000000 | ||
| 0.497818 <= x1 < 0.597291 | 115 | 0.11500000 | ||
| 0.597291 <= x1 < 0.696764 | 116 | 0.11600000 | ||
| 0.696764 <= x1 < 0.796237 | 105 | 0.10500000 | ||
| 0.796237 <= x1 < 0.895711 | 106 | 0.10600000 | ||
| 0.895711 <= x1 | 81 | 0.08100000 | ||
| x2 | BIN_x2 | x2 < 1.021539 | 99 | 0.09900000 |
| 1.021539 <= x2 < 2.015407 | 110 | 0.11000000 | ||
| 2.015407 <= x2 < 3.009275 | 99 | 0.09900000 | ||
| 3.009275 <= x2 < 4.003143 | 85 | 0.08500000 | ||
| 4.003143 <= x2 < 4.997011 | 109 | 0.10900000 | ||
| 4.997011 <= x2 < 5.990878 | 98 | 0.09800000 | ||
| 5.990878 <= x2 < 6.984746 | 100 | 0.10000000 | ||
| 6.984746 <= x2 < 7.978614 | 94 | 0.09400000 | ||
| 7.978614 <= x2 < 8.972482 | 112 | 0.11200000 | ||
| 8.972482 <= x2 | 94 | 0.09400000 | ||
| x3 | BIN_x3 | x3 < 10.173597 | 97 | 0.09700000 |
| 10.173597 <= x3 < 20.142996 | 97 | 0.09700000 | ||
| 20.142996 <= x3 < 30.112396 | 106 | 0.10600000 | ||
| 30.112396 <= x3 < 40.081796 | 94 | 0.09400000 | ||
| 40.081796 <= x3 < 50.051196 | 102 | 0.10200000 | ||
| 50.051196 <= x3 < 60.020596 | 99 | 0.09900000 | ||
| 60.020596 <= x3 < 69.989995 | 107 | 0.10700000 | ||
| 69.989995 <= x3 < 79.959395 | 92 | 0.09200000 | ||
| 79.959395 <= x3 < 89.928795 | 91 | 0.09100000 | ||
| 89.928795 <= x3 | 115 | 0.11500000 | ||
In this example, PROC HPBIN also generates the output table. The first 10 observations of the table are shown in Output 4.1.3.