This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
EugeneB
EugeneB
Level III

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

Created: Jan 16, 2021 01:47 PM  |  Last Modified: Jun 8, 2023 08:27 PM (450 views)

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.

0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User txnelson
Super User
Solution

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

Jan 16, 2021 01:57 PM (446 views)  |  Posted in reply to message from EugeneB 01-16-2021

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

Jim

View solution in original post

2 REPLIES 2
txnelson
Super User txnelson
Super User
Solution

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

Jan 16, 2021 01:57 PM (447 views)  |  Posted in reply to message from EugeneB 01-16-2021

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

Jim
EugeneB
EugeneB
Level III

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

Jan 16, 2021 02:06 PM (444 views)  |  Posted in reply to message from txnelson 01-16-2021
Excellent. Thx for quick response!
0 Kudos