topic Cronbach's alpha (standardized) using proc corr in SAS Procedures

Cronbach's alpha (standardized) using proc corr

aklr — Fri, 24 Feb 2012 17:27:59 GMT

I am using proc corr to calculate cronbach's alpha for a certain variable list, but the standardized alpha is coming out as a missing value. I'm not sure why this is happening, and I'm wondering if anyone has a macro to calculate Cronbach's alpha so I can go step by step and possibly figure this out. I know that if there is no variance, the standardized alpha cannot be calculated, but there is variance in the variables I am using. Does anyone have any idea what else could be the problem? Below is an image of the ODS output.

Here is the code I used and attached is some sample data:

proc corr alpha nomiss nocorr nosimple;

var cbc42 cbc65 cbc69 cbc75 cbc80 cbc88 cbc102 cbc103 cbc111 cbc51 cbc54 cbc56a

cbc56b cbc56c cbc56d cbc56e cbc56f cbc56g cbc12 cbc14 cbc31 cbc32 cbc33 cbc34

cbc35 cbc45 cbc50 cbc52 cbc71 cbc89 cbc112;

run;

Cronbach's alpha (standardized) using proc corr

art297 — Fri, 24 Feb 2012 17:32:09 GMT

Can you post your code along with some example data?

Cronbach's alpha (standardized) using proc corr

aklr — Fri, 24 Feb 2012 17:47:00 GMT

Alright I just added my code and sample data. Thanks!

Cronbach's alpha (standardized) using proc corr

art297 — Fri, 24 Feb 2012 18:11:11 GMT

You have one variable that doesn't have any variance, namely cbc51.

If you comment that variable out of your var statement you get the results you were expecting:

proc corr data=have alpha nomiss nocorr nosimple;

var cbc42 cbc65 cbc69 cbc75 cbc80 cbc88

cbc102 cbc103 cbc111 /*cbc51*/ cbc54

cbc56a cbc56b cbc56c cbc56d cbc56e

cbc56f cbc56g cbc12 cbc14 cbc31 cbc32

cbc33 cbc34 cbc35 cbc45 cbc50 cbc52

cbc71 cbc89 cbc112;

run;