-----Original Message-----
From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU]On Behalf Of
Craig H. Ziegler
Sent: Saturday, October 27, 2001 8:13 PM
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: Need SPSS Tables Help


Dear All,

The past few months I have been working on an item analysis application
where I am trying to condense the formatting of
SPSS output.   I currently have variables that are called CI1, Q1, CI2,
Q2, CI3, Q3, etc...  The CI1, CI2, CI3, etc.. are variables
that indicate whether a variable is right or wrong and are coded

   -3=Blank       -2=Right   -1=Wrong

with value labels specified as such, i.e.,

value label ci1 -3'blank' -2'right' -1'wrong'.

The variables values for q1, q2, etc.. are 0, 1, 2, 3, 4,
where the values represent responses on a test.

The following tables code will almost produce the desired results I want:
variable label ci1 'q1' / ci2 'q2' /ci3 'q3'.
   * Table of Frequencies.
TABLES
  /FORMAT BLANK MISSING('.') /TABLES
  (LABELS)  BY
  ( ci1 + q1 + ci2 + q2 + ci3 + q3 + ci4 + q4 +
    ci5 + q5 + ci6 + q6 + ci7 + q7 + ci8 + q8 + ci9 + q9 +
    ci10 + q10 + ci11 + q11 + ci12 + q12 + ci13 + q13 +
    ci14 + q14 + ci15 + q15 + ci16 + q16 + ci17 + q17 +
    ci18 + q18 + ci19 + q19 + ci20 + q20)
  /STATISTICS COUNT ((F5.0) '' )
       CPCT ((PCT7.1) '') .

Once I get this table and transpose the rows and columns using the
pivot table feature I get the following output:

         Right Wrong Blank  0     1     2     3     4
    Q1    51    23
          68%   31%
                                  1     2    51     20
                                  1%    3%   69%    27%

    Q2    69    5
          93%   7%
                           69     5
                           93%    7%
    Q3    69    5
          93%   6%
                                  2     3    69
                                  3%    4%   93%

etc..

What I would really like to get is:

         Right Wrong Blank  0     1     2     3     4

    Q1    51    23                1     2    51     20
          68%   31%               1%    3%   69%    27%

    q2    69    5          69     5
          93%   7%         93%    7%

    q3    69    5       1         2     3    69
          93%   7%                3%    4%   93%

I have spent considerable time trying to work with
Tables -> Basic Tables, Tables -> Tables of Frequencies
Tables -> General Tables, but have been unsuccesful.
Any input would be appreciated.

Thanks,

Craig

--AAA02840.1004286431/cronus.per.clw.csiro.au--