Dear all, I have a huge dataset containing firms and how much their number of employees grow, the definition is so that the growth is always between -200 and 200 ( employees(t+1)-employees(t))/ average ). What I wanna do is group the employee growths in, say, 50 bins of equal length and indicate that with a variable with the value of the center of the interval, in a smart way. I would also like to know a nice way to do even if the bins doesn't have the same width so like they were: [-200,-190] , [-190,-180] ... [20,15],[15,10] etc. An example to clarify, in the case of [-200,200] and 40 bins: All the firms with an employee growth of between say 10 and 20 I would like to give the value 15 in a new variable, all the ones between 20 and 30, 25 etc. Hope my idea is clear and someone is willing to help (I made a really ugly macro which works, but now I have to change the bins and it's going to be hell) plus I wanna become better at SAS best regards, Henrik
... View more