BookmarkSubscribeRSS Feed
akilees
Calcite | Level 5

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_numWeek_endingSizeAvolSizeBlvolSizeAproSizeBproCompetitorSizeAproCompetitorSizeBproSizeApriSizeBpriCompetitorSizeApriCompetitorSizeBprilSizeAvollSizeBvolWeekHolidayASeasonA
117OCT2000 00:00:0034000944100115.01983.97263.68542.7954..101

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

2 REPLIES 2
udo_sas
SAS Employee

Hi Akilees -

My suggestion would be to start with a univariate model and try to add complexity like input variables later.

Please have a look at PROC ESM as a start - you will need to make sure that you data is in time series format in order to use that (or any other time series forecasting) procedure.

Check out: http://support.sas.com/documentation/cdl/en/etsug/66100/HTML/default/viewer.htm#etsug_esm_gettingsta... as a starting point - you will find lots of information about time series data here: http://support.sas.com/documentation/cdl/en/etsug/66100/HTML/default/viewer.htm#etsug_tsdata_toc.htm

The way I see it you will need to do something like:

PROC ESM ...;

id week_ending interval=week;

forecast sizeAvol SizeBvol;

run;

Note that this code will run a simple ESM by default, so you may want to look at the model option of the FORECAST statement for more advanced models.

For more complex models, such as ARIMAX or UCM, which allow you to take independent variables into account please refer to either PROC ARIMA or PROC UCM.

All of these procedures are features in SAS/ETS software.

Thanks,

Udo

akilees
Calcite | Level 5

Thank you Udo!

I later realized my data is not panel data, I'm supposed to find the most important factors and get an equation to estimate the sales.  But I really learned a lesson from the procedure you told me.

Best Regards,

Jia

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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
  • 2 replies
  • 1028 views
  • 3 likes
  • 2 in conversation