BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
lizzy28
Quartz | Level 8

Hi community,

I am trying to examine correlation between two variables by group, and there are over 100 groups. What would be a quick and efficient to do that rather than running corr/reg group by group?

For example, I have variables group, var1 and var2 in data "have". There are over 100 groups (1-150), and each group has around 50 observations. I need to get correlation between var1 and var2 by group. My dumb way is:

proc corr data=work.have;

     var var1 var2;

    where group=1;

run;

Thank you all.

Lizi

1 ACCEPTED SOLUTION

Accepted Solutions
Reeza
Super User

proc corr data=work.have;

     var var1 var2;

    BY GROUP;

run;

View solution in original post

5 REPLIES 5
Reeza
Super User

proc corr data=work.have;

     var var1 var2;

    BY GROUP;

run;

lizzy28
Quartz | Level 8

I guess my question should be: is it possible to format the correlation coefficient result as below:

Groupcorr_coeff
1corr1
2corr2
3corr3

....

up to as many groups as I have.

Thanks again!

SteveDenham
Jade | Level 19

If you use BY group processing, then adding an ODS output statement should accomplish what you need:

proc corr data=work.have;

     var var1 var2;

     BY GROUP;

     ODS OUTPUT PearsonCorr=PearsonCorr;

run;

You can then post process the dataset pearsoncorr to contain only what you need.

Steve Denham

lizzy28
Quartz | Level 8

You guys are AWESOME!

Thank you very much!

SteveDenham
Jade | Level 19

is awesome.  I just read the documentation really, really fast.

Steve Denham

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 5 replies
  • 10083 views
  • 6 likes
  • 3 in conversation