In general, formats in pivot tables are based on the input
variables and/or the type of statistic. For correlations, the number of
decimals is fixed. However, you can use the SPSSINC MODIFY TABLES extension
command available from SPSS Developer Central (www.spss.com/devcentral) to set the
decimals to whatever you want or you could do this with an autoscript.
Here is an example setting the Sig and Correlation Coefficient
values to show four decimals.
CORRELATIONS
/VARIABLES=engine horse mpg
/PRINT=TWOTAIL NOSIG
/MISSING=PAIRWISE.
SPSSINC MODIFY TABLES
subtype="'Correlations'"
SELECT="Sig."
"Correlation"
REGEXP=YES DIMENSION= ROWS
LEVEL = -1 PROCESS =
PRECEDING
/STYLES
APPLYTO=DATACELLS
CUSTOMFUNCTION="customstylefunctions.SetDecimalPlaces(decimals=4)".
The command includes a dialog
box interface, but you have to know about the SetDecimalPlaces function, which
you would find documented in the customstylefunctions module that accompanies
the command.
HTH,
Jon Peck
From: SPSSX(r) Discussion
[mailto:[hidden email]] On Behalf Of Handel, Richard W.
Sent: Tuesday, September 08, 2009 9:41 AM
To: [hidden email]
Subject: [SPSSX-L] number of decimal places (output)
Hi All,
When I run a simple Pearson correlation in PASW 17.0.2, the
output seems to default to three decimal places. Is there a simple way to
decrease or increase the number of decimal places in the output? I know you can
double-click on the actual table value to see the unrounded correlation value,
but is there a simpler way to force the output to fewer (i.e., 2) or more
(e.g., 4) decimal places?
Thanks,
Rick
Richard W. Handel, Ph.D.
Associate Professor
Department of Psychiatry and Behavioral Sciences
Eastern Virginia Medical School
825 Fairfax Avenue, Hofheimer Hall
Norfolk, VA 23507
Phone (757)-446-7992
Locked
