How to Set Decimal Output of table function SPSS
Output report has been formattedt for 2 decimal points, but when I export into Word, all decimal values are shown. How can we set the output value to two decimal points only? We have formatted reporting for a client for high volumes of such data and manually adjusting in Word is killing us.
ASKER
Hi richdiesal
TABLES
/FTOTAL $t 'N'
/FORMAT ZERO MISSING('.') /TABLES
( import1 ) BY
(LABELS) > (STATISTICS) + $t by var00001
/STATISTICS COUNT ((F5.0) 'Count' )
CPCT ((PCT7.2) '%' :VAR00001) /TITLE 'import1'.
I can format displaying of the percentage using PCT7.2. Is there any function or sub function to change the value with 2 decimal point? All the process should be automatic.
TABLES
/FTOTAL $t 'N'
/FORMAT ZERO MISSING('.') /TABLES
( import1 ) BY
(LABELS) > (STATISTICS) + $t by var00001
/STATISTICS COUNT ((F5.0) 'Count' )
CPCT ((PCT7.2) '%' :VAR00001) /TITLE 'import1'.
I can format displaying of the percentage using PCT7.2. Is there any function or sub function to change the value with 2 decimal point? All the process should be automatic.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you for your time. At least I don't vast may time looking for solution.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
But if you still want to do it in SPSS itself, you'll need to:
1) In the output pane, double-click on the table you want to format to open Table Edit mode.
2) Select the cells you want to format.
3) Right-click and select Cell Properties.
4) Open the Format Value tab.
5) Select Number category with 2 decimal places and hit OK.
Note that without a strong processor, SPSS will likely grind to a halt when you try to select a lot of cells at the same time (an unfortunate side-effect of the transition of the software to Java).