UnivariateStatistics Example 1: ExcludeColumns, All Statistics by Default - Teradata Vantage

This example excludes columns id and period from the target columns and outputs all three statistics tables.

Input

• finance_data3, as in VARMAX Example 1: No Exogenous Model

SQL Call

DROP TABLE moments;
DROP TABLE basic;  
DROP TABLE quantiles;

SELECT * FROM UnivariateStatistics (
  ON finance_data3 AS InputTable
  OUT TABLE MomentsTableName (moments)
  OUT TABLE BasicTableName (basic)
  OUT TABLE QuantilesTableName (quantiles)
  USING
  ExcludeColumns ('id','period')
) AS dt;

Output

UnivariateStatistics succeeded. The output tables are saved.

This query returns the following table:

SELECT * FROM moments;

This query returns the following table:

SELECT * FROM basic ORDER BY stats;

This query returns the following table:

SELECT * FROM quantiles;