The TIMEID Procedure
| Data Set Output |
The TIMEID procedure creates the OUTFREQ=, OUTINTERVAL=, and OUTINTERVALDETAILS= data sets. The OUTFREQ= and OUTINTERVALDETAILS= data sets contain the variables that are specified in the BY statement along with variables that characterize the time ID values. The OUTINTERVAL= option creates a data set without BY variables. The information in this data set summarizes time ID diagnostic information across all BY groups in the DATA= data set.
OUTFREQ= Data Set
The OUTFREQ= data set contains a single observation for each value of the time ID variable in the input data set for each BY group. Additionally, the following variables are written to the OUTFREQ= data set:
- _COUNT_
number of the occurrences of the time ID value
- _PERCENT_
percentage of all time ID values
OUTINTERVAL= Data Set
The OUTINTERVAL= data set contains information that is similar to the variables written to the OUTINTERVALDETAILS= data set; however, the OUTINTERVAL= data set summarizes the information across all BY groups into a single observation. The following variables are written to the OUTINTERVAL= data set:
- TIMEID
time ID variable
- START
smallest time ID interval
- END
largest time ID interval
- STARTSHARED
largest starting time ID interval
- ENDSHARED
smallest ending time ID interval
- NOBS
number of observations
- N
number of nonmissing observations
- NMISS
number of missing observations
- NBY
number of BY groups
- NINVALID
number of invalid observations
- STATUS
-
status flag that indicates whether the requested analyses were successful:
- 0
The analysis completed successfully.
- 1
interval consistent but data contains gaps
- 2
interval not consistent with data
- 10
missing or invalid values found
- 20
ID values not sorted
- 21
duplicate ID values detected
- 30
fewer than 3 values found
- 4000
Inference of a time interval from the data set failed.
- 5000
Diagnosis of the DATA= data set for the specified time interval failed.
- MSG
a message that provides further details when the STATUS variable is not zero
- INTERVAL
time interval that is specified or recommended
- INTNAME
time interval base name that is specified or recommended
- MULTIPLIER
time interval multiplier that is specified or recommended
- SHIFT_INDEX
time interval shift index that is specified or recommended
- ALIGNMENT
time interval alignment that is specified or recommended
- SEASONALITY
seasonality determined from specified or recommended time interval
- TOTALSEASONCYCLES
total number of seasonal cycles spanned by all the observations
- SEASONCYCLESSHARED
number of seasonal cycles that are shared among all BY groups
- FORMAT
format of the time ID variable
The START, END, STARTSHARED, and ENDSHARED variables are reported using the interval and alignment specified in the ID statement or inferred from the time ID values.
OUTINTERVALDETAILS= Data Set
The OUTINTERVALDETAILS= data set contains statistics about the time interval that is specified in the ID statement or inferred from the time ID values for each BY group. The following variables represent these statistics:
- TIMEID
time ID variable name
- START
starting time ID interval
- END
ending time ID interval
- NOBS
number of observations
- N
number of nonmissing observations
- NMISS
number of missing observations
- NINVALID
number of invalid observations
- NINTCNTS
number of unique interval count values
- PCTINTCNTS
percentage of interval counts greater than one
- MININTCNT
minimum of interval counts
- MAXINTCNT
maximum of interval counts
- MEANINTCNT
mean of interval counts
- STDINTCNT
standard deviation of interval counts
- MEDINTCNT
median of interval counts
- NOFFSETS
number of time ID offset
- PCTOFFSETS
percentage of time ID offset
- MINOFFSET
minimum of time ID offsets
- MAXOFFSET
maximum of time ID offsets
- MEANOFFSET
mean of time ID offsets
- STDOFFSET
standard deviation of time ID offsets
- MEDOFFSET
median of time ID offsets
- NSPANS
number of spans between time ID values
- PCTSPANS
percentage of spans between time ID values
- MINSPAN
maximum of spans between time ID values
- MAXSPAN
minimum of spans between time ID values
- MEANSPAN
mean of spans between time ID values
- STDSPAN
standard deviation of spans between time ID values
- MEDSPAN
median of spans between time ID values
- STATUS
-
status flag that indicates whether the requested analyses were successful:
- 0
The analysis completed successfully.
- 1
interval consistent but data contains gaps
- 2
interval not consistent with data
- 10
missing or invalid values found
- 20
ID values not sorted
- 21
duplicate ID values detected
- 30
fewer than 3 values found
- 4000
Inference of a time interval from the data set failed .
- 5000
Diagnosis of the DATA= data set for specified time interval failed.
- MSG
a message that provides further details when the STATUS variable is not zero
- INTERVAL
time interval specified or recommended
- INTNAME
time interval base name specified or recommended
- MULTIPLIER
time interval multiplier specified or recommended
- SHIFT_INDEX
time interval shift index specified or recommended
- ALIGNMENT
time interval alignment specified or recommended
- SEASONALITY
seasonality determined from specified or recommended time interval
- NSEASONCYCLES
number of seasonal cycles spanned by the time ID values
- FORMAT
format of the time ID variable
The START and END variables are reported using the interval and alignment specified in the ID statement or inferred from the time ID values.