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

This example uses VIF but does not specify an ExceptionAttribute. OutputSummary has its default value, 'true'.

Input

• InputTable: corr_input, as in Correlation Example: VIF ('false'), Include PartitionColumns

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)
) AS dt;

Output

SELECT * FROM corr_output;

 state |  attribute  | vif_score | iteration | multicollinear 
-------+-------------+-----------+-----------+----------------
 CA    | gdp         |   107.705 |         2 | yes
 CA    | unemployed  |   1.17982 |         2 | no
 CA    | armedforces |   1.17982 |         2 | no
 CA    | employed    |   11.4889 |         2 | yes
 TX    | gdp         |   47.8656 |         1 | yes
 TX    | unemployed  |   1.98163 |         1 | no
 TX    | armedforces |   2.23415 |         1 | no
 TX    | employed    |   1.25676 |         1 | no