specifies the alignment of the representative value with respect to an interval or bin.

specifies the minimum and maximum values of a bin. For example, if the values of the ID variable range from 0 to 100 and you specify bin={5, 15}, then the action constructs a time series with 11 bins. The first bin is [-5, 5] and the last bin is [95, 105]. The values on the upper boundary of a bin belong to this bin. The values on the lower boundary of a bin belong to the adjacent lower bin. This parameter is ignored unless you also specify an ID variable.

specifies the settings for an output table.

For more information about specifying the casOut parameter, see the common casouttable parameter.

when the doESP parameter is True, you can specify a variable whose values within each aggregation interval are recorded. The value can be used as a key to join with the original table in order to understand each row contribution toward the aggregated interval.

specifies a value to override the variable label from the contribute variable. By default, the contribute variable's label is shown in the results.

specifies a value to override the variable name from the contribute variable. By default, the contribute variable's name is shown in the results.

specifies a delimiter that is used between concatenated values of the contribute variable.

when set to True, leading and trailing blanks are removed from the formatted value of the contribute variable. This parameter is ignored if the contributeUnroll parameter is set to True.

by default, the formatted values from the contribute variable are concatenated together into a single row for the result table. When set to True, each raw value from the contribute variable adds a row to the result table.

specifies the variables to copy from the input table to the output table. The raw values are kept in the output. This parameter is ignored unless you also specify the groupBy parameter for the input table. When more than one record exists in a group, the minimum raw value is copied.

when set to True, the action can take advantage of partitioning and ordering on the input table. You must specify the groupBy parameter for the input table. The ID variable must be specified as the last groupBy parameter and in the orderBy parameter. Setting this parameter to True implies setting the keepRecord parameter to True. When set to False (the default value), the keepRecordId, excludeSelf, contribute, contributeColumnName, contributeTrim, contributeDelimiter, and contributeUnroll parameters are ignored.

specifies a numeric variable whose values are used to order the values of each varSpecs specification that uses the FIRST, LAST, FNE, or LNE aggregator. This parameter can be overridden in a varSpecs specification that includes an edgeId subparameter.

when set to True and a weight variable is specified, then observations with a non-positive weight value are excluded from the analysis.

when set to True and the doESP parameter is True, the aggregation excludes the current observation's contribution.

specifies a numeric variable whose values are used as the frequency of analysis variable values. This parameter has an effect when the aggregator is SUMMARY, Q1, Q2, Q3, PERCENTILE, PLT, PIN, PGT, or MODE. With the exception of MODE, records with frequency values that are missing or less than 1 are excluded from the analysis. Only the integer portion of the frequency value is used.

this parameter is related to using the MODE aggregator. By default, observations with frequency values that are missing or less than 1 are excluded and only the integer portion of decimal values is used. When set to False, negative and the decimal values are used. Missing values are still excluded.

specifies the maximum number of levels in a group-by set. When the server determines this number of levels, the server stops and does not return a result. Specify this parameter if you want to avoid creating large result sets in group-by operations.

when set to True, save only one of the same aggregated intervals with respect to the last Id value. The option is ignored if 'doESP' is set to False.

specifies a numeric variable that identifies the timestamp that is associated with each observation in the input table. The values are typically SAS DATE, TIME, or DATETIME values, but that is not required. The specified variable must also be specified in the groupBy parameter for the input table.

specifies the inclusive maximum value of the ID variable to be considered in the analysis. If the maximum value of the ID variable is less than the idEnd value, the series is extended with missing values. If the last ID variable value is greater than the idEnd value, the series is truncated. This parameter is ignored unless you also specify an ID variable.

specifies the new name of the ID variable in the output table

specifies the inclusive minimum and maximum values of the ID variable to be considered in the analysis. It is equivalent to specifying both idStart and idEnd.

specifies the inclusive minimum value of the ID variable to be considered in the analysis. If the minimum value of the ID variable is greater than the idStart value, then the series is prefixed with missing values. If the first ID variable value is less than the idStart value, then the series is truncated. This parameter is ignored unless you also specify an ID variable.

by default, intervals with a missing value for the ID variable are included in the output. When set to False, these intervals are excluded from the output.

by default, missing values are included in the analysis. When set to False, observations with missing values are excluded.

specifies the input variables to use in the analysis. For raw numeric variables, the default aggregator is SUMMARY. For all other situations, the default aggregator is N. You can specify variables in this parameter or exercise more control by specifying the varSpecs parameter, but you cannot use both.

For more information about specifying the inputs parameter, see the common casinvardesc parameter.

specifies the time period for the accumulation of observations. For example, if you specify interval='MONTH', then the action summarizes the observations in monthly intervals. This parameter is ignored unless you also specify an ID variable.

when set to True, specifies that aggregation occurs over a time window that can contain multiple intervals and aggregation is reset when the specified time range elapses. By default, a window always retains the same multiple of intervals.

when set to True, each observation's original value for the ID variable is kept without performing interval alignment.

when set to True and the doESP parameter is True, each observation's original ID value is kept without performing interval alignment.

this parameter is related to using the MODE aggregator. By default, the most frequent value is 'missing' if all the distinct values have a frequency of 1. When set to True, the minimum of these distinct values is returned as the most frequent value.

specifies the offset of each interval. If you specify offset=-1, then every interval that is derived from the data set is shifted one interval backward. For example, a timestamp value for March 1 is derived from the data set to become February 1.

when the table is partitioned and you specify the partition parameter, you can specify a partition key so that the results are computed for the partition only.

specifies how to compute quantile statistics (percentiles) as described in the UNIVARIATE procedure documentation.

specifies the time value when the aggregation within an interval or a bin is terminated. For example, if you specify interval='MONTH' and partialToInterval='10FEB98'd, then the action aggregates only records from the first 10 days of each month.

specifies the subinterval with respect to each window interval. For example, if you specify windowInterval='MONTH' and partialToWindow='08FEB98'd, then the action counts only the first 8 days from JANUARY and the first 8 days from FEBURARY when it aggregates on window interval FEBURARY, ..., DECEMBER each year. This parameter is ignored unless you also specify the jumpingWindow parameter because the starting time varies for a sliding window (a non-jumping window).

when set to True, raw values of the variables in the input parameter are used.

by default, the formatted values of the groupBy variables from the input table are copied to the results. When set to False, the formatted values are not copied.

by default, the raw values of the groupBy variables from the input table are copied to the results. When set to False, the raw values are not copied.

by default, the variable name for each analysis variable is included in the results. The result table includes the name in a column that is named 'Column.' When set to False, this column is not included in the results.

by default, the results include a column that is named 'Variable Specification' to identify the varSpecs specification that produced the result. When set to False, this column is not included in the results.

specifies an offset from the beginning of a bin. The value must be positive and less than or equal to the bin width. If the specified value is out of range, this parameter is ignored. This parameter is ignored unless you specify an ID variable and the bin parameter.

specifies the width of the sub bin within a bin. For example, if the values of the ID variable range from 0 to 100 and you specify bin={5, 15}, subBinOffset=2, and subBinWidth=5, then the action summarizes only the observations with ID variable values that fall into [-2, 3], [8, 13], [18, 23], ..., [98, 103]. The specified value must be positive and the sum of the subBinOffset value and subBinWidth value must be less than or equal to the bin width. If the value is out of range, this parameter is ignored. This parameter is ignored unless you also specify an ID variable and the bin parameter.

specifies a smaller interval to control the time period alignment within each interval for the aggregation of observations.

specifies the variable to aggregate and the settings for the aggregator.

The tkcasagg_varspecs value can be one or more of the following:

specifies a numeric variable whose values are used as the weight of numeric analysis variable values when the aggregator is SUMMARY. This parameter is meaningful with the SUMMARY aggregator only. Observations with missing values are excluded from the analysis. By default, negative values of the weight variable are treated as 0. Use the excludeNonPositiveWeight parameter to change this behavior.

specifies the minimum and maximum values of a window bin. The specification and concepts are similar to the bin parameter, except the bins apply to intervals.

specifies the time window for the accumulation of observations with respect to each time interval. For example, if you specify interval='MONTH' and windowInt='YEAR', then the action summarizes one year's worth of observations in monthly intervals.

specifies the offset of each window interval. The effect is similar to how the offset parameter impacts the values for the interval parameter.

specifies the starting point within a window bin in which record values are aggregated. For example, if you specify windowBin={0, 10} and windowSubBinOffset=2, then records with ID variable values in the interval [0, 2) are ignored. The specified value must not be larger than the window bin's width.

specifies the width of the sub bin within each windowBin. The minimum acceptable value is 0, which renders windows ineffective. For example, if you specify windowBin={0, 10}, windowSubBinOffset=2, and windowSubBinWidth=5, then records with ID variable values in the intervals [0, 2) and [7, 10) are ignored.

this parameter is similar to subInterval. You can specify a smaller interval to control the sub time period alignment within each window interval for the aggregation of observations.

specifies the alignment of the representative value with respect to an interval or bin.

specifies the minimum and maximum values of a bin. For example, if the values of the ID variable range from 0 to 100 and you specify bin={5, 15}, then the action constructs a time series with 11 bins. The first bin is [-5, 5] and the last bin is [95, 105]. The values on the upper boundary of a bin belong to this bin. The values on the lower boundary of a bin belong to the adjacent lower bin. This parameter is ignored unless you also specify an ID variable.

specifies the settings for an output table.

For more information about specifying the casOut parameter, see the common casouttable parameter.

when the doESP parameter is True, you can specify a variable whose values within each aggregation interval are recorded. The value can be used as a key to join with the original table in order to understand each row contribution toward the aggregated interval.

specifies a value to override the variable label from the contribute variable. By default, the contribute variable's label is shown in the results.

specifies a value to override the variable name from the contribute variable. By default, the contribute variable's name is shown in the results.

specifies a delimiter that is used between concatenated values of the contribute variable.

when set to True, leading and trailing blanks are removed from the formatted value of the contribute variable. This parameter is ignored if the contributeUnroll parameter is set to True.

by default, the formatted values from the contribute variable are concatenated together into a single row for the result table. When set to True, each raw value from the contribute variable adds a row to the result table.

specifies the variables to copy from the input table to the output table. The raw values are kept in the output. This parameter is ignored unless you also specify the groupBy parameter for the input table. When more than one record exists in a group, the minimum raw value is copied.

when set to True, the action can take advantage of partitioning and ordering on the input table. You must specify the groupBy parameter for the input table. The ID variable must be specified as the last groupBy parameter and in the orderBy parameter. Setting this parameter to True implies setting the keepRecord parameter to True. When set to False (the default value), the keepRecordId, excludeSelf, contribute, contributeColumnName, contributeTrim, contributeDelimiter, and contributeUnroll parameters are ignored.

specifies a numeric variable whose values are used to order the values of each varSpecs specification that uses the FIRST, LAST, FNE, or LNE aggregator. This parameter can be overridden in a varSpecs specification that includes an edgeId subparameter.

when set to True and a weight variable is specified, then observations with a non-positive weight value are excluded from the analysis.

when set to True and the doESP parameter is True, the aggregation excludes the current observation's contribution.

specifies a numeric variable whose values are used as the frequency of analysis variable values. This parameter has an effect when the aggregator is SUMMARY, Q1, Q2, Q3, PERCENTILE, PLT, PIN, PGT, or MODE. With the exception of MODE, records with frequency values that are missing or less than 1 are excluded from the analysis. Only the integer portion of the frequency value is used.

this parameter is related to using the MODE aggregator. By default, observations with frequency values that are missing or less than 1 are excluded and only the integer portion of decimal values is used. When set to False, negative and the decimal values are used. Missing values are still excluded.

specifies the maximum number of levels in a group-by set. When the server determines this number of levels, the server stops and does not return a result. Specify this parameter if you want to avoid creating large result sets in group-by operations.

when set to True, save only one of the same aggregated intervals with respect to the last Id value. The option is ignored if 'doESP' is set to False.

specifies a numeric variable that identifies the timestamp that is associated with each observation in the input table. The values are typically SAS DATE, TIME, or DATETIME values, but that is not required. The specified variable must also be specified in the groupBy parameter for the input table.

specifies the inclusive maximum value of the ID variable to be considered in the analysis. If the maximum value of the ID variable is less than the idEnd value, the series is extended with missing values. If the last ID variable value is greater than the idEnd value, the series is truncated. This parameter is ignored unless you also specify an ID variable.

specifies the new name of the ID variable in the output table

specifies the inclusive minimum and maximum values of the ID variable to be considered in the analysis. It is equivalent to specifying both idStart and idEnd.

specifies the inclusive minimum value of the ID variable to be considered in the analysis. If the minimum value of the ID variable is greater than the idStart value, then the series is prefixed with missing values. If the first ID variable value is less than the idStart value, then the series is truncated. This parameter is ignored unless you also specify an ID variable.

by default, intervals with a missing value for the ID variable are included in the output. When set to False, these intervals are excluded from the output.

by default, missing values are included in the analysis. When set to False, observations with missing values are excluded.

specifies the input variables to use in the analysis. For raw numeric variables, the default aggregator is SUMMARY. For all other situations, the default aggregator is N. You can specify variables in this parameter or exercise more control by specifying the varSpecs parameter, but you cannot use both.

For more information about specifying the inputs parameter, see the common casinvardesc parameter.

specifies the time period for the accumulation of observations. For example, if you specify interval='MONTH', then the action summarizes the observations in monthly intervals. This parameter is ignored unless you also specify an ID variable.

when set to True, specifies that aggregation occurs over a time window that can contain multiple intervals and aggregation is reset when the specified time range elapses. By default, a window always retains the same multiple of intervals.

when set to True, each observation's original value for the ID variable is kept without performing interval alignment.

when set to True and the doESP parameter is True, each observation's original ID value is kept without performing interval alignment.

this parameter is related to using the MODE aggregator. By default, the most frequent value is 'missing' if all the distinct values have a frequency of 1. When set to True, the minimum of these distinct values is returned as the most frequent value.

specifies the offset of each interval. If you specify offset=-1, then every interval that is derived from the data set is shifted one interval backward. For example, a timestamp value for March 1 is derived from the data set to become February 1.

when the table is partitioned and you specify the partition parameter, you can specify a partition key so that the results are computed for the partition only.

specifies how to compute quantile statistics (percentiles) as described in the UNIVARIATE procedure documentation.

specifies the time value when the aggregation within an interval or a bin is terminated. For example, if you specify interval='MONTH' and partialToInterval='10FEB98'd, then the action aggregates only records from the first 10 days of each month.

specifies the subinterval with respect to each window interval. For example, if you specify windowInterval='MONTH' and partialToWindow='08FEB98'd, then the action counts only the first 8 days from JANUARY and the first 8 days from FEBURARY when it aggregates on window interval FEBURARY, ..., DECEMBER each year. This parameter is ignored unless you also specify the jumpingWindow parameter because the starting time varies for a sliding window (a non-jumping window).

when set to True, raw values of the variables in the input parameter are used.

by default, the formatted values of the groupBy variables from the input table are copied to the results. When set to False, the formatted values are not copied.

by default, the raw values of the groupBy variables from the input table are copied to the results. When set to False, the raw values are not copied.

by default, the variable name for each analysis variable is included in the results. The result table includes the name in a column that is named 'Column.' When set to False, this column is not included in the results.

by default, the results include a column that is named 'Variable Specification' to identify the varSpecs specification that produced the result. When set to False, this column is not included in the results.

specifies an offset from the beginning of a bin. The value must be positive and less than or equal to the bin width. If the specified value is out of range, this parameter is ignored. This parameter is ignored unless you specify an ID variable and the bin parameter.

specifies the width of the sub bin within a bin. For example, if the values of the ID variable range from 0 to 100 and you specify bin={5, 15}, subBinOffset=2, and subBinWidth=5, then the action summarizes only the observations with ID variable values that fall into [-2, 3], [8, 13], [18, 23], ..., [98, 103]. The specified value must be positive and the sum of the subBinOffset value and subBinWidth value must be less than or equal to the bin width. If the value is out of range, this parameter is ignored. This parameter is ignored unless you also specify an ID variable and the bin parameter.

specifies a smaller interval to control the time period alignment within each interval for the aggregation of observations.

specifies the variable to aggregate and the settings for the aggregator.

The tkcasagg_varspecs value can be one or more of the following:

specifies a numeric variable whose values are used as the weight of numeric analysis variable values when the aggregator is SUMMARY. This parameter is meaningful with the SUMMARY aggregator only. Observations with missing values are excluded from the analysis. By default, negative values of the weight variable are treated as 0. Use the excludeNonPositiveWeight parameter to change this behavior.

specifies the minimum and maximum values of a window bin. The specification and concepts are similar to the bin parameter, except the bins apply to intervals.

specifies the time window for the accumulation of observations with respect to each time interval. For example, if you specify interval='MONTH' and windowInt='YEAR', then the action summarizes one year's worth of observations in monthly intervals.

specifies the offset of each window interval. The effect is similar to how the offset parameter impacts the values for the interval parameter.

specifies the starting point within a window bin in which record values are aggregated. For example, if you specify windowBin={0, 10} and windowSubBinOffset=2, then records with ID variable values in the interval [0, 2) are ignored. The specified value must not be larger than the window bin's width.

specifies the width of the sub bin within each windowBin. The minimum acceptable value is 0, which renders windows ineffective. For example, if you specify windowBin={0, 10}, windowSubBinOffset=2, and windowSubBinWidth=5, then records with ID variable values in the intervals [0, 2) and [7, 10) are ignored.

this parameter is similar to subInterval. You can specify a smaller interval to control the sub time period alignment within each window interval for the aggregation of observations.