I am working on a forecasting project where I am calculating moving averages. I would like to calculate these monthly moving averages through July 2014 in SAS Enterprise Guide, however, the dates in my data set only go to July 2013 (because the historical data is only reported to the present date). I have done extensive manipulation of my data set and it is difficult for me to go back and add those dates to the end of the Excel file that I originally pulled the data from. Does anyone know of an easy way to add the dates to the end of my dataset and calculate the moving averages post-manipulation?
... View more