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:
COUNTnumber of the occurrences of the time ID value
PERCENTpercentage 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:
TIMEIDtime ID variable
STARTsmallest time ID interval
ENDlargest time ID interval
STARTSHAREDlargest starting time ID interval
ENDSHAREDsmallest ending time ID interval
NOBSnumber of observations
Nnumber of nonmissing observations
NMISSnumber of missing observations
NBYnumber of BY groups
NINVALIDnumber of invalid observations
STATUSstatus flag that indicates whether the requested analyses were successful:
The analysis completed successfully.
interval consistent but data contain gaps
interval not consistent with data
missing or invalid values found
ID values not sorted
duplicate ID values detected
fewer than three values found
Inference of a time interval from the data set failed.
Diagnosis of the DATA= data set for the specified time interval failed.
MSGa message that provides further details when the STATUS variable is not zero
INTERVALtime interval that is specified or recommended
INTNAMEtime interval base name that is specified or recommended
MULTIPLIERtime interval multiplier that is specified or recommended
SHIFT_INDEXtime interval shift index that is specified or recommended
ALIGNMENTtime interval alignment that is specified or recommended
SEASONALITYseasonality determined from specified or recommended time interval
TOTALSEASONCYCLEStotal number of seasonal cycles spanned by all the observations
SEASONCYCLESSHAREDnumber of seasonal cycles that are shared among all BY groups
FORMATformat 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:
TIMEIDtime ID variable name
STARTstarting time ID interval
ENDending time ID interval
NOBSnumber of observations
Nnumber of nonmissing observations
NMISSnumber of missing observations
NINVALIDnumber of invalid observations
NINTCNTSnumber of unique interval count values
PCTINTCNTSpercentage of interval counts greater than one
MININTCNTminimum of interval counts
MAXINTCNTmaximum of interval counts
MEANINTCNTmean of interval counts
STDINTCNTstandard deviation of interval counts
MEDINTCNTmedian of interval counts
NOFFSETSnumber of time ID offset
PCTOFFSETSpercentage of time ID offset
MINOFFSETminimum of time ID offsets
MAXOFFSETmaximum of time ID offsets
MEANOFFSETmean of time ID offsets
STDOFFSETstandard deviation of time ID offsets
MEDOFFSETmedian of time ID offsets
NSPANSnumber of spans between time ID values
PCTSPANSpercentage of spans between time ID values
MINSPANmaximum of spans between time ID values
MAXSPANminimum of spans between time ID values
MEANSPANmean of spans between time ID values
STDSPANstandard deviation of spans between time ID values
MEDSPANmedian of spans between time ID values
STATUSstatus flag that indicates whether the requested analyses were successful:
The analysis completed successfully.
interval consistent but data contain gaps
interval not consistent with data
missing or invalid values found
ID values not sorted
duplicate ID values detected
fewer than three values found
Inference of a time interval from the data set failed.
Diagnosis of the DATA= data set for specified time interval failed.
MSGa message that provides further details when the STATUS variable is not zero
INTERVALtime interval specified or recommended
INTNAMEtime interval base name specified or recommended
MULTIPLIERtime interval multiplier specified or recommended
SHIFT_INDEXtime interval shift index specified or recommended
ALIGNMENTtime interval alignment specified or recommended
SEASONALITYseasonality determined from specified or recommended time interval
NSEASONCYCLESnumber of seasonal cycles spanned by the time ID values
FORMATformat 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.