BINNING Procedure

(View the complete code for this example.)

The following statements show how you can use the BINNING procedure to perform tree-based binning:

data mylib.hmeq;
    set sampsio.hmeq;
run;

proc binning data=mylib.hmeq method=tree;
 target bad/level=int;
 input mortdue/level = int;
 input job/ level = nom;
 output outlevelbinmap=mylib.outlevel;
run;

proc print data=mylib.outlevel;
run;

The DATA= option specifies the input data table. The METHOD= option requests that tree-based binning method be used. The TARGET statement specifies bad as the target variable and requests that it be treated as an interval variable. The first INPUT statement names one variable, mortdue, and requests that it be treated as interval. The second INPUT statement names one variable, job, and requests that it be treated as nominal.

Output 5.5.1 shows the "Bin Details" table. Compared to the "Bin Details" tables in previous examples, this table has an extra column, "N Levels". The reason is that other binning methods can handle only interval variables, but tree-based binning can handle both interval and nominal variables. The "N Levels" column shows the number of levels of this variable that this bin contains. As a result, for interval variables, this column is empty.

Output 5.5.2 shows the "Transformation Information" table.

Output 5.5.3 shows the "Output Bin Mapping" data table.