Date:         Fri, 14 Nov 2003 14:54:03 +0100
Reply-To:     Rob Grim <rob.grim@UVT.NL>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         Rob Grim <rob.grim@UVT.NL>
Subject:      round_column_percentages_in_tables
Content-Type: text/plain; charset="iso-8859-1"

*Hi,
*Can someone give a hint on the following:
*I want to round my column-percentages to two digits exactly without
displaying the %token (see example table syntax below).
changing the format from (pct5.1) to for example (pct2.0) doesn't work.

*Can this be done?


TABLES
  /FORMAT BLANK MISSING('.')
  /GBASE=CASES
  /FTOTAL= $t1 "Total" $t2 "Total" $t000004 "Total" $t000003
  "Total"
  /TABLE=trans1+ $t1 +trans2 +trans3 +trans4 BY gesl_02 + $t2 + soi03 +
sbc03+pvso+ rv110+ rv78+ v109+ rv102+ rv106
  /STATISTICS  cpct(gesl_02 soi03 sbc03 pvso rv110 rv78 v109 rv102 rv106
(pct5.1) 'Col %':gesl_02 soi03 sbc03 pvso rv110 rv78       v109 rv102 rv106)
  /TABLE=trans1+ $t1 +trans2 +trans3 +trans4 BY gesl_02 + $t2 + soi03 +
sbc03+pvso+ rv110+ rv78+ v109+ rv102+ rv106
  /stats unw count(gesl_02 soi03 sbc03 pvso rv110 rv78 v109 rv102 rv106
(F5.0 )).