Help using Base SAS procedures

Help with PROC CORR

Reply
N/A
Posts: 0

Help with PROC CORR

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!
Super Contributor
Posts: 281

Re: Help with PROC CORR

"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?
N/A
Posts: 0

Re: Help with PROC CORR

I want to see which subcategory (a, b, c, or d) best correlates to the total.
N/A
Posts: 0

Re: Help with PROC CORR

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 ;
Ask a Question
Discussion stats
  • 3 replies
  • 113 views
  • 0 likes
  • 2 in conversation