topic Re: Summary trellis plot/corr matrix code in Graphics Programming

Summary trellis plot/corr matrix code

Copper — Mon, 03 Jun 2013 14:15:42 GMT

I am looking for some code to make my ideal summary display of data for reports. On the diagonal and one triangle would be the output of: proc sgscatter; matrix var1--var5/ diagonal = (historgram normal); So, the scatter plots on the triangle, the histograms with a normal curve for the data users to compare the histograms to on the diagonal. On the other triangle, would be the correlation matrix information: rho and p-values at least. Bonus would be mean and sd on the diagonal and highlighting by significance on the correlations. If found an example form NESUG 2007 (http://www.nesug.org/proceedings/nesug07/np/np18.pdf, figure 4), that is close, but no code was included. There has recently been a similar post, but not quite what I was looking for. Can anyone point me in the correct direction?

Re: Summary trellis plot/corr matrix code

GraphGuy — Wed, 05 Jun 2013 15:54:48 GMT

The graphs in that paper look pretty good! - I'd suggest contact the author and see if they can share the code with you, and that will make a good starting place. Then, once you've got your data plotted with that code, you can post up some specific questions about possibly adding the extras you're wanting.

Re: Summary trellis plot/corr matrix code

Copper — Thu, 06 Jun 2013 03:13:59 GMT

Unfortunately, I have tried that route. The author is no longer at that company and has stopped contributing to NESUG.

Re: Summary trellis plot/corr matrix code

Copper — Tue, 20 Aug 2013 20:37:05 GMT

I am still wondering if you have any hints/ideas on how to re-create this trellis plot plus. Trying to contact the author is fruitless

Re: Summary trellis plot/corr matrix code

GraphGuy — Wed, 21 Aug 2013 12:32:51 GMT

Hopefully some of the ODS Graphics folks will chime in...

Re: Summary trellis plot/corr matrix code

Jay54 — Thu, 22 Aug 2013 20:32:14 GMT

The simple answer is "Yes, you can do this with GTL". And here comes the "But"...

But, you have to do it using GTL LAYOUT LATTICE to define the grid as you want, and then populate each cell with the graph you need. I posted an article in Graphically Speaking in August 20012 on creating a Compact Scatter Plot Matrix. This will get you half the way there to build the lower triangle. You can pick it up from there and add the other features.

Re: Summary trellis plot/corr matrix code

Copper — Wed, 18 Sep 2013 10:14:42 GMT

Thank you Sanjay! I have been playing around with GTL and learning a lot. I also incorporated your histogram on the top row from another blog. This left more room on the diagonal for more summary numbers. I put them in there using the eval function. Below, I have the simple version I have created so far with two variables. I still have one cell empty where I want to put the correlations and the significance of the correlation. That part is stumping me right now. Could you point me in the right direction?