FW: CTABLES Problem

[Maguin, Eugene]

Peter replied off-list to a question I posed and I think his answer may be
relevant to figuring out how to work his problem--if there is any further
interest now that Jon Peck has posted a python-type method.

With respect to Peter's problem, I had assumed that SubjectID was the person
id, which was really confusing to me but, perhaps, not to others. However,
it is not.

Gene Maguin



-----Original Message-----
From: Peter Cuttance [mailto:[hidden email]]
Sent: Thursday, January 28, 2010 2:10 PM
To: Gene Maguin
Subject: Re: CTABLES Problem

Hi Gene

SUBJECTID is the ID for the subject the student is studying - each
student has responded to a standard survey for each subject they have
studied.

I want a separate set of table results for the survey for each
SUBJECTID - nornally this would be achieved by SPLIT FILE BY
SUBJECTID, but this is not supported in CTABLES.



On 29/01/2010, at 2:45 AM, Gene Maguin wrote:

> Peter,
>
> If you haven't already received useful replies, would you please say
> what
> you are wanting the table to look like. I have used ctables only a
> few times
> so there is a lot I don't know, but in looking at the syntax
> reference (v18,
> p. 490) the BY BY specification creates layers. Could it be that you
> have
> what you want but don't realize it?
>
> Gene Maguin
>
>
>>> Can anyone tell me why the syntax below is producing the table for
>>> only
> one of the values of SUBJECTID?
>
> I am using BY BY SUBJECTID in lieu of SPLIT FILE BY SUBJECTID which
> is not
> supported.
>
> CTABLES
>  /VLABELS VARIABLES=R1_1 R2_1 R3_1 R4_1 R5_1 R6_1 R7_1 R8_1 R9_1 R10_1
> R11_1 R12_1 R13_1 R14_1 R15_1 R17_1 R18_1 R19_1 R20_1 R21_1
>    DISPLAY=LABEL
>  /TABLE (R1_1 [COUNT F40.0, ROWPCT.COUNT PCT40.0]
>  + R2_1 [COUNT F40.0,  ROWPCT.COUNT PCT40.0]
>  + R3_1 [COUNT F40.0, ROWPCT.COUNT PCT40.0]
>  + R4_1 [COUNT F40.0, ROWPCT.COUNT PCT40.0]
>  + R5_1 [COUNT F40.0, ROWPCT.COUNT PCT40.0]
>  + R6_1 [COUNT F40.0, ROWPCT.COUNT PCT40.0]
>  + R7_1 [COUNT F40.0, ROWPCT.COUNT PCT40.0]
>  + R8_1 [COUNT F40.0, ROWPCT.COUNT PCT40.0]
>  + R9_1 [COUNT F40.0, ROWPCT.COUNT PCT40.0]
>  + R10_1 [COUNT F40.0, ROWPCT.COUNT PCT40.0]
>  + R11_1 [COUNT F40.0, ROWPCT.COUNT PCT40.0]
>  + R12_1 [COUNT F40.0, ROWPCT.COUNT PCT40.0]
>  + R13_1 [COUNT F40.0, ROWPCT.COUNT PCT40.0]
>  + R14_1 [COUNT F40.0, ROWPCT.COUNT PCT40.0]
>  + R15_1 [COUNT F40.0, ROWPCT.COUNT PCT40.0]
>  + R17_1 [COUNT F40.0, ROWPCT.COUNT PCT40.0]
>  + R18_1 [COUNT F40.0, ROWPCT.COUNT PCT40.0]
>  + R19_1 [COUNT F40.0, ROWPCT.COUNT PCT40.0]
>  + R20_1 [COUNT F40.0, ROWPCT.COUNT PCT40.0]
>  + R21_1 [COUNT F40.0, ROWPCT.COUNT PCT40.0]) BY BY SUBJECTID
>  /SLABELS POSITION=ROW VISIBLE=YES
>  /CLABELS ROWLABELS=OPPOSITE
>  /CATEGORIES VARIABLES=SUBJECTID R1_1 R2_1 R3_1 R4_1 R5_1 R6_1 R7_1
> R8_1
> R9_1 R10_1 R11_1 R12_1 R13_1 R14_1 R15_1 R17_1 R18_1 R19_1 R20_1 R21_1
> ORDER=A KEY=LABEL MISSING=EXCLUDE EMPTY=EXCLUDE.
>
> Prof Peter Cuttance
> Director
> Research Australia Development and Innovation Institute (radii.org)
> Ph.    [phone]
> Mob. [phone]
> Fax.   [phone]
> Suite 71
> 197 Canterbury Road
> St Kilda West
> Victoria AUSTRALIA 3182
>
> =====================
> 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