I am trying to use the output from a covariance matrix in an optimization model. I want the output to look like the PROC CORR output, but instead get the output with type, obs, and name. Is there a way to create a new dataset that matches the PROC CORR output? If there is a altogether better way to do this, please let me know. Thank you.
ods select Cov PearsonCorr;
proc corr data=ret_monthly noprob outp=CovMat cov nocorr;
var EOG_monret CAT_monret DE_monret LNG_monret GD_monret;
Title "Covariance Matrix";
run;
proc print data=CovMat NOOBS;
Title "Covariance Matrix";
run;
Your other option is:
ods output pearsoncorr=p;
The data set has one set of variable for r, p, and n. If you want to stack things to look like they do in the output, you will need to use a DATA step.
What exactly do you mean by "a new dataset that matches the proc corr output"? Please provide an example.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how to run multiple linear regression models with and without interactions, presented by SAS user Alex Chaplin.
Find more tutorials on the SAS Users YouTube channel.