Correlation matrix

Parx — Fri, 16 Oct 2020 04:41:31 GMT

I am trying to create a correlation matrix using proc corr followed by template as shown in the blog below. I get the matrix similar to the one shown however I wish to make 2 changes:

1) Display the numeric value inside the cell.

2) Change the current lower triangle display to left upper triangle

I have tried various iterations but I am not able to achieve both, please help.

https://blogs.sas.com/content/sasdummy/2013/06/12/correlations-matrix-heatmap-with-sas/

proc template;
define statgraph corrHeatmap;
   dynamic _Title;
    begingraph;
      entrytitle _Title;
      rangeattrmap name='map';
      range -1 - 1 / rangecolormodel=(cxD8B365 cxF5F5F5 cx5AB4AC);
      endrangeattrmap;
      rangeattrvar var=r attrvar=r attrmap='map';
      layout overlay /
        xaxisopts=(display=(line ticks tickvalues))
        yaxisopts=(display=(line ticks tickvalues));
        heatmapparm x = x y = y colorresponse = r /
          xbinaxis=false ybinaxis=false
          name = "heatmap" display=all;
        continuouslegend "heatmap" /
          orient = vertical location = outside title="Pearson Correlation";
      endlayout;
    endgraph;
end;
run;

Re: Correlation matrix

Ksharp — Fri, 16 Oct 2020 12:08:51 GMT

Calling @Rick_SAS

topic Correlation matrix in Graphics Programming

Correlation matrix

Re: Correlation matrix