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.