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.