I'm trying to forecast the sales volume of 2 size(SizeA and SizeB) of one product using a three-year sales history. I have about 20 variables(including week, price, competitors price/volume, promotion dummy, holiday/season dummy) and 100 weeks data. My data set is like this(holiday and season are dummy variables like Thks, Spring, Fall, etc.):
I used stepwise/forward/backward to select some variables first and got about 10 variables for SizeA. And I was told to use proc mixed, proc panel, proc forecast to build the model. But I cannot understand how to code even after looking up the examples. And most examples has different sections but I don't think I have. Can somebody help me with the coding?
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.