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.
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:
number of the occurrences of the time ID value
percentage of all time ID values
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:
time ID variable
smallest time ID interval
largest time ID interval
largest starting time ID interval
smallest ending time ID interval
number of observations
number of nonmissing observations
number of missing observations
number of BY groups
number of invalid observations
status flag that indicates whether the requested analyses were successful:
The analysis completed successfully.
interval consistent but data contains gaps
interval not consistent with data
missing or invalid values found
ID values not sorted
duplicate ID values detected
fewer than 3 values found
Inference of a time interval from the data set failed.
Diagnosis of the DATA= data set for the specified time interval failed.
a message that provides further details when the STATUS variable is not zero
time interval that is specified or recommended
time interval base name that is specified or recommended
time interval multiplier that is specified or recommended
time interval shift index that is specified or recommended
time interval alignment that is specified or recommended
seasonality determined from specified or recommended time interval
total number of seasonal cycles spanned by all the observations
number of seasonal cycles that are shared among all BY groups
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.
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:
time ID variable name
starting time ID interval
ending time ID interval
number of observations
number of nonmissing observations
number of missing observations
number of invalid observations
number of unique interval count values
percentage of interval counts greater than one
minimum of interval counts
maximum of interval counts
mean of interval counts
standard deviation of interval counts
median of interval counts
number of time ID offset
percentage of time ID offset
minimum of time ID offsets
maximum of time ID offsets
mean of time ID offsets
standard deviation of time ID offsets
median of time ID offsets
number of spans between time ID values
percentage of spans between time ID values
maximum of spans between time ID values
minimum of spans between time ID values
mean of spans between time ID values
standard deviation of spans between time ID values
median of spans between time ID values
status flag that indicates whether the requested analyses were successful:
The analysis completed successfully.
interval consistent but data contains gaps
interval not consistent with data
missing or invalid values found
ID values not sorted
duplicate ID values detected
fewer than 3 values found
Inference of a time interval from the data set failed .
Diagnosis of the DATA= data set for specified time interval failed.
a message that provides further details when the STATUS variable is not zero
time interval specified or recommended
time interval base name specified or recommended
time interval multiplier specified or recommended
time interval shift index specified or recommended
time interval alignment specified or recommended
seasonality determined from specified or recommended time interval
number of seasonal cycles spanned by the time ID values
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.