Date:         Sun, 31 Jan 1999 22:33:31 GMT
Reply-To:     Richard F Ulrich <wpilib+@PITT.EDU>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@UGA.CC.UGA.EDU>
From:         Richard F Ulrich <wpilib+@PITT.EDU>
Organization: University of Pittsburgh
Subject:      Re: SPSS table problems: basic question

goalie (goalie@unixg.ubc.ca) wrote:
: How do you get SPSS 7.0 to produce a table for each of 150 subjects that
: contains a) subjects score on each of 14 tests b) group X's means on each
: of the same 14 tests alongside same 14 tests c) group Y's means on the
: same 14 tests alongside the group X means.
 
I think the result will be ugly and you won't want it, once
you get it, but here is one way:
 
 1) Create 14 dummy variables that have values when group is X,
and 14 more for when group is Y;  missing otherwise...  creating
xmean1 to xmean14  and ymean1 to ymean14.
 2) Aggregate for all the dummies into one output file, x_y.sav
 3) Match files for the original with   TABLE= 'x_y.sav'  instead
of FILE=  in order to add the means to each of the original lines.
 4) Use  REPORT to format the output of the lines.
 
--
Rich Ulrich, biostatistician                wpilib+@pitt.edu
http://www.pitt.edu/~wpilib/index.html   Univ. of Pittsburgh
 
P.S.    don't know about the other question.