topic Re: Help with PROC CORR in SAS Procedures

Help with PROC CORR

deleted_user — Wed, 05 Nov 2008 17:24:52 GMT

I have data that I need to correlate. It is in categories and subcategories. Example:
category - subcategory - set1 - set2
Leadership - A - 4.07 - 2.38
Leadership - B - 4.09 - 2.19
Leadership - C - 3.36 - 2.62
Leadership - D - 3.47 - 2.11
Leadership - Total - 3.75 - 2.33

I want to see which (A, B, C, D) provides the best correlation to the total for that group for each individual set. I have about 15 sets and 10 groups - all with subcategories.

Help!

Thanks so much!

Re: Help with PROC CORR

Paige — Wed, 05 Nov 2008 17:27:53 GMT

"the best correlation to the total for that group"??

That is not a statistical concept that I am familiar with. Could you define it further?

Re: Help with PROC CORR

deleted_user — Wed, 05 Nov 2008 17:34:21 GMT

I want to see which subcategory (a, b, c, or d) best correlates to the total.

Re: Help with PROC CORR

deleted_user — Wed, 05 Nov 2008 21:49:27 GMT

Here is what seemed to work for me:

I transposed the data and then used:

PROC CORR data=name;
var LeadershipT;
with leadershipa leadershipb leadershipc leadershipd;
RUN ;