The FORMAT CORRELATIONS (Utilities > Format Correlation Matrix) extension command, which requires SPSSINC MODIFY TABLES, has several options for formatting a correlation matrix, including bolding significant correlations.
For STATS CORRELATIONS, you can do this using SPSSINC MODIFY TABLES with a small custom function. Here is an example. First, the custom function is defined; then SPSSINC MODIFY TABLES is used to apply it. This just colors the correlations column, but it could easily be modified to color the whole row. It is setting the background color to yellow, but it could do other forms of highlighting.
* Run this once in a session.
begin program python3.
import customstylefunctions
def colorsig(obj, i, j, numrows, numcols, section, more,custom):
lower = float(obj.GetUnformattedValueAt(i,j))
upper = float((obj.GetUnformattedValueAt(i,j+1)))
prod = lower * upper
if prod >= 0:
obj.SetBackgroundColorAt(i, 0, customstylefunctions.RGB((255, 255, 0)))
end program.
STATS CORRELATIONS VARIABLES=bdate educ salary salbegin
/WITH VARIABLES=jobtime prevexp
/OPTIONS CONFLEVEL=95 METHOD=FISHER
/MISSING EXCLUDE=YES PAIRWISE=YES.
SPSSINC MODIFY TABLES subtype="CICORRELATIONS"
SELECT="Lower C.I." DIMENSION= COLUMNS LEVEL = -1 PROCESS = PRECEDING
/STYLES APPLYTO=DATACELLS
CUSTOMFUNCTION="__main__.colorsig".
--