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

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