topic Re: Correlation matrix in SAS Enterprise Guide

Correlation matrix

deleted_user — Mon, 02 Jun 2008 21:15:57 GMT

How can I obtain the correlation matrix of several variables in SAS EG? Or a matrix plot like the one provided in minitab?

Re: Correlation matrix

ChrisHemedinger — Tue, 03 Jun 2008 13:11:08 GMT

If you have SAS 9.2, then you can get this with some code and the new ODS graphics cababilities.

[pre]
ods graphics on;
proc corr data=sashelp.cars;
var enginesize weight;
with mpg_city mpg_highway;
run;
ods graphics off;
[/pre]

If you have EG 4.1 and SAS 9.2 on the same Windows machine, this code will work. EG 4.2 will use the ODS graphics automatically within the Correlations task. I've attached a sample of the output plot (if the forum software will allow you to view it...)

Chris

Re: Correlation matrix

Doc_Duke — Tue, 03 Jun 2008 17:17:42 GMT

See this thread from January on how to accomplish the same thing with EG 4.1 and SAS 9.1.3.

http://support.sas.com/forums/thread.jspa?messageID=9148⎼

Re: Correlation matrix

ChrisHemedinger — Tue, 03 Jun 2008 18:03:45 GMT

Doc is right (of course)! Many procedures have ODS graphics support in 9.1.3, but all labeled as "experimental" -- and I couldn't remember which procedures were included.

Here is the relevant doc example for PROC CORR:

http://support.sas.com/onlinedoc/913/getDoc/en/procstat.hlp/corr_sect32.htm

Chris

Re: Correlation matrix

Doc_Duke — Tue, 03 Jun 2008 19:32:13 GMT

And one of the things that changed in 9.2 is the syntax. So, if you are considering going to 9.2 soon you may want to compare the documentation so fewer things "break" when you do the upgrade.