Hi everyone,
Is there a quick way to exclude number of observations in the correlation matrix created by proc corr?
Thanks a lot!
Lizi
Then an alternative is to modify the template that drives proc corr. e.g.:
ods path work.template(update) sashelp.tmplmst; proc template; edit base.corr.stackedmatrix; column (RowName RowLabel) (Matrix) * (Matrix2) /** (Matrix3)*/ * (Matrix4); end; run; proc corr data=sashelp.cars; run; proc template; delete base.corr.stackedmatrix; run;
In the above code I've made a temporary template replacement for proc corr that has * (Matrix3) commented out. Since Matrix3 contains the N values, they won't appear in the output.
HTH,
Art, CEO, AnalystFinder.com
Can you be more specific? I can't see which N you may be referring to.
If you're asking about the N values shown (along with correlations and pvalues) in each cell of the matrix, you can easily eliminate their appearance if you choose to exclude all cases that have any missing values. That way, the N will only show up once, above the correlation matrix.
That can be done by selecting the NOMISS option. e.g.:
proc corr data = sashelp.cars nomiss; run;
HTH,
Art, CEO, AnalystFinder.com
Then an alternative is to modify the template that drives proc corr. e.g.:
ods path work.template(update) sashelp.tmplmst; proc template; edit base.corr.stackedmatrix; column (RowName RowLabel) (Matrix) * (Matrix2) /** (Matrix3)*/ * (Matrix4); end; run; proc corr data=sashelp.cars; run; proc template; delete base.corr.stackedmatrix; run;
In the above code I've made a temporary template replacement for proc corr that has * (Matrix3) commented out. Since Matrix3 contains the N values, they won't appear in the output.
HTH,
Art, CEO, AnalystFinder.com
Thanks a lot, Art!
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 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.