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 |
|---|---|---|
| groupby column | Same as in input table | [Column appears once for each specified groupby column.] Column name is same in input and output tables. Column contains unique values. |
| xtbl | VARCHAR (128) | Table where variable for values operation resides, specified by tablename. |
| xcol | VARCHAR (128) | Variable against which values operation runs, specified by columns. |
| xtype | VARCHAR (128) | Data type of variable. |
| xcnt | FLOAT | Number of occurrences of variable. |
| xnull | FLOAT | Number of rows where variable has NULL value. |
| xunique | FLOAT | Number of rows where variable has unique value. |
| xblank | FLOAT | Number of rows where variable has blank value. |
| xzero | FLOAT | Number of rows where variable has value 0. |
| xpos | FLOAT | Number of rows where variable has positive value. |
| xneg | FLOAT | Number of rows where variable has negative value. |