so when the variable is char, how can I use PROC HPBIN to bin char variables? Thanks! ... View more

as I said before, 1 is an example, I want to re-assign some columns, for example PD = 1 or LGD/EAD = 100000 etc. 1 is just an example for understanding. ... View more

it means I still need the solution for this:   This is before:   and this is after:     no change to the last columns for example, and the name will be updated as Bin_XXX. Thanks! ... View more

thanks, but I still need the solution for changing the value for each column, not just to 1, 1 is an example, so how to do that? Thanks! ... View more

proc hpbin data=TEMP_INT WOE BINS_META=Mapping; ods output Mapping=Mapping; input DelinquentDays/numbin=4; target DelinquentDays/level=nominal order=desc; run;    what if I want to apply this HPBIN function to each of the column? What should I do? and what if there is some columns that I dont want to apply? maybe there is a exclusion list and all the columns not in the exclusion list need to go into the loop. is there a macro to do so? Thanks! ... View more

so would you please show me how to use the following dataset to directly calculate WOE and IV if there is no need to adjust? Thanks!  I want each table to have a fromat like this:   ... View more

I think the format is num as I need the variable to do the calculation ... View more

This is an example for one variable:  But I should apply the function for each of the variables in the dataset ... View more

yes, they only have 1 bin so after I set them to 1, I need to create a macro to calculate WOE and Information values for each of columns variables. ... View more

and the original columns still contain in the dataset ... View more

This is before: and this is after:   no change to the last columns for example, and the name will be updated as Bin_XXX ... View more