Results Data | Statistics Analysis | Vantage Analytics Library - Results Data - Vantage Analytics Library

Vantage Analytics Library User Guide
Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Vantage Analytics Library
Release Number
2.2.0
Published
March 2023
Language
English (United States)
Last Update
2024-01-02
dita:mapPath
ibw1595473364329.ditamap
dita:ditavalPath
iup1603985291876.ditaval
dita:id
zyl1473786378775
Product Category
Teradata Vantage

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 parameter.
xcol VARCHAR (128) Variable against which values operation runs, specified by columns parameter.
xcnt FLOAT Number of occurrences of variable.
xmin FLOAT [Column appears only if statsoptions specifies minimum.] Minimum value of variable.
xmax FLOAT [Column appears only if statsoptions specifies maximum.] Maximum value of variable.
xmean FLOAT [Column appears only if statsoptions specifies mean.] Arithmetic mean of variable.
xstd FLOAT [Column appears only if statsoptions specifies standarddeviation.] Standard deviation of variable.
xskew FLOAT [Column appears only if statsoptions specifies skewness.] Skewness of variable.
xkurt FLOAT [Column appears only if statsoptions specifies Kurtosis.] Kurtosis of variable.
xste FLOAT [Column appears only if statsoptions specifies standarderror.] Standard error of variable.
xcv FLOAT [Column appears only if statsoptions specifies variance.] Coefficient of variance of variable.
xvar FLOAT [Column appears only if statsoptions specifies variance.] Variance of variable.
xsum FLOAT [Column appears only if statsoptions specifies sum.] Sum of variable.
xuss FLOAT [Column appears only if statsoptions specifies uncorrectedsumofsquares.] Uncorrected sum of squares of variable.
xcss FLOAT [Column appears only if statsoptions specifies correctedsumofsquares.] Corrected sum of squares of variable.
xnull FLOAT [Column appears only if extendedoptions specifies values.] Number of rows where variable has NULL value.
xunique FLOAT [Column appears only if extendedoptions specifies values.] Number of rows where variable has unique value.
xblank FLOAT [Column appears only if extendedoptions specifies values.] Number of rows where variable has blank value.
xzero FLOAT [Column appears only if extendedoptions specifies values.] Number of rows where variable has value 0.
xpos FLOAT [Column appears only if extendedoptions specifies values.] Number of rows where variable has positive value.
xneg FLOAT [Column appears only if extendedoptions specifies values.] Number of rows where variable has negative value.
xmode FLOAT [Column appears only if extendedoptions specifies modes.] Modal (most frequently occurring value of variable).

If there are multiple modes, this value is minimum modal value, and table includes xnbrmodes column.
xmode_cnt FLOAT [Column appears only if extendedoptions specifies modes, once for each specified groupby column.] Number of times modal value occurs in group.
xmode_pct FLOAT [Column appears only if extendedoptions specifies modes, once for each specified groupby column.] Percentage of times modal value occurs in group, with respect to all selected rows.
xnbrmodes FLOAT [Column appears only if extendedoptions specifies modes and there are multiple modes.] Number of modal values.
xpctileN FLOAT [Column appears only if extendedoptions specifies quantiles.] Percentiles, deciles, quartiles, and tertiles of variable, as follows:
Quantile Values of N
Bottom 10 percentiles [0, 9]
Deciles 10, 20, 30, 40, 50, 60, 70, 80, 90
Quartiles 25, 50, 75
Tertiles 33,67
Top 10 percentiles [91, 100]
xmin_N FLOAT [Column appears only if extendedoptions specifies rank.] Five smallest values of variable.
xmincnt_N FLOAT [Column appears only if extendedoptions specifies rank.] Number of times variable has five smallest values.
xmax_N FLOAT [Column appears only if extendedoptions specifies rank.] Five largest values of variable.
xmaxcnt_N FLOAT [Column appears only if extendedoptions specifies rank.] Number of times variable has five largest values.