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. |