topic proc HPBIN in SAS Programming

proc HPBIN

asifgeneral — Sat, 18 May 2019 12:55:44 GMT

Hello,

Can proc HPBIN handle categorical variables? If not what is the most efficient ways of collapsing categorical variables.

Thanks,

Re: proc HPBIN

PeterClemmensen — Sat, 18 May 2019 13:00:38 GMT

Yes, that should not be a problem. What does your data look like?

Re: proc HPBIN

asifgeneral — Sat, 18 May 2019 13:05:00 GMT

Thanks for your response

Here is the code that I am trying.

proc hpbin data=pg1.hmeq output=work.woebinn numbin=3 winsor;
input mortdue;
input yoj;
input job;
ods output mapping=mapping
run;

I am getting the output as expected for the two interval variables, but for job...

ERROR: JOB is class variable, only interval variable is supported.

Re: proc HPBIN

Ksharp — Sat, 18 May 2019 13:35:11 GMT

https://communities.sas.com/t5/Mathematical-Optimization/Trying-to-use-PROC-OPTMODEL-for-monotonic-supervised-optimal/m-p/553822#M2686

There is a my paper

“Get Better Weight of Evidence for Scorecards Using a Genetic Algorithm.”

https://www.sas.com/content/dam/SAS/support/en/sas-global-forum-proceedings/2018/1808-2018.pdf

To bin category variable to make IV bigger.

Re: proc HPBIN

asifgeneral — Sat, 18 May 2019 14:12:10 GMT

Thanks for your response!

Being a novice in this field of credit scoring, I will take some time to digest the information. 🙂

Will get back in case of any doubts. Thanks for your time and helping me out with the resources.

Regards,

Re: proc HPBIN

chapidi99 — Mon, 27 Jan 2020 11:34:55 GMT

Hello,

Why would you like to bin categorical variables? The categorical variables will already have categories. It is meaningful to categorise continious variables to create groups to measure the strength of the groups.

For example, you have the column House_Status with the categories "Own_House", 'Rented' and "Missing". How would you further categorise them. Even if you assign a numeric value as, for example, Own_House = 0, Rented = 1 and Missing = 2 further categorising them wouldn't make any sense.

Many thanks,

Kiran Chapidi