LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (December 2010)Back to main SPSSX-L pageJoin or leave SPSSX-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Mon, 20 Dec 2010 08:41:14 -0700
Reply-To:   Jon K Peck <>
Sender:   "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:   Jon K Peck <>
Subject:   Re: MODIFY TABLES with Summarize
Comments:   To: la volta statistics <>
In-Reply-To:   <>
Content-Type:   multipart/alternative;

Two problems: the table subtype is "Report" not "Summarize". You can check the subtypes by right clicking on the table entry in the outline and

choosing Copy OMS Subtype.

Second, pivot tables have to have row labels, but you can suppress these by making the row label width zero. This command will do that. SPSSINC MODIFY TABLES subtype='Report' /WIDTHS ROWLABELS=1 ROWLABELWIDTHS=0.


Jon Peck Senior Software Engineer, IBM 312-651-3435

From: la volta statistics <> To: SPSSX-L@LISTSERV.UGA.EDU Date: 12/20/2010 08:00 AM Subject: [SPSSX-L] MODIFY TABLES with Summarize Sent by: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>

Dear all I am looking for a help to hide the column with 'cases' (the column most to the left) in my example. I tried Modify Tables, but couldn't find a way

to get rid of this column. I am using SPSS 18. TIA, Christian * Example: New File. DATA LIST FREE / Gender Hosp (2F8.0). BEGIN DATA 1 3 1 2 1 2 2 1 2 3 2 2 END DATA. SUMMARIZE /TABLES=Gender Hosp /FORMAT=VALIDLIST NOCASENUM TOTAL /TITLE='Table 1\n Gender Hospital' /MISSING=VARIABLE /CELLS=None. SPSSINC MODIFY TABLES subtype='Summarize' SELECT= 'Cases' DIMENSION= COLUMNS PROCESS = PRECEDING HIDE=TRUE. ********************************** la volta statistics Christian Schmidhauser, Dr.phil.II Weinbergstrasse 108 CH-8006 Zürich Tel: +41 (043) 233 98 01 Fax: +41 (043) 233 98 02 email: Web:


Back to: Top of message | Previous page | Main SPSSX-L page