Hello forum, I am trying to calculate cumulative percent for the variable prob for each of the bin level. so for bin = 'a' with 4 counts, the cum % should be 0.2/4 (0.2+0.3)/4 and so on .. for each of the bin levels. data test; input bin $ prob; cards; a .2 a .3 a .6 a .8 b .5 b .6 b .7 b .8 c .1 c .4 c .5 c .7 c .8 .... ; what I would like to see is .. bin prob cum_per a .2 0.05 a .3 0.125 a .6 0.275 a .8 0.475 b .5 0.125 b .6 0.275 b .7 0.45 b .8 0.65 c .1 0.02 c .4 0.08 c .5 0.1 c .7 0.14 c .8 0.16 Thanks in advance for you help!
... View more