Hi Draycut, I tried out proc rank but it gives me equal number of observations in each assigned group. However, my want the group to threshold to be evenly spaced between maxinum and minimum with 10,000 buckets. I should assign the variable based on the value of the variable I looked at, so maybe group 1 will only have 1 observation, and group 30 will have 360 observations, do you know a solution for this? thank you! ... View more

my dataset would be something like: I have about 2330000 observations, I want to assign basically evenly spaced 10,000 buckets. The bucket criteira would the max(var)-min(var). So for example, my maximum value is 3000 and my minimum value is -200, So my bucket spread will be (3000+200)/10,000=0.32. And bucket 1 will be value between -200 to (-200+0.32), bucket 2 will be value between (-200+0.32) to (-200+0.32*2) and so on. I want to have a new variable that see if what bucket is falls into.   Var            New_var -200              1 -53                ? -5                  ? -46                ? 5 8 4 56 7542 242 .... ... View more