Hello, dear experts. I have a problem related to ranking growth rate in sas. I have computed growth rate as annual growth rate. The thing that I want to do next is to rank the previous 5 year growth rate, given the year of formation, which starts in 1968. Can someone please help me? I would be very thankful. 🙂 Data have: YEAR ID Growth Rate 1963 1 1% 1964 1 2% 1965 1 2% 1966 1 3% 1967 1 0,5% 1968 1 5% 1969 1 6% 1970 1 7% Data want: YEAR ID Growth Rate RANK1 RANK2 RANK3 RANK4 RANK5 1963 1 1% 1964 1 2% 1965 1 2% 1966 1 3% 1967 1 0,5% 1968 1 5% 3% 2% 2% 1% 0,5% 1969 1 6% 5% 3% 2% 2% 0,5% 1970 1 7% 6% 5% 3% 2% 0,5% This is just an example, by orginal want file has many years, IDs, and growth rates. I also wonder about what to do with "tied" ranks, like the 2% in both.
... View more