MODIFY TABLES with Summarize

[la volta statistics]

 

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: [phone]
Fax: [phone]
email: [hidden email] 
Web: www.lavolta.ch

 

[Jon K Peck]

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.

HTH,

Jon Peck
Senior Software Engineer, IBM
[hidden email]
312-651-3435



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

---

 
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: [phone]
Fax: [phone]
email: mailto:schmidhauser@...
Web: www.lavolta.ch