This example uses VIF and specifies an ExceptionAttribute and OutputSummary ('false').
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') 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