TIMEFIELDS subcommand (SPATIAL TEMPORAL PREDICTION command)

The TIMEFIELDS subcommand defines the time intervals for TIMEINDEX fields specified on the DATASET subcommand.

  • The procedure assumes that all cases (records) represent equally spaced intervals.
  • Based on the selected time interval, the procedure can detect missing observations or multiple observations in the same time interval that need to be aggregated together. For example, if the time interval is days and the date 2014-10-27 is followed by 2014-10-29, then there is a missing observation for 2014-10-28. If the time interval is month, then multiple dates in the same month are aggregated together.
  • For some time intervals, the additional setting can define breaks in the normal equally spaced intervals. For example, if the time interval is days, but only week days are valid, you can specify that there are five days in a week, and the week begins on Monday.
INPUTINTERVAL=keyword
The basic time interval. The value can be: YEAR, QUARTER, MONTH, WEEK, DAY, HOUR, MINUTE, SECOND, DURATION, or PERIOD.
  • DURATION applies to time values (hours, minutes, seconds) that represent length of time from a starting time, rather than clock time.
  • Time fields must be date format or time format fields unless the input interval is PERIOD.
INTERVAL=HOUR | MINUTE | SECOND
For DURATION, this setting specifies what the duration interval represents. This setting is valid only for DURATION.
INCREMENT=integer
The increment for the input interval. For example, if the input interval is years and the increment is 2, the time interval between observations is two years. The value must be a positive integer. The default value is 1. This setting is valid for YEAR, MONTH, DAY, HOUR, MINUTE, SECOND, DURATION, and PERIOD.
DAYSWK=integer
Number of days in a week. The value must be a positive integer. The default setting is 7. This setting is valid for DAY, HOUR, MINUTE, and SECOND.
WKSTART=MON | TUE | WED | THU | FRI | SAT | SUN
The starting day of the week value. The default value is MON. This setting is valid for DAY, HOUR, MINUTE, and SECOND.
HRSDAY=integer
Number of hours in a day. The value must be a positive integer. The default value is 24. This setting is valid for HOUR, MINUTE, and SECOND.
DAYSTART=hh:mm
Starting time for the day. The value must be a time value in format hh:mm. The default value is 00:00. This setting is valid for HOUR, MINUTE, and SECOND.
START=value list
List of starting values for cyclic periods. The value must be a positive integer. This setting is valid only with PERIOD.
LENGTH=value list
List of cycle lengths of cyclic periods. The value must be a positive integer. This setting is valid only with PERIOD.

INPUTINTERVAL=PERIOD

  • If there is only one time field, START and LENGTH are not valid. For a single time field, the input interval PERIOD defines the time interval for a non-cyclic time field that is not a date format or time format field.
  • If there are multiple time fields, the fields represent cyclic periods, such as years, quarters within years, and months within quarters.
  • If there are multiple time fields, START and LENGTH are required. If there are n time fields, the number of START and LENGTH values must be n-1, where the values correspond to the last n-1 fields specified for TIMEINDEX.
  • INCREMENT represents the input interval at the lowest cycle level, which is the last field specified for TIMEINDEX.

For example, if TIMEFIELDS=year quarter month, the INPUTINTERVAL specification could be:

INPUTINTERVAL=PERIOD START=1 1 LENGTH=4 3
  • The START and LENGTH values apply to quarter and month.
  • LENGTH specifies that there are four quarters in each year and 3 months in each quarter.