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

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

I was just about to moan about why this is not included as an option for the CORRELATIONS command, but then decided to check the latest documentation.  I am pleased to report that in v27, the following options were added to the PRINT subcommand for CORRELATIONS:

  FULL** <-- the default
  LOWER
  NODIAG
  NOMATRIX

It's about time!  I'm currently on v26, but expect to get v27 in a couple months.  


https://www.ibm.com/docs/en/spss-statistics/26.0.0?topic=reference-correlations
https://www.ibm.com/docs/en/spss-statistics/27.0.0?topic=reference-correlations
https://www.ibm.com/docs/en/spss-statistics/28.0.0?topic=reference-correlations


<quote author="PRogman">
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.

zhanggonwoo wrote

I want to display only one triangle of a correlation matrix
how can I enter the syntax?
---