2215 questions found.

Page 28 / 45

The available options for 'aggregator' are: 'MAX' (maximum value), 'MEAN' (arithmetic mean), 'MIN' (minimum value), 'N' (number of observations), and 'SUM' (sum of nonmissing values). The default is 'SUM'....
Read full answer See technical action

The 'attributes' parameter specifies variable attributes. It takes a list of objects, each defining attributes like 'format', 'formattedLength', 'label', 'name' (required), 'nfd', and 'nfl' for a variable....
Read full answer See technical action

The 'casOut' parameter specifies the settings for an output table, including 'caslib', 'compress', 'indexVars', 'label', 'lifetime', 'maxMemSize', 'memoryFormat', 'name', 'promote', 'replace', 'replication', 'tableRedistUpPolicy', 'threadBlockSize', 'timeStamp', and 'where'....
Read full answer See technical action

When 'descending' is set to True, the levels of the group-by variables are arranged in descending order. The default is False....
Read full answer See technical action

The 'freq' parameter specifies a numeric frequency variable used to compute the ranking of a distinct grouping....
Read full answer See technical action

When 'includeMissing' is set to True, missing values are included when determining distinct values in group-by analysis. The default is True....
Read full answer See technical action

The 'inputs' parameter specifies the input variables for the analysis. It takes a list of objects, each defining attributes like 'format', 'formattedLength', 'label', 'name' (required), 'nfd', and 'nfl' for an input variable....
Read full answer See technical action

The 'partition' parameter, when set to True, assumes that the table is already partitioned. The default is False....
Read full answer See technical action

When 'repeatedTable' is set to True, it generates a repeated group-by table with the same rows on all worker nodes. The default is False....
Read full answer See technical action

You can limit the number of distinct groupings by using the 'resultLimit' parameter, which specifies the maximum number of distinct groupings to return. It accepts an integer value....
Read full answer See technical action

The 'scoreGt' parameter specifies an exclusive lower bound for the numeric rank order scores of distinct groupings to return. The 'scoreLt' parameter specifies an exclusive upper bound for these scores....
Read full answer See technical action

The 'table' parameter (required) specifies the input table, including its name, caslib, and other common parameters like 'computedOnDemand', 'computedVars', 'computedVarsProgram', 'dataSourceOptions', 'importOptions', 'singlePass', 'vars', 'where', and 'whereTable'....
Read full answer See technical action

The 'weight' parameter specifies a numeric weight variable used to compute the rank order score of a distinct grouping....
Read full answer See technical action

The "groupBy" action builds BY groups in terms of the variable value combinations given the variables in the variable list. It is part of the Simple Analytics Action Set....
Read full answer See technical action

The common parameters for the "groupBy" action include 'aggregator', 'attributes', 'casOut', 'descending', 'freq', 'includeMissing', 'inputs', 'partition', 'repeatedTable', 'resultLimit', 'scoreGt', 'scoreLt', 'table', and 'weight'....
Read full answer See technical action

The 'aggregator' parameter specifies the aggregator for which the values of the weight variable are rolled up into a rank order score if a weight variable is specified. Aliases: agg. Default: SUM. Options include "MAX", "MEAN", "MIN", "N", and "SUM"....
Read full answer See technical action

When 'aggregator' is set to "MAX", it specifies the maximum value....
Read full answer See technical action

When 'aggregator' is set to "MEAN", it specifies the arithmetic mean....
Read full answer See technical action

When 'aggregator' is set to "MIN", it specifies the minimum value....
Read full answer See technical action

When 'aggregator' is set to "N", it specifies the number of observations....
Read full answer See technical action

When 'aggregator' is set to "SUM", it specifies the sum of nonmissing values....
Read full answer See technical action

The 'attributes' parameter specifies the variable attributes. For more information about specifying the attributes parameter, see the common casinvardesc parameter. Aliases: attribute, attrs, attr, varAttrs....
Read full answer See technical action

The 'casOut' parameter specifies the settings for an output table. For more information about specifying the casOut parameter, see the common casouttable parameter....
Read full answer See technical action

The 'descending' parameter, when set to True, arranges the levels of the group-by variables in descending order. Default: FALSE....
Read full answer See technical action

The 'freq' parameter specifies the numeric frequency variable used to compute the ranking of a distinct grouping. Alias: frequency....
Read full answer See technical action

The 'includeMissing' parameter, when set to True, includes missing values in the determination of distinct values in group-by analysis. Default: TRUE....
Read full answer See technical action

The 'inputs' parameter specifies the input variables for the analysis. For more information about specifying the inputs parameter, see the common casinvardesc parameter. Alias: input....
Read full answer See technical action

The 'partition' parameter, when set to True, assumes the table is partitioned. Default: FALSE....
Read full answer See technical action

The 'repeatedTable' parameter, when set to True, generates a repeated group-by table with the same rows on all worker nodes. Default: FALSE....
Read full answer See technical action

The 'resultLimit' parameter specifies the maximum number of distinct groupings to return. Alias: limit. Range: 0–MACINT....
Read full answer See technical action

The 'scoreGt' parameter specifies the exclusive lower bound of the numeric rank order scores of the distinct groupings to return....
Read full answer See technical action

The 'scoreLt' parameter specifies the exclusive upper bound of the numeric rank order scores of the distinct groupings to return....
Read full answer See technical action

The 'table' parameter specifies the table name, caslib, and other common parameters. Long form: table={name="table-name"}. Shortcut form: table="table-name". The castable value can be one or more of the following: 'caslib', 'computedOnDemand', 'computedVars', 'computedVarsProgram', 'dataSourceOption...
Read full answer See technical action

The 'table.caslib' subparameter specifies the caslib for the input table that you want to use with the action. By default, the active caslib is used. Specify a value only if you need to access a table from a different caslib....
Read full answer See technical action

The 'table.computedOnDemand' subparameter, when set to True, creates the computed variables when the table is loaded instead of when the action begins. Alias: compOnDemand. Default: FALSE....
Read full answer See technical action

The 'table.computedVars' subparameter specifies the names of the computed variables to create. Specify an expression for each variable in the 'computedVarsProgram' parameter. If you do not specify this parameter, then all variables from 'computedVarsProgram' are automatically included. Alias: compVa...
Read full answer See technical action

The 'table.computedVars.format' subparameter specifies the format to apply to the variable....
Read full answer See technical action

The 'table.computedVars.formattedLength' subparameter specifies the length of the format field plus the length of the format precision....
Read full answer See technical action

The 'table.computedVars.label' subparameter specifies the descriptive label for the variable....
Read full answer See technical action

The 'table.computedVars.name' subparameter specifies the name for the variable....
Read full answer See technical action

The 'table.computedVars.nfd' subparameter specifies the length of the format precision....
Read full answer See technical action

The 'table.computedVars.nfl' subparameter specifies the length of the format field....
Read full answer See technical action

The 'table.computedVarsProgram' subparameter specifies an expression for each computed variable that you include in the computedVars parameter. Alias: compPgm....
Read full answer See technical action

The 'table.dataSourceOptions' subparameter specifies data source options. Aliases: options, dataSource....
Read full answer See technical action

The 'table.importOptions' subparameter specifies the settings for reading a table from a data source. Alias: import. For more information about specifying the importOptions parameter, see the common importOptions parameter....
Read full answer See technical action

The 'table.name' subparameter specifies the name of the input table....
Read full answer See technical action

The 'table.singlePass' subparameter, when set to True, does not create a transient table on the server. Setting this parameter to True can be efficient, but the data might not have stable ordering upon repeated runs. Default: FALSE....
Read full answer See technical action

The 'table.vars' subparameter specifies the variables to use in the action. The casinvardesc value can be one or more of the following: 'format', 'formattedLength', 'label', 'name', 'nfd', 'nfl'....
Read full answer See technical action

The 'table.vars.format' subparameter specifies the format to apply to the variable....
Read full answer See technical action

The 'table.vars.formattedLength' subparameter specifies the length of the format field plus the length of the format precision....
Read full answer See technical action
Copyright © WeAreCAS 2014-2026
SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. WeAreCAS is an independent community site and is not affiliated with SAS Institute Inc.