Each table that the HPBIN procedure creates has a name associated with it. You must use this name to refer to the table in ODS statements. These table names are listed in Table 3.2.
Table 3.2: ODS Tables Produced by PROC HPBIN
Table Name |
Description |
Statement |
Options |
---|---|---|---|
BinInfo |
Basic binning information and parameters |
PROC HPBIN |
Default |
InfoValue |
Information value for each variable |
PROC HPBIN |
WOE |
Mapping |
Level mapping information |
PROC HPBIN |
Default |
NObs |
Number of observations read and used |
PROC HPBIN |
WOE |
PerformanceInfo |
Information about the high-performance computing environment |
PROC HPBIN |
Default |
Quantile |
Quantiles and extremes |
PROC HPBIN |
COMPUTEQUANTILE |
Summary |
Summary statistics for the given variables |
PROC HPBIN |
COMPUTESTATS |
Trim |
Trimmed statistics for the given variables |
PROC HPBIN |
WINSOR, WINSORRATE |
Winsor |
Winsor statistics for the given variables |
PROC HPBIN |
WINSOR, WINSORRATE |
WOE |
Weight of evidence for each bin |
PROC HPBIN |
WOE |
Timing |
Timing |
PERFORMANCE |
DETAILS |
The following list provides more information about these tables:
By default, PROC HPBIN generates the "Binning Information" table in its ODS output. This table displays some procedure parameters and data information, which includes the binning method, the number of bins, and the number of variables.
PROC HPBIN generates the "Information Value" table if you specify the WOE option in the PROC HPBIN statement. This table provides the information value for each variable.
By default, PROC HPBIN generates a "Mapping" table in its ODS output. This table provides the level mapping for the input variables. The level starts at 1 and increases to the value that you specify in the NUMBIN= option. In the mapping table, a missing value for the lower bound indicates negative infinity, and a missing value for the upper bound indicates positive infinity.
The final bin level can be less than the NUMBIN value if the input data are small or the binning variable is discrete. In this case, a warning message is printed in the log.
PROC HPBIN generates the "Nobs" table if you specify the WOE option. This table provides the number of observations that are read and used.
By default, PROC HPBIN produces the "Performance Information" table. It displays information about the execution mode. For single-machine mode, the table displays the number of threads used. For distributed mode, the table displays the number of compute nodes and the number of threads per node.
PROC HPBIN generates the "Quantiles and Extremes" table if you specify the COMPUTEQUANTILE option. This table contains the following quantile levels for each variable: 0% (Min), 1%, 5%, 10%, 15%, 25% (Q1), 50% (Median), 75% (Q3), 90%, 95%, 99%, and 100% (Max).
PROC HPBIN generates the "Summary Statistics" table if you specify the COMPUTESTATS option. This table displays the variable name, number of nonmissing observations, number of missing observations, mean, median, standard deviation, minimum, maximum, and number of bins.
PROC HPBIN also generates the "Trimmed Statistics" table if you specify the WINSOR option. This table contains the trimmed minimum, maximum, mean, standard error mean, left tail, left tail percentage, right tail, and right tail percentage, and the degrees of freedom (DF).
PROC HPBIN generates the "Winsor Statistics" table if you specify the WINSOR option. The "Winsor Statistics" table contains the Winsorized minimum, maximum, mean, standard error mean, left tail, left tail percentage, right tail, and right tail percentage, and the degrees of freedom (DF).
PROC HPBIN generates the "Weight of Evidence" table if you specify the WOE option in the PROC HPBIN statement. This table provides the level mapping information, binning information, weight of evidence, and information value for each bin.
When the "Weight of Evidence" table is printed, the "Mapping" table is not printed because the level mapping information is the same in both tables.
In addition to the level mapping information, the "Weight of Evidence" table contains some other information such as the non-event count, non-event rate, event count, event rate, weight of evidence, and information value for each bin.