BookmarkSubscribeRSS Feed
deleted_user
Not applicable
hi all,
I need some help regarding the forecasting the sales.
my working environment is windows2000, sas/base, sas/stat, sas/graph and enterprise guide4.1.

my data like this:
month 2004 2005 2006 2007 2008 2009
APR 94 592 244
MAY 418 627 820 168 407
JUN 916 1050 1134 800 827
JUL 1628 1785 1826 1409 1402
AUG 2326 2950 2661 2873 3464
SEP 8684 8555 9791 8147 7985
OCT 12919 12376 13802 12681 10665
NOV 20760 17523 20791 20372
DEC 30567 24782 28980 28003




i would like to calculate the predicted sales for the 2008 NOV,DEC and 2009 .

could you please recommend the ways to do this.

advanced
Thanks & Regards,
suresh
2 REPLIES 2
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
You will find useful reference information and SAS documentation at the SAS support website http://support.sas.com/ and use the SEARCH box or a Google advanced search (using the site:sas.com Google parameter) to find topic material requested.

Scott Barry
SBBWorks, Inc.
udo_sas
SAS Employee
Hi -
Since you don't seem to have access to SAS/ETS you might want to review an earlier thread in this forum called "Time series analysis without ETS" (see: http://support.sas.com/forums/thread.jspa?threadID=2849&tstart=15).
For this kind of forecasting analysis in SAS/ETS the following data structure seems to be more appropriate:
Date Dependent
01APR2004 94
01MAY2004 592
01JUN2004 916
...
01OCT2008 10665

Thanks,
Udo

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

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
  • 847 views
  • 0 likes
  • 3 in conversation