topic Equal width Binning in SAS Programming

Equal width Binning

RandyStan — Mon, 22 Jun 2020 03:27:47 GMT

Dear All I want to construct equal width binning for at least 10 variables. So for each variable I calculate the MIN and the MAX and then to find the equal widths (EW) I do (Max - Min)/10. To create the bins (I do not have Proc HPBIN) can I do the following Proc format ; value Bins MIN LE Var_A < (EW+ MIN) = '1' (EW+ MIN) LE VAR_A < (2*(EW) + MIN) = '2' ; and so on. If not, is there a better way to construct equal width bins? Randy

Re: Equal width Binning

Norman21 — Mon, 22 Jun 2020 05:26:47 GMT

Some methods are given here:

https://blogs.sas.com/content/iml/2019/08/07/essential-guide-binning-sas.html

Re: Equal width Binning

ChrisNZ — Mon, 22 Jun 2020 06:05:09 GMT

You method does not guarantee equal populations. proc rank is the most used method for your purpose.

Re: Equal width Binning

Ksharp — Mon, 22 Jun 2020 11:11:48 GMT

Here some code could help.