This example does not use VIF and omits the PartitionColumns syntax element, so the function determines the correlation values for the overall population and does not group the data by state.
Input
- 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_2) USING TargetColumnPairs ('[2:3]', 'employed:gdp', 'employed:unemployed', 'employed:armedforces') ) AS dt;
Output
message --------------------------------------------------------------------------------------- Output table is successfully stored in the table specified in OutputTable argument
SELECT * FROM corr_output_2;
corr_item1 corr_item2 value_col ----------- ----------- ------------------ gdpdeflator gdp 1.0 armedforces employed 0.4573073983192444 unemployed employed 0.5024980902671814 gdp employed 0.9835516214370728 gdp gdp 1.0 gdpdeflator gdpdeflator 1.0
Download a zip file of all examples and a SQL script file that creates their input tables.