This example uses VIF and specifies 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) ExceptionAttribute ('gdp') ) AS dt;
Output
SELECT * FROM corr_output;
state | attribute | vif_score | iteration | multicollinear -------+-------------+-----------+-----------+---------------- CA | gdp | 1.05564 | 2 | no CA | unemployed | 1.05564 | 2 | no CA | armedforces | 17.5641 | 2 | yes CA | employed | 78.7389 | 2 | yes TX | gdp | 1.72353 | 1 | no TX | unemployed | 2.41752 | 1 | no TX | armedforces | 2.04158 | 1 | no TX | employed | 34.9027 | 1 | yes