topic Extend date series in EGuide to forecast in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/Extend-date-series-in-EGuide-to-forecast/m-p/83808#M8019 <HTML><HEAD></HEAD><BODY><P>I am working on a forecasting project where I am calculating moving averages.&nbsp; 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).&nbsp; 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.&nbsp; Does anyone know of an easy way to add the dates to the end of my dataset and calculate the moving averages post-manipulation?</P></BODY></HTML> Thu, 18 Jul 2013 19:48:54 GMT claireluen 2013-07-18T19:48:54Z Extend date series in EGuide to forecast https://communities.sas.com/t5/SAS-Enterprise-Guide/Extend-date-series-in-EGuide-to-forecast/m-p/83808#M8019 <HTML><HEAD></HEAD><BODY><P>I am working on a forecasting project where I am calculating moving averages.&nbsp; 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).&nbsp; 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.&nbsp; Does anyone know of an easy way to add the dates to the end of my dataset and calculate the moving averages post-manipulation?</P></BODY></HTML> Thu, 18 Jul 2013 19:48:54 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Extend-date-series-in-EGuide-to-forecast/m-p/83808#M8019 claireluen 2013-07-18T19:48:54Z Re: Extend date series in EGuide to forecast https://communities.sas.com/t5/SAS-Enterprise-Guide/Extend-date-series-in-EGuide-to-forecast/m-p/83809#M8020 <HTML><HEAD></HEAD><BODY><P>If your dataset is ordered ... would the lag funtion be helpful?</P><P>See: <A href="http://support.sas.com/documentation/cdl/en/lefunctionsref/64814/HTML/default/viewer.htm#n0l66p5oqex1f2n1quuopdvtcjqb.htm" title="http://support.sas.com/documentation/cdl/en/lefunctionsref/64814/HTML/default/viewer.htm#n0l66p5oqex1f2n1quuopdvtcjqb.htm">SAS(R) 9.4 Functions and CALL Routines: Reference</A>&nbsp;&nbsp; (lag samples - several: calculation moving average) </P></BODY></HTML> Thu, 18 Jul 2013 20:03:28 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Extend-date-series-in-EGuide-to-forecast/m-p/83809#M8020 jakarman 2013-07-18T20:03:28Z Re: Extend date series in EGuide to forecast https://communities.sas.com/t5/SAS-Enterprise-Guide/Extend-date-series-in-EGuide-to-forecast/m-p/83810#M8021 <HTML><HEAD></HEAD><BODY><P>I don't think so.&nbsp; Basically I just want to tack on 12 months to the end of my time series.&nbsp; I know how to calculate the moving averages.&nbsp; The problem is just that when my dates end, so does my dataset and the moving averages stop calculating.&nbsp; I am looking for an easy way to extend my dates into 2014 so that I can get the moving averages for those months as well.</P></BODY></HTML> Thu, 18 Jul 2013 20:09:15 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Extend-date-series-in-EGuide-to-forecast/m-p/83810#M8021 claireluen 2013-07-18T20:09:15Z Re: Extend date series in EGuide to forecast https://communities.sas.com/t5/SAS-Enterprise-Guide/Extend-date-series-in-EGuide-to-forecast/m-p/83811#M8022 <HTML><HEAD></HEAD><BODY><P>You can create the dates/data in a dataset and then append them, and then calculate your moving averages. </P><P>Does that make sense to you?</P><P></P><P>If so, provide a sample of what your data looks like, what you expect as output and someone can help with the coding or instructions on how to use EG to get it done. </P></BODY></HTML> Thu, 18 Jul 2013 20:24:07 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Extend-date-series-in-EGuide-to-forecast/m-p/83811#M8022 Reeza 2013-07-18T20:24:07Z Re: Extend date series in EGuide to forecast https://communities.sas.com/t5/SAS-Enterprise-Guide/Extend-date-series-in-EGuide-to-forecast/m-p/83812#M8023 <HTML><HEAD></HEAD><BODY><P>The append is what I needed.&nbsp; Thank you, Reeza.</P></BODY></HTML> Thu, 18 Jul 2013 21:03:09 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Extend-date-series-in-EGuide-to-forecast/m-p/83812#M8023 claireluen 2013-07-18T21:03:09Z