Date:         Wed, 17 Apr 2002 17:49:56 -0400
Reply-To:     John Finn <jfinn@ALBANY-NY.ORG>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         John Finn <jfinn@ALBANY-NY.ORG>
Content-Type: text/plain; charset="iso-8859-1"

I hope this makes sense.  I am trying to take information from a data base
with multi-value fields and convert it to a conventional database format
using SPSS.  I am able to extract the information and what I get is multiple
records with the same case number for (one record for each multi-value
entry).  I want to merge all this information into one field.  Basically, I
want to turn this:

Case#                   Field D
001                     x
001                     y
001                     z
002                     x
003                     y

into this:

Case#                   Field D
001                     xyz
002                     x
003                     y

Does this make sense?  Does anyone have any ideas for syntax code to do
this?
If so please email me.

John Finn
jfinn@albany-ny.org