Problem Note 52870: An error is returned by the TIMESERIES procedure when you use custom intervals
 |  |  |  |  |
PROC TIMESERIES ends abnormally when the following conditions are all met:
- The DATA= input data set includes multiple observations with the same value of the Time ID variable
- The DATA= input data set is not sorted by the Time ID variable.
- The INTERVAL= option in the ID statement specifies a user-defined custom interval
When this happens, the following error is issued to the log:
ERROR: Time indices computed for the time ID variable date from data set data set name
using the interval custom interval name are not in ascending order. Analysis cannot
continue. You should either examine and correct the interval specification or
correct the data to eliminate this problem.
This error occurs even if the NOTSORTED option is specified in the ID statement. If a predefined SAS language interval such as MONTH or QTR is specified in the INTERVAL= option, then PROC TIMESERIES runs without error. There is no circumvention for this problem.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS/ETS | HP-UX IPF | 12.3 | 13.2 | 9.4 TS1M0 | 9.4 TS1M2 |
| 64-bit Enabled Solaris | 12.3 | 13.2 | 9.4 TS1M0 | 9.4 TS1M2 | ||
| 64-bit Enabled AIX | 12.3 | 13.2 | 9.4 TS1M0 | 9.4 TS1M2 | ||
| Windows 7 Professional x64 | 12.3 | 13.2 | 9.4 TS1M0 | 9.4 TS1M2 | ||
| Windows 7 Enterprise x64 | 12.3 | 13.2 | 9.4 TS1M0 | 9.4 TS1M2 | ||
| Microsoft Windows Server 2012 Std | 12.3 | 13.2 | 9.4 TS1M0 | 9.4 TS1M2 | ||
| Microsoft Windows Server 2012 R2 Std | 12.3 | 13.2 | 9.4 TS1M0 | 9.4 TS1M2 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 12.3 | 13.2 | 9.4 TS1M0 | 9.4 TS1M2 | ||
| Microsoft Windows Server 2012 Datacenter | 12.3 | 13.2 | 9.4 TS1M0 | 9.4 TS1M2 | ||
| Microsoft Windows Server 2008 for x64 | 12.3 | 13.2 | 9.4 TS1M0 | 9.4 TS1M2 | ||
| Microsoft Windows Server 2008 R2 | 12.3 | 13.2 | 9.4 TS1M0 | 9.4 TS1M2 | ||
| Microsoft Windows 8.1 Pro 32-bit | 12.3 | 13.2 | 9.4 TS1M0 | 9.4 TS1M2 | ||
| Microsoft Windows 8.1 Pro | 12.3 | 13.2 | 9.4 TS1M0 | 9.4 TS1M2 | ||
| Microsoft Windows 8.1 Enterprise x64 | 12.3 | 13.2 | 9.4 TS1M0 | 9.4 TS1M2 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 12.3 | 13.2 | 9.4 TS1M0 | 9.4 TS1M2 | ||
| Microsoft Windows 8 Pro x64 | 12.3 | 13.2 | 9.4 TS1M0 | 9.4 TS1M2 | ||
| Microsoft Windows 8 Enterprise x64 | 12.3 | 13.2 | 9.4 TS1M0 | 9.4 TS1M2 | ||
| Microsoft® Windows® for x64 | 12.3 | 13.2 | 9.4 TS1M0 | 9.4 TS1M2 | ||
| z/OS | 12.3 | 13.2 | 9.4 TS1M0 | 9.4 TS1M2 | ||
| Linux for x64 | 12.3 | 13.2 | 9.4 TS1M0 | 9.4 TS1M2 | ||
| Solaris for x64 | 12.3 | 13.2 | 9.4 TS1M0 | 9.4 TS1M2 | ||
A fix for this issue for SAS/ETS 12.3 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/M65.html#52870A fix for this issue for SAS/ETS 13.1_M1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/N99.html#52870| Type: | Problem Note |
| Priority: | high |
| Topic: | Analytics ==> Econometrics Analytics ==> Forecasting Analytics ==> Time Series Analysis Data Management ==> Manipulation and Transformation ==> Combining and Modifying Data Sets Data Management ==> Manipulation and Transformation ==> Date and Time SAS Reference ==> Procedures ==> TIMESERIES |
| Date Modified: | 2014-05-06 10:48:12 |
| Date Created: | 2014-05-01 11:16:07 |