Find columns similar to test column (one by many correlation)

[#1]

With 20,000 columns of continuous data, correlation of all by all is undesirable.  How to calculate correlation of all columns vs one column (many to one)?  to find similar columns.

[#2 · Accepted solution]

You can get what you need by using Response Screening

     Analyze=>Screening=>Response Screening

Place your 20,000 rows in the Y Response and your single comparison column in the X

[#3]

Excellent. Thx for quick response!