topic Re: proc corr/reg by group in SAS Procedures

proc corr/reg by group

lizzy28 — Mon, 29 Jun 2015 14:44:19 GMT

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

Re: proc corr/reg by group

Reeza — Mon, 29 Jun 2015 15:00:43 GMT

proc corr data=work.have;

var var1 var2;

BY GROUP;

run;

Re: proc corr/reg by group

lizzy28 — Tue, 30 Jun 2015 15:53:37 GMT

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

Group	corr_coeff
1	corr1
2	corr2
3	corr3

....

up to as many groups as I have.

Thanks again!

Re: proc corr/reg by group

SteveDenham — Tue, 30 Jun 2015 17:42:57 GMT

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

Re: proc corr/reg by group

lizzy28 — Tue, 30 Jun 2015 17:58:52 GMT

You guys are AWESOME!

Thank you very much!

Re: proc corr/reg by group

SteveDenham — Tue, 30 Jun 2015 18:01:20 GMT

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

Steve Denham