BookmarkSubscribeRSS Feed
berlinpose2
Calcite | Level 5

So I need to forecast sales and have no idea how to even begin..?

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.

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.

HOW do I get the lowest MAD - beyond by depth here - please help/explain a possible approach.

1 REPLY 1
Reeza
Super User
Are you using SAS Forecast Server or Base SAS?

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

Multiple Linear Regression in SAS

Learn how to run multiple linear regression models with and without interactions, presented by SAS user Alex Chaplin.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 477 views
  • 0 likes
  • 2 in conversation