BookmarkSubscribeRSS Feed
abs0909
Calcite | Level 5

HI,

 

Could anyone exaplain me how to forecast using Root Mean Sqaure Error Method. The provided data is historical and is having the count for every hour the vehicle passed at certain signal. And I want to forecast for Next 7months. Urgent reply is highly appreciated.

3 REPLIES 3
mitrov
SAS Employee

Hi:

 

If you are new to forecasting, perhaps the easiest way to get started is to use a point-and-click interface which will guide you through the analysis, modeling and forecasting.

SAS Studio provides a point-and-click interface for generating SAS code and it includes forecasting tasks since release 3.4. It is available for free if you have SAS 9.4 or newer. 

 

This page has general information about SAS studio.

http://support.sas.com/software/products/sasstudio/faq/index.html

This page has documentation regarding SAS Studio and the forecasting tasks. 

http://support.sas.com/documentation/cdl/en/webeditorug/68254/HTML/default/viewer.htm#n0zupbjif1khpg...

 

I would recommend that you watch the tutorial videos about time series overviews:

http://support.sas.com/training/tutorial/studio/time-series-overview.html

And time series modeling and forecasting:

http://support.sas.com/training/tutorial/studio/time-series-modeling.html

 

If you are using an older release of SAS and don't have access to SAS studio, or you want a purely point-and-click interface, you can use the Time Series Forecasting System. You can find an overview here:

https://support.sas.com/rnd/app/ets/cap/ets_forecasting.html

 

I hope this information helps to get you started. 

 

 

abs0909
Calcite | Level 5

Hi,

 

Can u please tell me how to do this with excel.

mitrov
SAS Employee

There is an add-in for MS Office that enables you to use the Forecast Server engine with Excel. I recommend you contact out tech support to figure out whether that is part of the license you have or if you need additional licenses. 

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