DOCUMENTATION
Sign In

Get access to My SAS, trials, communities and more.

SAS Visual Analytics Programming Guide
 
CASL
Lua
Python
R

Simple Analytics Action Set: Syntax

Provides actions for performing basic analytic functions

crossTab Action

Performs one-way or two-way tabulations.

See: Results
Example:Perform a Two-Way Tabulation Using a Weighting Variable

CASL Syntax

Expand allCollapse all
simple.crossTab <result=results> <status=rc> /
acrossBy=TRUE | FALSE,
aggregator="CSS" | "CV" | "KURTOSIS" | "MAX" | "MEAN" | "MIN" | "N" | "NMISS" | "PROBT" | "SKEWNESS" | "STD" | "STDERR" | "SUM" | "TSTAT" | "USS" | "VAR",
association=TRUE | FALSE,
chiSq=TRUE | FALSE,
col="variable-name",
colFormat="string",
colNBins=integer,
descending=TRUE | FALSE,
fullTable=TRUE | FALSE,
groupByLimit=64-bit-integer,
includeMissing=TRUE | FALSE,
niceBinning=TRUE | FALSE,
orderByGbyRaw=TRUE | FALSE,
required parameter row="variable-name",
rowFormat="string",
rowNBins=integer,
required parameter table
={
caslib="string",
computedOnDemand=TRUE | FALSE,
computedVars
={{
format="string",
formattedLength=integer,
label="string",
required parameter name="variable-name",
nfd=integer,
nfl=integer
}, {...}},
computedVarsProgram="string",
dataSourceOptions={key-1=any-list-or-data-type-1 <, key-2=any-list-or-data-type-2, ...>},
groupBy
={{
format="string",
formattedLength=integer,
label="string",
required parameter name="variable-name",
nfd=integer,
nfl=integer
}, {...}},
groupByMode="NOSORT" | "REDISTRIBUTE",
importOptions={fileType="ANY" | "AUDIO" | "AUTO" | "BASESAS" | "CSV" | "DELIMITED" | "DOCUMENT" | "DTA" | "ESP" | "EXCEL" | "FMT" | "HDAT" | "IMAGE" | "JMP" | "LASR" | "PARQUET" | "SOUND" | "SPSS" | "VIDEO" | "XLS", fileType-specific-parameters},
required parameter name="table-name",
orderBy
={{
format="string",
formattedLength=integer,
label="string",
required parameter name="variable-name",
nfd=integer,
nfl=integer
}, {...}},
singlePass=TRUE | FALSE,
vars
={{
format="string",
formattedLength=integer,
label="string",
required parameter name="variable-name",
nfd=integer,
nfl=integer
}, {...}},
where="where-expression",
whereTable
={
casLib="string"
dataSourceOptions={adls_noreq-parameters | bigquery-parameters | cas_noreq-parameters | clouddex-parameters | db2-parameters | dnfs-parameters | esp-parameters | fedsvr-parameters | gcs_noreq-parameters | hadoop-parameters | hana-parameters | impala-parameters | informix-parameters | jdbc-parameters | mongodb-parameters | mysql-parameters | odbc-parameters | oracle-parameters | path-parameters | postgres-parameters | redshift-parameters | s3-parameters | sapiq-parameters | sforce-parameters | singlestore_standard-parameters | snowflake-parameters | spark-parameters | spde-parameters | sqlserver-parameters | ss_noreq-parameters | teradata-parameters | vertica-parameters | yellowbrick-parameters}
importOptions={fileType="ANY" | "AUDIO" | "AUTO" | "BASESAS" | "CSV" | "DELIMITED" | "DOCUMENT" | "DTA" | "ESP" | "EXCEL" | "FMT" | "HDAT" | "IMAGE" | "JMP" | "LASR" | "PARQUET" | "SOUND" | "SPSS" | "VIDEO" | "XLS", fileType-specific-parameters}
required parameter name="table-name"
vars
={{
format="string",
formattedLength=integer,
label="string",
required parameter name="variable-name",
nfd=integer,
nfl=integer
}, {...}}
where="where-expression"
}
},
weight="variable-name"
;
indicates a required parameter

Summary: Input Tables

If a row includes a subparameter, you can specify the name, caslib, and so on in the subparameter. Otherwise, you can specify the name, caslib, and so on in the parameter.

Parameters for Reading Input Tables

Parameter

Subparameter

Description

required parametertable

—

specifies the table name, caslib, and other common parameters.

Parameter Descriptions

acrossBy=TRUE | FALSE

when set to True, the levels of row and column variables are the same across the group-by variables.

DefaultFALSE

aggregator="CSS" | "CV" | "KURTOSIS" | "MAX" | "MEAN" | "MIN" | "N" | "NMISS" | "PROBT" | "SKEWNESS" | "STD" | "STDERR" | "SUM" | "TSTAT" | "USS" | "VAR"

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.

CSS

specifies the corrected sum of squares.

CV

specifies the coefficient of variation.

KURTOSIS

specifies the kurtosis.

MAX

specifies the maximum value.

MEAN

specifies the arithmetic mean.

MIN

specifies the minimum value.

N

specifies the number of observations.

NMISS

specifies the number of missing values.

PROBT

specifies the p-value for the t-statistic.

SKEWNESS

specifies the skewness.

STD

specifies the standard deviation.

STDERR

specifies the standard error.

SUM

specifies the sum of nonmissing values.

TSTAT

specifies the t-statistic for H:mean=0.

AliasT
USS

specifies the uncorrected sum of squares.

VAR

specifies the sample variance.

association=TRUE | FALSE

when set to True, measures of association between the row and column variable of the crosstabulation are computed.

DefaultFALSE

chiSq=TRUE | FALSE

when set to True, chi-square statistics are computed for the test of independence of the row and column variables and their asymptotic p-values.

DefaultFALSE

col="variable-name"

specifies the column variable

colFormat="string"

specifies a format for the column variable.

colNBins=integer

specifies the number of bins to use in binning the column variable.

Range0–MACINT

descending=TRUE | FALSE

when set to True, the formatted levels of the variables are arranged in descending order.

DefaultFALSE

fullTable=TRUE | FALSE

when set to True, a full-table scan is performed.

DefaultFALSE

groupByLimit=64-bit-integer

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.

Minimum value1

includeMissing=TRUE | FALSE

when set to True, missing values are included in the crosstabulation.

DefaultFALSE

niceBinning=TRUE | FALSE

when set to True, the nice binning algorithm is used.

DefaultTRUE

orderByGbyRaw=TRUE | FALSE

when set to True, the ordering of the group-by variables is based on the raw values of the variables, not the formatted values.

AliasorderByRaw
DefaultFALSE

* row="variable-name"

specifies the row variable.

rowFormat="string"

specifies a format for the row variable.

rowNBins=integer

specifies the number of bins to use in binning the row variable.

Range0–MACINT

* table={castable}

specifies the table name, caslib, and other common parameters.

For more information about specifying the table parameter, see the common castable parameter.

weight="variable-name"

specifies the numeric weight variable used to compute the statistics in the table cell and in the margins of the table.

crossTab Action

Performs one-way or two-way tabulations.

See: Results
Example:Perform a Two-Way Tabulation Using a Weighting Variable

Lua Syntax

Expand allCollapse all
results, info = s:simple_crossTab{
acrossBy=true | false,
aggregator="CSS" | "CV" | "KURTOSIS" | "MAX" | "MEAN" | "MIN" | "N" | "NMISS" | "PROBT" | "SKEWNESS" | "STD" | "STDERR" | "SUM" | "TSTAT" | "USS" | "VAR",
association=true | false,
chiSq=true | false,
col="variable-name",
colFormat="string",
colNBins=integer,
descending=true | false,
fullTable=true | false,
groupByLimit=64-bit-integer,
includeMissing=true | false,
niceBinning=true | false,
orderByGbyRaw=true | false,
required parameter row="variable-name",
rowFormat="string",
rowNBins=integer,
required parameter table
={
caslib="string",
computedOnDemand=true | false,
computedVars
={{
format="string",
formattedLength=integer,
label="string",
required parameter name="variable-name",
nfd=integer,
nfl=integer
}, {...}},
computedVarsProgram="string",
dataSourceOptions={key-1=any-list-or-data-type-1 <, key-2=any-list-or-data-type-2, ...>},
groupBy
={{
format="string",
formattedLength=integer,
label="string",
required parameter name="variable-name",
nfd=integer,
nfl=integer
}, {...}},
groupByMode="NOSORT" | "REDISTRIBUTE",
importOptions={fileType="ANY" | "AUDIO" | "AUTO" | "BASESAS" | "CSV" | "DELIMITED" | "DOCUMENT" | "DTA" | "ESP" | "EXCEL" | "FMT" | "HDAT" | "IMAGE" | "JMP" | "LASR" | "PARQUET" | "SOUND" | "SPSS" | "VIDEO" | "XLS", fileType-specific-parameters},
required parameter name="table-name",
orderBy
={{
format="string",
formattedLength=integer,
label="string",
required parameter name="variable-name",
nfd=integer,
nfl=integer
}, {...}},
singlePass=true | false,
vars
={{
format="string",
formattedLength=integer,
label="string",
required parameter name="variable-name",
nfd=integer,
nfl=integer
}, {...}},
where="where-expression",
whereTable
={
casLib="string"
dataSourceOptions={adls_noreq-parameters | bigquery-parameters | cas_noreq-parameters | clouddex-parameters | db2-parameters | dnfs-parameters | esp-parameters | fedsvr-parameters | gcs_noreq-parameters | hadoop-parameters | hana-parameters | impala-parameters | informix-parameters | jdbc-parameters | mongodb-parameters | mysql-parameters | odbc-parameters | oracle-parameters | path-parameters | postgres-parameters | redshift-parameters | s3-parameters | sapiq-parameters | sforce-parameters | singlestore_standard-parameters | snowflake-parameters | spark-parameters | spde-parameters | sqlserver-parameters | ss_noreq-parameters | teradata-parameters | vertica-parameters | yellowbrick-parameters}
importOptions={fileType="ANY" | "AUDIO" | "AUTO" | "BASESAS" | "CSV" | "DELIMITED" | "DOCUMENT" | "DTA" | "ESP" | "EXCEL" | "FMT" | "HDAT" | "IMAGE" | "JMP" | "LASR" | "PARQUET" | "SOUND" | "SPSS" | "VIDEO" | "XLS", fileType-specific-parameters}
required parameter name="table-name"
vars
={{
format="string",
formattedLength=integer,
label="string",
required parameter name="variable-name",
nfd=integer,
nfl=integer
}, {...}}
where="where-expression"
}
},
weight="variable-name"
}
indicates a required parameter

Summary: Input Tables

If a row includes a subparameter, you can specify the name, caslib, and so on in the subparameter. Otherwise, you can specify the name, caslib, and so on in the parameter.

Parameters for Reading Input Tables

Parameter

Subparameter

Description

required parametertable

—

specifies the table name, caslib, and other common parameters.

Parameter Descriptions

acrossBy=true | false

when set to True, the levels of row and column variables are the same across the group-by variables.

Defaultfalse

aggregator="CSS" | "CV" | "KURTOSIS" | "MAX" | "MEAN" | "MIN" | "N" | "NMISS" | "PROBT" | "SKEWNESS" | "STD" | "STDERR" | "SUM" | "TSTAT" | "USS" | "VAR"

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.

CSS

specifies the corrected sum of squares.

CV

specifies the coefficient of variation.

KURTOSIS

specifies the kurtosis.

MAX

specifies the maximum value.

MEAN

specifies the arithmetic mean.

MIN

specifies the minimum value.

N

specifies the number of observations.

NMISS

specifies the number of missing values.

PROBT

specifies the p-value for the t-statistic.

SKEWNESS

specifies the skewness.

STD

specifies the standard deviation.

STDERR

specifies the standard error.

SUM

specifies the sum of nonmissing values.

TSTAT

specifies the t-statistic for H:mean=0.

AliasT
USS

specifies the uncorrected sum of squares.

VAR

specifies the sample variance.

association=true | false

when set to True, measures of association between the row and column variable of the crosstabulation are computed.

Defaultfalse

chiSq=true | false

when set to True, chi-square statistics are computed for the test of independence of the row and column variables and their asymptotic p-values.

Defaultfalse

col="variable-name"

specifies the column variable

colFormat="string"

specifies a format for the column variable.

colNBins=integer

specifies the number of bins to use in binning the column variable.

Range0–MACINT

descending=true | false

when set to True, the formatted levels of the variables are arranged in descending order.

Defaultfalse

fullTable=true | false

when set to True, a full-table scan is performed.

Defaultfalse

groupByLimit=64-bit-integer

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.

Minimum value1

includeMissing=true | false

when set to True, missing values are included in the crosstabulation.

Defaultfalse

niceBinning=true | false

when set to True, the nice binning algorithm is used.

Defaulttrue

orderByGbyRaw=true | false

when set to True, the ordering of the group-by variables is based on the raw values of the variables, not the formatted values.

AliasorderByRaw
Defaultfalse

* row="variable-name"

specifies the row variable.

rowFormat="string"

specifies a format for the row variable.

rowNBins=integer

specifies the number of bins to use in binning the row variable.

Range0–MACINT

* table={castable}

specifies the table name, caslib, and other common parameters.

For more information about specifying the table parameter, see the common castable parameter.

weight="variable-name"

specifies the numeric weight variable used to compute the statistics in the table cell and in the margins of the table.

crossTab Action

Performs one-way or two-way tabulations.

See: Results
Example:Perform a Two-Way Tabulation Using a Weighting Variable

Python Syntax

Expand allCollapse all
results=s.simple.crossTab(
acrossBy=True | False,
aggregator="CSS" | "CV" | "KURTOSIS" | "MAX" | "MEAN" | "MIN" | "N" | "NMISS" | "PROBT" | "SKEWNESS" | "STD" | "STDERR" | "SUM" | "TSTAT" | "USS" | "VAR",
association=True | False,
chiSq=True | False,
col="variable-name",
colFormat="string",
colNBins=integer,
descending=True | False,
fullTable=True | False,
groupByLimit=64-bit-integer,
includeMissing=True | False,
niceBinning=True | False,
orderByGbyRaw=True | False,
required parameter row="variable-name",
rowFormat="string",
rowNBins=integer,
required parameter table
={
"caslib":"string",
"computedOnDemand":True | False,
"computedVars"
:[{
"format":"string",
"formattedLength":integer,
"label":"string",
required parameter "name":"variable-name",
"nfd":integer,
"nfl":integer
}<, {...}>],
"computedVarsProgram":"string",
"dataSourceOptions":{"key-1":{any-list-or-data-type-1} <, "key-2":{any-list-or-data-type-2}, ...>},
"groupBy"
:[{
"format":"string",
"formattedLength":integer,
"label":"string",
required parameter "name":"variable-name",
"nfd":integer,
"nfl":integer
}<, {...}>],
"groupByMode":"NOSORT" | "REDISTRIBUTE",
"importOptions":{"fileType":"ANY" | "AUDIO" | "AUTO" | "BASESAS" | "CSV" | "DELIMITED" | "DOCUMENT" | "DTA" | "ESP" | "EXCEL" | "FMT" | "HDAT" | "IMAGE" | "JMP" | "LASR" | "PARQUET" | "SOUND" | "SPSS" | "VIDEO" | "XLS", fileType-specific-parameters},
required parameter "name":"table-name",
"orderBy"
:[{
"format":"string",
"formattedLength":integer,
"label":"string",
required parameter "name":"variable-name",
"nfd":integer,
"nfl":integer
}<, {...}>],
"singlePass":True | False,
"vars"
:[{
"format":"string",
"formattedLength":integer,
"label":"string",
required parameter "name":"variable-name",
"nfd":integer,
"nfl":integer
}<, {...}>],
"where":"where-expression",
"whereTable"
:{
"casLib":"string"
"dataSourceOptions":{adls_noreq-parameters | bigquery-parameters | cas_noreq-parameters | clouddex-parameters | db2-parameters | dnfs-parameters | esp-parameters | fedsvr-parameters | gcs_noreq-parameters | hadoop-parameters | hana-parameters | impala-parameters | informix-parameters | jdbc-parameters | mongodb-parameters | mysql-parameters | odbc-parameters | oracle-parameters | path-parameters | postgres-parameters | redshift-parameters | s3-parameters | sapiq-parameters | sforce-parameters | singlestore_standard-parameters | snowflake-parameters | spark-parameters | spde-parameters | sqlserver-parameters | ss_noreq-parameters | teradata-parameters | vertica-parameters | yellowbrick-parameters}
"importOptions":{"fileType":"ANY" | "AUDIO" | "AUTO" | "BASESAS" | "CSV" | "DELIMITED" | "DOCUMENT" | "DTA" | "ESP" | "EXCEL" | "FMT" | "HDAT" | "IMAGE" | "JMP" | "LASR" | "PARQUET" | "SOUND" | "SPSS" | "VIDEO" | "XLS", fileType-specific-parameters}
required parameter "name":"table-name"
"vars"
:[{
"format":"string",
"formattedLength":integer,
"label":"string",
required parameter "name":"variable-name",
"nfd":integer,
"nfl":integer
}<, {...}>]
"where":"where-expression"
}
},
weight="variable-name"
)
indicates a required parameter

Summary: Input Tables

If a row includes a subparameter, you can specify the name, caslib, and so on in the subparameter. Otherwise, you can specify the name, caslib, and so on in the parameter.

Parameters for Reading Input Tables

Parameter

Subparameter

Description

required parametertable

—

specifies the table name, caslib, and other common parameters.

Parameter Descriptions

acrossBy=True | False

when set to True, the levels of row and column variables are the same across the group-by variables.

DefaultFalse

aggregator="CSS" | "CV" | "KURTOSIS" | "MAX" | "MEAN" | "MIN" | "N" | "NMISS" | "PROBT" | "SKEWNESS" | "STD" | "STDERR" | "SUM" | "TSTAT" | "USS" | "VAR"

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.

CSS

specifies the corrected sum of squares.

CV

specifies the coefficient of variation.

KURTOSIS

specifies the kurtosis.

MAX

specifies the maximum value.

MEAN

specifies the arithmetic mean.

MIN

specifies the minimum value.

N

specifies the number of observations.

NMISS

specifies the number of missing values.

PROBT

specifies the p-value for the t-statistic.

SKEWNESS

specifies the skewness.

STD

specifies the standard deviation.

STDERR

specifies the standard error.

SUM

specifies the sum of nonmissing values.

TSTAT

specifies the t-statistic for H:mean=0.

AliasT
USS

specifies the uncorrected sum of squares.

VAR

specifies the sample variance.

association=True | False

when set to True, measures of association between the row and column variable of the crosstabulation are computed.

DefaultFalse

chiSq=True | False

when set to True, chi-square statistics are computed for the test of independence of the row and column variables and their asymptotic p-values.

DefaultFalse

col="variable-name"

specifies the column variable

colFormat="string"

specifies a format for the column variable.

colNBins=integer

specifies the number of bins to use in binning the column variable.

Range0–MACINT

descending=True | False

when set to True, the formatted levels of the variables are arranged in descending order.

DefaultFalse

fullTable=True | False

when set to True, a full-table scan is performed.

DefaultFalse

groupByLimit=64-bit-integer

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.

Minimum value1

includeMissing=True | False

when set to True, missing values are included in the crosstabulation.

DefaultFalse

niceBinning=True | False

when set to True, the nice binning algorithm is used.

DefaultTrue

orderByGbyRaw=True | False

when set to True, the ordering of the group-by variables is based on the raw values of the variables, not the formatted values.

AliasorderByRaw
DefaultFalse

* row="variable-name"

specifies the row variable.

rowFormat="string"

specifies a format for the row variable.

rowNBins=integer

specifies the number of bins to use in binning the row variable.

Range0–MACINT

* table={castable}

specifies the table name, caslib, and other common parameters.

For more information about specifying the table parameter, see the common castable parameter.

weight="variable-name"

specifies the numeric weight variable used to compute the statistics in the table cell and in the margins of the table.

crossTab Action

Performs one-way or two-way tabulations.

See: Results
Example:Perform a Two-Way Tabulation Using a Weighting Variable

R Syntax

Expand allCollapse all
results <– cas.simple.crossTab(s,
acrossBy=TRUE | FALSE,
aggregator="CSS" | "CV" | "KURTOSIS" | "MAX" | "MEAN" | "MIN" | "N" | "NMISS" | "PROBT" | "SKEWNESS" | "STD" | "STDERR" | "SUM" | "TSTAT" | "USS" | "VAR",
association=TRUE | FALSE,
chiSq=TRUE | FALSE,
col="variable-name",
colFormat="string",
colNBins=integer,
descending=TRUE | FALSE,
fullTable=TRUE | FALSE,
groupByLimit=64-bit-integer,
includeMissing=TRUE | FALSE,
niceBinning=TRUE | FALSE,
orderByGbyRaw=TRUE | FALSE,
required parameter row="variable-name",
rowFormat="string",
rowNBins=integer,
required parameter table
=list(
caslib="string",
computedOnDemand=TRUE | FALSE,
computedVars
=list( list(
format="string",
formattedLength=integer,
label="string",
required parameter name="variable-name",
nfd=integer,
nfl=integer
) <, list(...)>),
computedVarsProgram="string",
dataSourceOptions=list(key-1=list(any-list-or-data-type-1) <, key-2=list(any-list-or-data-type-2), ...>),
groupBy
=list( list(
format="string",
formattedLength=integer,
label="string",
required parameter name="variable-name",
nfd=integer,
nfl=integer
) <, list(...)>),
groupByMode="NOSORT" | "REDISTRIBUTE",
importOptions=list(fileType="ANY" | "AUDIO" | "AUTO" | "BASESAS" | "CSV" | "DELIMITED" | "DOCUMENT" | "DTA" | "ESP" | "EXCEL" | "FMT" | "HDAT" | "IMAGE" | "JMP" | "LASR" | "PARQUET" | "SOUND" | "SPSS" | "VIDEO" | "XLS", fileType-specific-parameters),
required parameter name="table-name",
orderBy
=list( list(
format="string",
formattedLength=integer,
label="string",
required parameter name="variable-name",
nfd=integer,
nfl=integer
) <, list(...)>),
singlePass=TRUE | FALSE,
vars
=list( list(
format="string",
formattedLength=integer,
label="string",
required parameter name="variable-name",
nfd=integer,
nfl=integer
) <, list(...)>),
where="where-expression",
whereTable
=list(
casLib="string"
dataSourceOptions=list(adls_noreq-parameters | bigquery-parameters | cas_noreq-parameters | clouddex-parameters | db2-parameters | dnfs-parameters | esp-parameters | fedsvr-parameters | gcs_noreq-parameters | hadoop-parameters | hana-parameters | impala-parameters | informix-parameters | jdbc-parameters | mongodb-parameters | mysql-parameters | odbc-parameters | oracle-parameters | path-parameters | postgres-parameters | redshift-parameters | s3-parameters | sapiq-parameters | sforce-parameters | singlestore_standard-parameters | snowflake-parameters | spark-parameters | spde-parameters | sqlserver-parameters | ss_noreq-parameters | teradata-parameters | vertica-parameters | yellowbrick-parameters)
importOptions=list(fileType="ANY" | "AUDIO" | "AUTO" | "BASESAS" | "CSV" | "DELIMITED" | "DOCUMENT" | "DTA" | "ESP" | "EXCEL" | "FMT" | "HDAT" | "IMAGE" | "JMP" | "LASR" | "PARQUET" | "SOUND" | "SPSS" | "VIDEO" | "XLS", fileType-specific-parameters)
required parameter name="table-name"
vars
=list( list(
format="string",
formattedLength=integer,
label="string",
required parameter name="variable-name",
nfd=integer,
nfl=integer
) <, list(...)>)
where="where-expression"
)
),
weight="variable-name"
)
indicates a required parameter

Summary: Input Tables

If a row includes a subparameter, you can specify the name, caslib, and so on in the subparameter. Otherwise, you can specify the name, caslib, and so on in the parameter.

Parameters for Reading Input Tables

Parameter

Subparameter

Description

required parametertable

—

specifies the table name, caslib, and other common parameters.

Parameter Descriptions

acrossBy=TRUE | FALSE

when set to True, the levels of row and column variables are the same across the group-by variables.

DefaultFALSE

aggregator="CSS" | "CV" | "KURTOSIS" | "MAX" | "MEAN" | "MIN" | "N" | "NMISS" | "PROBT" | "SKEWNESS" | "STD" | "STDERR" | "SUM" | "TSTAT" | "USS" | "VAR"

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.

CSS

specifies the corrected sum of squares.

CV

specifies the coefficient of variation.

KURTOSIS

specifies the kurtosis.

MAX

specifies the maximum value.

MEAN

specifies the arithmetic mean.

MIN

specifies the minimum value.

N

specifies the number of observations.

NMISS

specifies the number of missing values.

PROBT

specifies the p-value for the t-statistic.

SKEWNESS

specifies the skewness.

STD

specifies the standard deviation.

STDERR

specifies the standard error.

SUM

specifies the sum of nonmissing values.

TSTAT

specifies the t-statistic for H:mean=0.

AliasT
USS

specifies the uncorrected sum of squares.

VAR

specifies the sample variance.

association=TRUE | FALSE

when set to True, measures of association between the row and column variable of the crosstabulation are computed.

DefaultFALSE

chiSq=TRUE | FALSE

when set to True, chi-square statistics are computed for the test of independence of the row and column variables and their asymptotic p-values.

DefaultFALSE

col="variable-name"

specifies the column variable

colFormat="string"

specifies a format for the column variable.

colNBins=integer

specifies the number of bins to use in binning the column variable.

Range0–MACINT

descending=TRUE | FALSE

when set to True, the formatted levels of the variables are arranged in descending order.

DefaultFALSE

fullTable=TRUE | FALSE

when set to True, a full-table scan is performed.

DefaultFALSE

groupByLimit=64-bit-integer

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.

Minimum value1

includeMissing=TRUE | FALSE

when set to True, missing values are included in the crosstabulation.

DefaultFALSE

niceBinning=TRUE | FALSE

when set to True, the nice binning algorithm is used.

DefaultTRUE

orderByGbyRaw=TRUE | FALSE

when set to True, the ordering of the group-by variables is based on the raw values of the variables, not the formatted values.

AliasorderByRaw
DefaultFALSE

* row="variable-name"

specifies the row variable.

rowFormat="string"

specifies a format for the row variable.

rowNBins=integer

specifies the number of bins to use in binning the row variable.

Range0–MACINT

* table=list(castable)

specifies the table name, caslib, and other common parameters.

For more information about specifying the table parameter, see the common castable parameter.

weight="variable-name"

specifies the numeric weight variable used to compute the statistics in the table cell and in the margins of the table.

Last updated: July 15, 2026