The following table describes the function results data. If the function creates an output table, the bold columns comprise its Unique Primary Index (UPI).
Column | Data Type | Description |
---|---|---|
xtbl | VARCHAR (128) | Table with frequency values, specified by tablename. |
xcol | VARCHAR (128) | Column with frequency variable, specified by columns. Any number of columns can be specified. |
xval | VARCHAR (256) | Distinct value of frequency variable. |
xcnt | FLOAT | Count of rows where frequency variable equals distinct value in xval. |
xpct | FLOAT | Percentage of rows where frequency variable equals distinct value in xval. |
xmin_column_name | FLOAT | [If cumulativeoption=false, column appears once for each column specified by statisticscolumns.] Minimum value of distinct value in xval. |
xmax_column_name | FLOAT | [If cumulativeoption=false, column appears once for each column specified by statisticscolumns.] Maximum value of distinct value in xval. |
xmean_column_name | FLOAT | [If cumulativeoption=false, column appears once for each column specified by statisticscolumns.] Mean of distinct value in xval. |
xstd_column_name | FLOAT | [If cumulativeoption=false, column appears once for each column specified by statisticscolumns.] Standard deviation of distinct value in xval. |
xcum_cnt | FLOAT | [Column appears only if cumulativeoption=true and you omit statisticscolumns.] Cumulative count of rows where frequency variable equals distinct value in xval. |
xcum_pct | FLOAT | [Column appears only if cumulativeoption=true and you omit statisticscolumns.] Cumulative percentage of rows where frequency variable equals distinct value in xval. |
xrank | FLOAT | [Column appears only if cumulativeoption=true and you omit statisticscolumns.] Rank, with respect to all frequencies, where frequency variable equals distinct value in xval. |
Name | Type | Definition |
---|---|---|
column_name | Same as in input table | [Column appears once for each column specified by columns.] Column for which crosstab frequency was calculated. |
xcnt | FLOAT | Count of rows where frequency variable equals distinct value in column_name. |
xpct | FLOAT | Percentage of rows where frequency variable equals distinct value in column_name. |
xcum_cnt | FLOAT | [Column appears only if cumulativeoption=true and you omit statisticscolumns.] Cumulative count of rows where frequency variable equals distinct value in column_name. |
xcum_pct | FLOAT | [Column appears only if cumulativeoption=true and you omit statisticscolumns.] Cumulative percentage of rows where frequency variable equals distinct value in column_name. |
xrank | FLOAT | [Column appears only if cumulativeoption=true and you omit statisticscolumns.] Rank, with respect to all frequencies, where frequency variable equals distinct value in column_name. |
Name | Type | Definition |
---|---|---|
xtbl | VARCHAR (128) | Table with frequency values, specified by tablename. |
col1 | VARCHAR (30) | Column representing first frequency variable, specified by columns Any number of columns can be specified in two groups. |
val1 | VARCHAR (256) | Distinct values of first frequency variable. |
col2 | VARCHAR (30) | Column representing second frequency variable, specified by columns. |
val2 | VARCHAR (256) | Distinct values of second frequency variable. |
xcnt | FLOAT | Count of rows where pairwise combination of frequency variables equals pair of distinct value in val1 and val2. |
xpct | FLOAT | Percentage of rows where pairwise combination of frequency variables equals pair of distinct value in val1 and val2. |