Solved: Optimal monotonic binning - SAS Support Communities

🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.

Quartz | Level 8

Quartz | Level 8

Optimal monotonic binning

Posted 01-09-2018 05:31 AM (3959 views)

Hi,

I would be grateful if anyone could tell me if is there any procedure in SAS base which allows do monotonic binning for numeric variables for dataset with target variable I work for . Something like interactive binning in SAS enterprise miner. I working on two SAS version one 9.04 and 9.4.

Thank you.

1 ACCEPTED SOLUTION

Accepted Solutions

Ammonite | Level 13

Ammonite | Level 13

Re: Optimal monotonic binning

Posted 01-09-2018 07:27 PM (4131 views) | In reply to Matt3

Is this the sort of thing you're looking for?

https://statcompute.wordpress.com/2017/09/24/granular-monotonic-binning-in-sas/

View solution in original post

3 REPLIES 3

Diamond | Level 26

Diamond | Level 26

Re: Optimal monotonic binning

Posted 01-09-2018 05:47 AM (3946 views) | In reply to Matt3

I have no idea what you mean by "monotonic binning"? You can do binning in Base SAS a fair few ways, one of the simplest being proc rank:

http://support.sas.com/documentation/cdl/en/proc/65145/HTML/default/viewer.htm#p16s2o8e4bnqrin1phywx...

Ammonite | Level 13

Ammonite | Level 13

Re: Optimal monotonic binning

Posted 01-09-2018 07:27 PM (4132 views) | In reply to Matt3

Is this the sort of thing you're looking for?

https://statcompute.wordpress.com/2017/09/24/granular-monotonic-binning-in-sas/

Quartz | Level 8

Quartz | Level 8

Re: Optimal monotonic binning

Posted 01-10-2018 03:06 AM (3890 views) | In reply to ChrisBrooks

I `ve thought there is custom procedure for the problem. Nevertheless Thank you.