Correlation Example | Teradata Vantage - Correlation Example: VIF ('true'), ExceptionAttribute, OutputSummary ('false') - Teradata Vantage

Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
9.02
9.01
2.0
1.3
Published
February 2022
Language
English (United States)
Last Update
2022-02-10
dita:mapPath
rnn1580259159235.ditamap
dita:ditavalPath
ybt1582220416951.ditaval
dita:id
B700-4003
lifecycle
previous
Product Category
Teradata Vantageā„¢

This example uses VIF and specifies an ExceptionAttribute and OutputSummary ('false').

SQL Call

SELECT * FROM Correlation (
  ON corr_input AS InputTable
  OUT TABLE OutputTable (corr_output)
  USING
  VIF ('t')
  TargetColumns ('gdp', 'unemployed', 'armedforces', 'employed')
  PartitionColumns ('state')
  VIFThreshold (10)
  ExceptionAttribute ('gdp')
  OutputSummary ('f')
) AS dt;

Output

SELECT * FROM corr_output order by 1,4,2;
 state |  attribute  | vif_score | iteration | multicollinear 
-------+-------------+-----------+-----------+----------------
 TX    | gdp         |   47.8656 |         0 | no
 TX    | unemployed  |   13.8765 |         0 | yes
 TX    | armedforces |    3.9491 |         0 | no
 TX    | employed    |   34.9027 |         0 | yes
 TX    | gdp         |   1.72353 |         1 | no
 TX    | unemployed  |   2.41752 |         1 | no
 TX    | armedforces |   2.04158 |         1 | no
 CA    | gdp         |   107.705 |         0 | no
 CA    | unemployed  |    6.9572 |         0 | no
 CA    | armedforces |   20.1448 |         0 | yes
 CA    | employed    |   78.7389 |         0 | yes
 CA    | gdp         |   15.7155 |         1 | no
 CA    | unemployed  |   1.62883 |         1 | no
 CA    | armedforces |   17.5641 |         1 | yes
 CA    | gdp         |   1.05564 |         2 | no
 CA    | unemployed  |   1.05564 |         2 | no