Moving average or rolling average is the term to use in Google for this, but it depends on how your data is structured. If you have SAS/ETS this is quite easy, but also very doable within a data step as well. SAS/ETS example of 12 month moving average https://gist.github.com/statgeek/07a3708dee1225ceb9d4aa75daab2c52 Data step, array approach https://gist.github.com/statgeek/27e23c015eae7953eff2
... View more