topic Correlation matrix of Proc Corr in SAS in Graphics Programming

Correlation matrix of Proc Corr in SAS

Hank — Wed, 01 May 2013 20:33:33 GMT

Hi,

I have two, probably small, problems with the matrix output in proc corr:

Using Pearson correlation coefficient, does anyone know how I can get the level of significance for my matrix-output using proc corr to appear as asterisks (*,** and *** for p<0.1,p<0.05 and p<0.01 respectively) on the correlation coefficient value?

How do I get the matrix to show only half the matrix (since they are identical row/col vs. col/row)?

If it is possible, with the diagonal line of 1:s (representing correlation of x1 on x1 = 1 etc) to either show a histogram of that particular variable or

a scatter plot with another variable not in the matrix (I am thinking of the residuals of y).

I have searched online for hours without finding anything. Help is much appreciated!

Best regards,

Re: Correlation matrix of Proc Corr in SAS

Rick_SAS — Thu, 02 May 2013 14:23:59 GMT

Because you want to modify the legend and show only half the matrix, I think you will need to use the GTL to hand-code this layout. To get started, look at the examples (and macro code) that Sanjay provides in this blog post: Compact Scatter Plot Matrix - Graphically Speaking

Re: Correlation matrix of Proc Corr in SAS

Hank — Thu, 09 May 2013 10:53:00 GMT

Hi,

Thanks for your link to more information, I have looked at it and seems to be a good step in the right direction.

Sorry for the late replay!

Regards,

Hannes