Outline of the Forecasting Process (2024)

Chapter Contents Previous Next

Getting Started with Time Series Forecasting


The examples shown in the following sections illustratethe basic process you will use with the Forecasting System.

Specify the Input Data Set

Suppose you have a number of time series, variables recorded over time,for which you want to forecast future values.The past values of these time series are stored as variablesin a SAS data set or data view.The observations of this data set correspond to regular time periods,such as days, weeks, or months.The first step in the forecasting process is to tell the system to usethis data set by setting the Data Set field.

If your time series are not in a SAS data set,you must provide a way for the SAS System to access the data.You can use SAS features to read your data into a SAS data set;refer to SAS Language Reference.You can use a SAS/ACCESS product to establish a view of data in adatabase management system; refer to SAS/ACCESS documentation.You can use PROC SQL to create a SAS data view.You can use PROC DATASOURCE to read data from files supplied by supporteddata vendors; refer to Chapter 10, "The DATASOURCE Procedure," for more details.

Provide a Valid Time ID Variable

To use the Forecasting System, your data set must be dated:the data set must contain a time ID variable that gives thedate of each observation.The time ID variable must represent the observation dates withSAS date valuesor with SAS datetime values(for hourly data or other frequencies less than a day),or you can use a simple time index.

When SAS date values are used,the ID variable contains dates withinthe time periods corresponding to the observations.For example, for monthly data, the values for the time ID variable may bethe date of the first day of the month corresponding to each observation,or the time ID variable may contain the date of the last day in the month.(Any date within the period will serve as the time ID for the observation.)

If your data set already contains a valid time ID variablewith SAS date or datetime values,the next step is to specify this time ID variable in the Time ID field.If the time ID variable is named DATE,the system fills in the Time ID field automatically.

If your data set does not contain a time ID, you mustadd a valid time ID variable before beginning the forecasting process.The Forecasting System provides features that make this easy to do.See Chapter 24, "Creating Time ID Variables," for details.

Select and Fit a Forecasting Model for each Series

If you are using the automated model selection feature,the system performs this step for you and chooses a forecastingmodel for each series automatically.All you need to do is select the Fit Models Automatically buttonand then select the variables to fit models for.

If you want more control over forecasting model selection,you can select the Develop Models button,select the series you want to forecast,and use the Develop Models window to specify a forecasting model.As part of this process, you may use the Time Series Viewerand Model Viewer graphical tools.Once you have selected a model for the first series,you can select a different series to work withand repeat the model development process until you havecreated forecasting models for all the series you want to forecast.

The system provides many features to help you choose the bestforecasting model for each series. The features of the Develop Modelswindow and graphical viewer tools are introduced in later sections.

Produce the Forecasts

Once a forecasting model has been fit for each series,select the Produce Forecasts buttonand use the Produce Forecasts window to compute forecastvalues and store them in a SAS data set.

Save Your Work

If you want only a single forecast, your task is now complete.But you may want to produce updated forecasts later,as more data becomes available.In this case, you want to save the forecasting models youhave created, so that you will not need to repeat the modelselection and fitting process.

To save your work, fill in the Project fieldwith the name of a SAS catalog member in which the systemwill store the model information when you exit the system.Later, you will select the same catalog member name whenyou first enter the Forecasting System, and the model informationwill be reloaded.

Note that any number of people can work with the same project file.If you are working on a forecasting project as part of a team,you should take care to avoid conflicting updates to the project fileby different team members.

Summary

This is the basic outline of how the Forecasting System works.The system offers many other features and options that you may need to use(for example, the time range of the data used to fit models and how far intothe future to forecast).These options will become apparent as you work with the Forecasting System.

As an introductory example,the following sections use theAutomatic Model Fitting and Produce Forecasts windowsto perform automated forecasting of theseries in an example data set.

Chapter Contents Previous Next Top

Copyright © 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.

Outline of the Forecasting Process (2024)

FAQs

What are the 5 steps in the forecasting process? ›

  • Step 1: Problem definition.
  • Step 2: Gathering information.
  • Step 3: Preliminary exploratory analysis.
  • Step 4: Choosing and fitting models.
  • Step 5: Using and evaluating a forecasting model.

What are the processes of forecasting? ›

Forecasting is the process of making predictions based on past and present data. Later these can be compared (resolved) against what happens. For example, a company might estimate their revenue in the next year, then compare it against the actual results creating a variance actual analysis.

What are the 7 steps in a forecasting system? ›

7 Steps of Demand Forecasting Process
  • Define the purpose and scope of demand forecasting.
  • Identify key factors influencing demand.
  • Select an appropriate forecasting method.
  • Gather and prepare relevant historical data.
  • Implement the chosen forecasting method.
  • Evaluate the initial forecast results.
  • Approval: Evaluation Results.

What are the steps in the forecasting process put them in order? ›

Here are some steps in the process:
  • Develop the basis of forecasting. The first step in the process is investigating the company's condition and identifying where the business is currently positioned in the market.
  • Estimate the future operations of the business. ...
  • Regulate the forecast. ...
  • Review the process.

What are the four 4 main components in a forecast? ›

When setting up a forecasting process, you will have to set it across four dimensions: granularity, temporality, metrics, and process (I call this the 4-Dimensions Forecasting Framework). We will discuss these dimensions one by one and set up our demand forecasting process based on the decisions you need to make.

What is the correct order of forecasting process? ›

Answer and Explanation:

Selection of the forecasting methodology to be applied. Applying statistics such as data collection, research and analysis. Drawing the findings from the data obtained. And, eventually, follow up and forecast.

What are the 3 most important components of forecasting? ›

3 Important Elements of Financial Forecasting
  1. Historical (Quantitative) Data Gathering. ...
  2. Research-Based (Qualitative) Data Gathering. ...
  3. Take the Middle Ground.

Which of the following are key steps in the forecasting process? ›

There are six basic steps in the forecasting process:
  • Determine the purpose of the forecast. How will it be used and when will it be needed? ...
  • Establish a time horizon. ...
  • Obtain, clean, and analyze appropriate data. ...
  • Select a forecasting technique.
  • Make the forecast.
  • Monitor the forecast errors.
Jun 29, 2023

What are the 4 principles of forecasting? ›

The general principles are to use methods that are (1) structured, (2) quantitative, (3) causal, (4) and simple.

How do you create a forecasting process? ›

How to do financial forecasting in 7 steps
  1. Define the purpose of a financial forecast. ...
  2. Gather past financial statements and historical data. ...
  3. Choose a time frame for your forecast. ...
  4. Choose a financial forecast method. ...
  5. Document and monitor results. ...
  6. Analyze financial data. ...
  7. Repeat based on the previously defined time frame.

What is the simplest forecasting method? ›

The straight-line method is one of the simplest and easy-to-follow forecasting methods. A financial analyst uses historical figures and trends to predict future revenue growth.

What are the five basic steps of demand forecasting? ›

What are the steps of demand forecasting?
  • Outlining the objectives. ...
  • Timeline of Forecast. ...
  • Determinants of demand. ...
  • Choosing a method for Demand Forecasting. ...
  • Collection & organization of data. ...
  • Demand Estimation & Results Interpretation.
Mar 10, 2023

What is an example of forecasting process? ›

Forecasts often include projections showing how one variable affects another over time. For example, a sales forecast may show how much money a business might spend on advertising based on projected sales figures for each quarter of the year.

What are the basic steps in a forecasting task? ›

Analyse the data: Use the chosen method to examine the data and look for patterns, trends, or relationships. This analysis will help you make informed predictions about future events or outcomes. Make the forecast: Based on your analysis, make educated guesses about what might happen in the future.

What are the five processes of forecasting? ›

The major steps that should be addressed in forecasting include: Establishing the business need. Acquiring data. Building the forecasting model. Evaluating the results.

What are the 5 factors influencing the selection of forecasting methods? ›

The selection of a method depends on many factors—the context of the forecast, the relevance and availability of historical data, the degree of accuracy desirable, the time period to be forecast, the cost/benefit (or value) of the forecast to the company, and the time available for making the analysis.

Top Articles
Latest Posts
Article information

Author: Dan Stracke

Last Updated:

Views: 6125

Rating: 4.2 / 5 (43 voted)

Reviews: 82% of readers found this page helpful

Author information

Name: Dan Stracke

Birthday: 1992-08-25

Address: 2253 Brown Springs, East Alla, OH 38634-0309

Phone: +398735162064

Job: Investor Government Associate

Hobby: Shopping, LARPing, Scrapbooking, Surfing, Slacklining, Dance, Glassblowing

Introduction: My name is Dan Stracke, I am a homely, gleaming, glamorous, inquisitive, homely, gorgeous, light person who loves writing and wants to share my knowledge and understanding with you.