Re: Display a correlation matrix showing only the lower half triangular portion in spss

Posted by PRogman on
URL: http://spssx-discussion.165.s1.nabble.com/Display-a-correlation-matrix-showing-only-the-lower-half-triangular-portion-in-spss-tp5740696p5740698.html

Just for info, if you want to format the correlation table in the Output Window there is an extension command FormatCorrelations available. It depends on SPSSINC MODIFY TABLES extension command. It has a bug that removes the Cell Count Row independent of the option setting. The row with p-values can be removed with a 2nd SPSSINC MODIFY TABLES command.

/PR

* Generated by extension command Format Correlation Matrix *.
SPSSINC MODIFY TABLES
  SUBTYPE='Correlations' SELECT=0 DIMENSION=ROWS PROCESS=PRECEDING
  /STYLES customfunction="formatcorrmat.cleancorr(hidecounts=True, hidel=False, lowertri=True, hideinsig=1, emphlarge=1, boldsig=1)".

* Remove rows with p-values *.
SPSSINC MODIFY TABLES
  SUBTYPE = "Correlations" SELECT = 1 DIMENSION = ROWS LEVEL = -1  PROCESS = PRECEDING HIDE=TRUE
  /STYLES     APPLYTO = BOTH.


<quote author="zhanggonwoo">
I want to display only one triangle of a correlation matrix
how can I enter the syntax?
---