BookmarkSubscribeRSS Feed
ahoeweler
Calcite | Level 5

Hi everyone,

 

I am running a BCHOICE procedure and was wondering how I can get the covarance and correlation matrix as an actual data output (and not via running stats=corr or stats=cov).

Furthermore I wondered why the stats=cov table, for example, shows covariances and variances of the covariances itself (e.g. REmean"Attrlvl1"). What sense does it make to show the covariance matrix of the covariance? Possibly, my thinking is wrong so I am glad for help.

Lastly, if I want to draw conclusions to how much my parameters are associated what is the best way? The standard BCHOICE output gives me the mean random estimates (e.g. REmeanAttrlvl1) and its covariaces (e.g. RECovAttrlvl1, Attrlvl 2). So I could interpret them just as I always would with covariates (e.g. Attrlvl1 and Attrlvl2 are positiely associated). However, doesn't the correlation between those two give better interpretable results?

How would you proceed?

 

Thank you very much for your help.

 

Best,

Alex

2 REPLIES 2
StatDave
SAS Super FREQ

As with any procedure, you can save any table it produces in a data set by using an ODS OUTPUT statement.  You just need the name of the table you want to save.  If you use the STATS=CORR option, for example, then you could save it as a data set by adding this statement:  

 

ods output corr=mycorr;

 

See this note for more on saving tables. 

ahoeweler
Calcite | Level 5
Hi Dave,
thank you very much for your answer. I do know how to get the output tables, however I have my doubs in interpreting them.
Let's say I have two estimates and their covariance is -1.5 and the standard deviation of lvl1 is 0.02 and for lvl2 0.5.
Now if I used the standard formular to calculate the correlation "correlation=covariance/(SD of Lvl1*SD of Lvl2) I would get a number >-1, which doesn't make sense for a correlation.

Thank you very much for your help.

Best,
Alex

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 ANOVA?

ANOVA, or Analysis Of Variance, is used to compare the averages or means of two or more populations to better understand how they differ. Watch this tutorial for more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 1324 views
  • 2 likes
  • 2 in conversation