Assigning Data to Roles

To run the Time Series Data Preparation task, you must select an input data source. To filter the input data source, click Filter Icon.
You must assign a column to the Time series variable role.
Roles and Options
Description
Roles
Time series variable
lists the variables that contain timestamped data
Treatment of missing values
specifies how to treat missing values in the timestamped data. You can choose from these options:
  • Missing value
  • Average value of the accumulated time series
  • Minimum value of the accumulated time series
  • Median value of the accumulated time series
  • Maximum value of the accumulated time series
  • First nonmissing value of the accumulated time series
  • Last nonmissing value of the accumulated time series
  • The previous period’s accumulated nonmissing value - The missing values are set to the previous accumulated nonmissing value. Missing values at the beginning of the accumulated series remain missing.
  • The next period’s accumulated nonmissing value - The missing values are set to the next accumulated nonmissing value. Missing values at the end of the accumulated series remain missing.
  • Numeric value specifies the value to use for the missing value.
Additional Roles
Time ID
specifies the column that contains the time ID values.
Properties
Interval
specifies the interval for the time ID variable. For more information about time intervals, see Understanding SAS Time Intervals.
Multiplier
specifies the multiplier for the time interval. By default, the multiplier is 1. This value cannot be negative.
Shift
specifies the shift for the time interval. By default, the shift is 1. This value cannot be negative.
Season length
specifies the seasonality of the time interval. The default value depends on the time interval.
Additional Roles
Season length
enables you to specify the seasonality of the data when you do not assign a time ID variable.
Group analysis by
enables you to obtain separate analyses of observations for each unique group.