https://communities.sas.com/t5/SAS-Forecasting-and-Econometrics/Forecasting-Model/m-p/669612#M3900 <DIV class="_3xX726aBn29LDbsDtzr_6E _1Ap4F5maDtT1E1YuCiaO0r D3IL3FD0RFy_mkKLPwL4"><DIV class="_292iotee39Lmt0MkQZ2hPV RichTextJSON-root"><P class="_1qeIAgB0cPwnLhDF9XSiJM">So I need to forecast sales and have no idea how to even begin..?</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">The dataset contains weekly sales for both Pepsi 12 pack and 2 liter, their corresponding prices, dummy variables = 1 if there was a promotion that week, 0 otherwise, Coke prices and promotions, and dummy variables representing season and holidays. Also has means and standard deviations.</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">I need to provide forecast equations for both Pepsi 12 pack and 2 liter. I must have the lowest MAD, mean absolute deviation, across successive 4 week periods possible.</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">HOW do I get the lowest MAD - beyond by depth here - please help/explain a possible approach.</P></DIV></DIV> Wed, 15 Jul 2020 17:36:23 GMT berlinpose2 2020-07-15T17:36:23Z https://communities.sas.com/t5/SAS-Forecasting-and-Econometrics/Forecasting-Model/m-p/669612#M3900 <DIV class="_3xX726aBn29LDbsDtzr_6E _1Ap4F5maDtT1E1YuCiaO0r D3IL3FD0RFy_mkKLPwL4"><DIV class="_292iotee39Lmt0MkQZ2hPV RichTextJSON-root"><P class="_1qeIAgB0cPwnLhDF9XSiJM">So I need to forecast sales and have no idea how to even begin..?</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">The dataset contains weekly sales for both Pepsi 12 pack and 2 liter, their corresponding prices, dummy variables = 1 if there was a promotion that week, 0 otherwise, Coke prices and promotions, and dummy variables representing season and holidays. Also has means and standard deviations.</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">I need to provide forecast equations for both Pepsi 12 pack and 2 liter. I must have the lowest MAD, mean absolute deviation, across successive 4 week periods possible.</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">HOW do I get the lowest MAD - beyond by depth here - please help/explain a possible approach.</P></DIV></DIV> Wed, 15 Jul 2020 17:36:23 GMT https://communities.sas.com/t5/SAS-Forecasting-and-Econometrics/Forecasting-Model/m-p/669612#M3900 berlinpose2 2020-07-15T17:36:23Z https://communities.sas.com/t5/SAS-Forecasting-and-Econometrics/Forecasting-Model/m-p/669677#M3902 Are you using SAS Forecast Server or Base SAS? Wed, 15 Jul 2020 19:39:45 GMT https://communities.sas.com/t5/SAS-Forecasting-and-Econometrics/Forecasting-Model/m-p/669677#M3902 Reeza 2020-07-15T19:39:45Z