Assign buckets to variable

yukine — Tue, 13 Jun 2017 10:10:49 GMT

I have about 2330000 observations, I want to assign evenly spaced 10,000 buckets. The bucket criteria would the max(var)-min(var)/10,000. So for example, my maximum value is 3000 and my minimum value is -200, So my bucket size will be (3000+200)/10,000=0.32. So any value between -200 to (-200+0.32) should go to bucket 1, and any value between (-200+0.32) to (-200+0.32*2) should go to bucket 2 and so on. The dataset will be something like this:

Var_value bucket

-200 1

-53 ?

-5 ?

-46 ?

7542

242

....

Re: Assign buckets to variable

PeterClemmensen — Tue, 13 Jun 2017 10:27:12 GMT

Please do not double post 🙂

Re: Assign buckets to variable

Ksharp — Tue, 13 Jun 2017 12:27:24 GMT

Why not use PROC RANK GROUPS=1000 .........?

topic Assign buckets to variable in SAS Programming

Assign buckets to variable

Re: Assign buckets to variable

Re: Assign buckets to variable