topic Forecast for daily using week parameter in Forecast Studio in SAS Forecasting and Econometrics https://communities.sas.com/t5/SAS-Forecasting-and-Econometrics/Forecast-for-daily-using-week-parameter-in-Forecast-Studio/m-p/214224#M1355 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I'm working on Forecasting a variable, and my model performance and MAPE is very good with Week settings rather than monthly basis. but my target is to forecast on monthly basis.</P><P>how do I convert the weekly forecast into monthly forecast.....?</P><P>please provide some inputs.</P><P></P><P>Naresh</P></BODY></HTML> Wed, 13 May 2015 13:53:07 GMT NareshAbburi 2015-05-13T13:53:07Z Forecast for daily using week parameter in Forecast Studio https://communities.sas.com/t5/SAS-Forecasting-and-Econometrics/Forecast-for-daily-using-week-parameter-in-Forecast-Studio/m-p/214224#M1355 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I'm working on Forecasting a variable, and my model performance and MAPE is very good with Week settings rather than monthly basis. but my target is to forecast on monthly basis.</P><P>how do I convert the weekly forecast into monthly forecast.....?</P><P>please provide some inputs.</P><P></P><P>Naresh</P></BODY></HTML> Wed, 13 May 2015 13:53:07 GMT https://communities.sas.com/t5/SAS-Forecasting-and-Econometrics/Forecast-for-daily-using-week-parameter-in-Forecast-Studio/m-p/214224#M1355 NareshAbburi 2015-05-13T13:53:07Z Re: Forecast for daily using week parameter in Forecast Studio https://communities.sas.com/t5/SAS-Forecasting-and-Econometrics/Forecast-for-daily-using-week-parameter-in-Forecast-Studio/m-p/214225#M1356 <HTML><HEAD></HEAD><BODY><P>Hi Naresh, If your "months" are based on some specified aggregation of weeks (such as 4/4/5 weeks per month in the 3 month quarter), you could just aggregate your weekly forecasts accordingly.</P><P></P><P>If your "months" are actual calendar months, then there is no sure way to map the weekly forecasts to monthly. In that case one option is to split the weekly forecasts into days (you'll have to figure out how best to do that), and then aggregate to calendar month. Or simply aggregate your historical data by calendar month and start forecasting in monthly buckets.</P><P></P><P>Or, if you are satisfied with the quality of the weekly forecasts, perhaps you can convince your management that they should be using weekly forecasts instead of monthly. I don't know your industry, but in most supply chain situations, forecasting and planning in weekly buckets is most appropriate.</P><P></P><P>--Mike</P></BODY></HTML> Tue, 19 May 2015 15:13:06 GMT https://communities.sas.com/t5/SAS-Forecasting-and-Econometrics/Forecast-for-daily-using-week-parameter-in-Forecast-Studio/m-p/214225#M1356 mvgilliland 2015-05-19T15:13:06Z