The HPBIN Procedure

This example shows pseudo–quantile binning that is executed in distributed mode. The following DATA step generates 1,000,000 observations:

    data ex12;
        length id 8;
        do id=1 to 1000000;
            x1 = ranuni(101);
            x2 = 10*ranuni(201);
            output;
        end;
    run;
    

To run this program in distributed mode, you need to specify two macros for the GRIDHOST= and GRIDINSTALLLOC= options:

 ods output BinInfo=bininfo;
 ods output PerformanceInfo=perfInfo;
 ods output Mapping=mapTable;
 ods output Summary=Summary;
 ods output Quantile=Quantile;
 ods listing close;
 proc hpbin data=ex12 output=out numbin=10 pseudo_quantile 
            computestats computequantile ;
     input x1-x2; 
     performance nodes=4 nthreads=8 details
     host="&GRIDHOST" install="&GRIDINSTALLLOC";
 run;
 ods listing;

The “Performance Information” table in Output 3.2.1 shows the grid setting.

The “Binning Information” table in Output 3.2.2 shows the binning method, number of bins, and number of variables.

The “Mapping” table in Output 3.2.3 shows the level mapping of the input variables.

The “Summary Statistics” table in Output 3.2.4 displays the basic statistical information, including the number of observations, number of missing observations, mean, pseudo-median, and so on.

The “Estimated Quantiles and Extremes” table in Output 3.2.5 shows the quantile estimation of the given variables. The ODS table is generated only when the COMPUTESTATS option is specified in the PROC HPBIN statement.