Hi all, 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.): ref_num Week_ending SizeAvol SizeBlvol SizeApro SizeBpro CompetitorSizeApro CompetitorSizeBpro SizeApri SizeBpri CompetitorSizeApri CompetitorSizeBpri lSizeAvol lSizeBvol Week HolidayA SeasonA 1 17OCT2000 00:00:00 34000 9441 0 0 1 1 5.0198 3.9726 3.6854 2.7954 . . 1 0 1 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? Thanks!! Akilees
... View more