table in SPSS 18

[Philip Sinclair]

Dear List,

I have a table showing the number of patients with heart disease present given factors,
sex (1,2), age (1,2) and cholestrol level (1,2,3,4).
It is 4x4 with number of 'success' and trials in each cell, i.e also can be viewed as 8x4
table, and I hope the table is clearly reproduced below. The question is, how can I get
such a table as output from SPSS 18?

                                Cholestrol
SEX     AGE             1       2       3       4
1       1       present 13      18      40      57
                N       340     408     421     362

        2       present 13      33      35      49
                N       123     176     174     183

2       1       present 6       5       10      18
                N       542     552     412     357

        2       present 9       12      21      48
                N       58      135     218     395


Best regards,

Dr Philip A. Sinclair
Dept. of Computing and Mathematics,
Manchester Metropolitan University,
Manchester M1 5GD.
Tel [phone]

Before acting on this email or opening any attachments
you should read the Manchester Metropolitan University’s
email disclaimer available on its website
http://www.mmu.ac.uk/emaildisclaimer

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[Maguin, Eugene]

Hi Philip,

Perhaps you have already figured out how to do this or got a good answer
from somebody else but if not this command sequence produces your desired
output given the example dataset following.

variable level present(scale).
ctables /table sex > age by cholesterol by present [SUM totaln]/
   SLABELS POSITION=ROW.

A key element is that present be declared to be 'scale'. Note also that
present is coded 0 or 1.



data list / id 1-2 sex 4 age 6 cholesterol 8 present 10.
begin data
01 1 1 1 0
02 1 2 1 0
03 2 1 1 0
04 2 2 1 0
05 1 1 2 0
06 1 2 2 0
07 2 1 2 0
08 2 2 2 0
09 1 1 3 0
10 1 2 3 0
11 2 1 3 0
12 2 2 3 0
13 1 1 4 0
14 1 2 4 0
15 2 1 4 0
16 2 2 4 0
17 1 1 1 1
18 1 2 1 1
19 2 1 1 1
20 2 2 1 1
21 1 1 2 1
22 1 2 2 1
23 2 1 2 1
24 2 2 2 1
25 1 1 3 1
26 1 2 3 1
27 2 1 3 1
28 2 2 3 1
29 1 1 4 1
30 1 2 4 1
31 2 1 4 1
32 2 2 4 1
end data.


Gene Maguin




-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Philip Sinclair
Sent: Wednesday, September 15, 2010 4:21 AM
To: [hidden email]
Subject: table in SPSS 18

Dear List,

I have a table showing the number of patients with heart disease present
given factors,
sex (1,2), age (1,2) and cholestrol level (1,2,3,4).
It is 4x4 with number of 'success' and trials in each cell, i.e also can be
viewed as 8x4
table, and I hope the table is clearly reproduced below. The question is,
how can I get
such a table as output from SPSS 18?

                                Cholestrol
SEX     AGE             1       2       3       4
1       1       present 13      18      40      57
                N       340     408     421     362

        2       present 13      33      35      49
                N       123     176     174     183

2       1       present 6       5       10      18
                N       542     552     412     357

        2       present 9       12      21      48
                N       58      135     218     395


Best regards,

Dr Philip A. Sinclair
Dept. of Computing and Mathematics,
Manchester Metropolitan University,
Manchester M1 5GD.
Tel [phone]

Before acting on this email or opening any attachments
you should read the Manchester Metropolitan University's
email disclaimer available on its website
http://www.mmu.ac.uk/emaildisclaimer

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD