Usage Note 54882: The SAS® Forecast Studio New Project Creation wizard gives an "Unable to detect time interval ..." warning
When you select the Time ID variable in the SAS Forecast Studio New Project Creation wizard, you might receive a warning that is similar to the following:
Unable to detect time interval. WARNING:...
If this message is displayed, then pre-process your data before trying to create a project. Often, performing the following pre-processing resolves the type of issue you are having:
- Make sure that the data is equally spaced (have a row in the data set for each time value even if data for that time value is missing).
- Remove any duplicates before bringing the data set into SAS Forecast Studio.
See SAS Note 56928: "Data pre-processing requirements for SAS® Forecast Studio" for more information about cleaning your data.
The following excerpt is from "Understanding Time Series" in the "Preparing an Input Data Set" Chapter within SAS Forecast Studio User's Guide.
Your time series data must meet the following requirements:
- The data set contains one variable for each dependent variable.
- The data set contains a time ID variable that identifies the time period for each observation. When SAS Forecast Studio creates a project, the data is sorted by the time ID variable so that the observations are in order according to time.
- The data is equally spaced. Equally spaced means that successive observations are a fixed time interval apart, and the data can be described by a single interval, such as hourly, daily, or monthly.
Here are 2 examples of code that you can use as guidance. You can use this type of code to remove duplicates.
proc timeseries data=sashelp.pricedata out=dataout;
id date interval=month accumulate=mean;
by regionname productline productname;
var sale price;
run;
proc timeseries data=sashelp.pricedata out=dataout;
id date interval=year accumulate=total;
by regionname productline productname;
var sale price;
run;
More information about PROC TIMESERIES is available in this document:
SAS/ETS User's Guide
Expand the Procedure Reference on the left side. Click The TIMESERIES Procedure.
If performing the above pre-processing does not fix the issue, then see this note:
SAS Note 51396: "The warning 'Unable to detect time interval...' occurs in the SAS
® Forecast Studio 12.1 New Project Creation wizard"
Operating System and Release Information
SAS System | SAS Forecast Studio | Microsoft® Windows® for x64 | | |
Microsoft Windows 8 Enterprise 32-bit | | |
Microsoft Windows 8 Enterprise x64 | | |
Microsoft Windows 8 Pro 32-bit | | |
Microsoft Windows 8 Pro x64 | | |
Microsoft Windows 8.1 Enterprise 32-bit | | |
Microsoft Windows 8.1 Enterprise x64 | | |
Microsoft Windows 8.1 Pro | | |
Microsoft Windows 8.1 Pro 32-bit | | |
Microsoft Windows 95/98 | | |
Microsoft Windows 2000 Advanced Server | | |
Microsoft Windows 2000 Datacenter Server | | |
Microsoft Windows 2000 Server | | |
Microsoft Windows 2000 Professional | | |
Microsoft Windows NT Workstation | | |
Microsoft Windows Server 2003 Datacenter Edition | | |
Microsoft Windows Server 2003 Enterprise Edition | | |
Microsoft Windows Server 2003 Standard Edition | | |
Microsoft Windows Server 2003 for x64 | | |
Microsoft Windows Server 2008 | | |
Microsoft Windows Server 2008 R2 | | |
Microsoft Windows Server 2008 for x64 | | |
Microsoft Windows Server 2012 Datacenter | | |
Microsoft Windows Server 2012 R2 Datacenter | | |
Microsoft Windows Server 2012 R2 Std | | |
Microsoft Windows Server 2012 Std | | |
Microsoft Windows XP Professional | | |
Windows 7 Enterprise 32 bit | | |
Windows 7 Enterprise x64 | | |
Windows 7 Home Premium 32 bit | | |
Windows 7 Home Premium x64 | | |
Windows 7 Professional 32 bit | | |
Windows 7 Professional x64 | | |
Windows 7 Ultimate 32 bit | | |
Windows 7 Ultimate x64 | | |
Windows Millennium Edition (Me) | | |
Windows Vista | | |
Windows Vista for x64 | | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Type: | Usage Note |
Priority: | medium |
Date Modified: | 2015-11-30 13:10:37 |
Date Created: | 2014-12-17 11:39:54 |