Date:         Tue, 27 Apr 2004 07:23:13 -0800
Reply-To:     "Grove, Rhonda K." <GroveRK@ci.anchorage.ak.us>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         "Grove, Rhonda K." <GroveRK@ci.anchorage.ak.us>
Subject:      Re: Multiple Response Sets PAIRED subcommand  SPSS 11.5
Content-Type: text/plain; charset="us-ascii"

Hi Jan,
Thanks very much for your suggestions.  You're right, at least if I can
get the right numbers using Multiple Response Paired, I can always work
with the old text tables. (I just thought it was strange that that
PAIRED command wasn't incorporated into the CTABLES module, it seems
pretty useful to me.)

I've never worked with a data file with multiple rows for each record,
but maybe that's a better way to handle this problem.  I'm considering
restructuring the file this way, i.e. each charge and disposition (this
is prosecution data) would have its own row.  If you or anyone has any
general thoughts or advice along these lines I'd love to hear them.  
Thanks again, this is a great forum & I love to read it.
Rhonda  


Date:    Wed, 21 Apr 2004 15:28:04 +0200
From:    Spousta Jan <JSpousta@CSAS.CZ>
Subject: Re: Multiple Response Sets PAIRED subcommand  SPSS 11.5

Hi Rhonda,
I have only SPSS Base here, so I am not able to answer your question.
But you can still transform the old text tables into Excel. There are
more possibilities:
1) Paste them into Word and process it using a Word-macro (replace bars
between cells with tabelators, drop non-useful lines etc.
2) Save the table as an ASCII file. (You can e.g. paste it in Notepad
and save). Write a program in Perl or another programming language which
will transform it into a tab delimited file.
3) Save it as an ASCII file. Read it using a text wizard in Excel and
edit by hand or using a macro.
4) Save it as an ASCII file. Read it using a text wizard in SPSS, edit
it using commands and save it as an Excel file (you can use the syntax
later for similar tables, if it will be needed). Which way to go depends
on your possibilities and needs. HTH Jan

-----Original Message-----
From: Grove, Rhonda K. [mailto:GroveRK@ci.anchorage.ak.us]
Sent: Tuesday, April 20, 2004 8:39 PM
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: Multiple Response Sets PAIRED subcommand SPSS 11.5


Hi all,
This is my first time to post, so I hope this makes sense.
I'm working with multiple response sets and I want to pair the variables
for table output.  For example, my first MR set is $charge made of
charge1, charge2, and charge3 and my second is $disp made up of  disp1
disp2, disp3.  Disposition 1 applies to Charge 1, Disposition 2 to
Charge 2, etc.  I know that I can use the PAIRED subcommand with MULT
RESPONSE command to get the output I want (syntax below), but the output
is 'older-vintage' SPSS and difficult to work with (spaces instead of
tabs and exporting to Excel doesn't seem to help).

MULT RESPONSE GROUPS = disp 'Disposition' (disp1 disp2 disp3 (0,20))
                                ch 'Charge' (ch1 ch2 ch3 (0,50))
                /TABLES = ch BY disp (PAIRED).

Does anybody know if there's a way in SPSS 11.5 Custom Tables to pair
the multiple response sets? Thanks for any help / advice, Rhonda Grove

------------------------------