The following table describes the function results data. If the function creates an output table, the bold columns comprise its Unique Primary Index (UPI).
For important information about bin boundaries, see binstyle in Syntax.
Column | Data Type | Description |
---|---|---|
xtbl | VARCHAR (128) | Table against which bin values are computed, specified by tablename. |
xcol | VARCHAR (128) | [Column appears once for each column specified by columns.] Name or alias of column against which bin values are computed. |
xbin | INTEGER | Bin number of column. |
xbeg | FLOAT | Beginning boundary for bin of column. |
xend | FLOAT | Ending boundary for bin of column. |
xcnt | FLOAT | Count of rows in bin. |
xpct | FLOAT | Percentage of rows in bin. |
ovly_column_name | Overlay Column Type | [Column appears once for each column specified by overlaycolumnsValue of column to overlay within bin (unique categorical values into which bin is divided). |
xocnt | FLOAT | [Column appears once for each column specified by overlaycolumns.] Number of rows within bin in which overlay column value appears. |
xobpct | FLOAT | [Column appears once for each column specified by overlaycolumns.] Percentage of rows within bin in which overlay column value appears. |
xopct | FLOAT | [Column appears once for each column specified by overlaycolumns.] Percentage of all rows in which overlay column value appears. |
xmin_column_name | FLOAT | [Column appears once for each column specified by statisticscolumns.] Minimum value of statistics column within bin. |
xmax_column_name | FLOAT | [Column appears once for each column specified by statisticscolumns.] Maximum value of statistics column within bin. |
xmean_column_name | FLOAT | [Column appears once for each column specified by statisticscolumns.] Mean (average) of statistics column within bin. |
xstd_column_name | FLOAT | [Column appears once for each column specified by statisticscolumns.] Standard deviation of statistics column within bin. For date column, standard deviation is in days. |
Column | Data Type | Description |
---|---|---|
xbin_column_name | INTEGER | [Column appears once for each column specified by columns.] Bin number of column. |
xbeg_column_name | FLOAT | [Column appears once for each column specified by columns.] Beginning boundary for bin of column. |
xend_column_name | FLOAT | [Column appears once for each column specified by columns.] Ending boundary for bin of column. |
xcnt | FLOAT | Count of rows in bin. |
xpct | FLOAT | Percentage of rows in bin. |
ovly_column_name | Overlay Column Type | [Column appears once for each column specified by overlaycolumns.] Value of column to overlay within bin (unique categorical values into which bin is divided). |
xocnt | FLOAT | [Column appears once for each column specified by overlaycolumns.] Number of rows within bin in which overlay column value appears. |
xobpct | FLOAT | [Column appears once for each column specified by overlaycolumns.] Percentage of rows within bin in which overlay column value appears. |
xopct | FLOAT | [Column appears once for each column specified by overlaycolumns.] Percentage of all rows in which overlay column value appears. |
xmin_column_name | FLOAT | [Column appears once for each column specified by statisticscolumns.] Minimum value of statistics column within bin. |
xmax_column_name | FLOAT | [Column appears once for each column specified by statisticscolumns.] Maximum value of statistics column within bin. |
xmean_column_name | FLOAT | [Column appears once for each column specified by statisticscolumns.] Mean (average) of statistics column within bin. |
xstd_column_name | FLOAT | [Column appears once for each column specified by statisticscolumns.] Standard deviation of statistics column within bin. For date column, standard deviation is in days. |