For the second dataset look into CASESTOVARS command. Once you have the
second dataset in place you can use SUBSTR to concatenate the 3 texts into 1
field.
HTH,
Luca
www.lucameyer.com
-----Messaggio originale-----
Da: SPSSX(r) Discussion [mailto:
[hidden email]] Per conto di
subscribe SPSSX-l Anonymous
Inviato: mercoledì 18 febbraio 2009 8.40
A:
[hidden email]
Oggetto: Combining Variables
Hello All,
I have different sets of cases with multiple entries. I would like to
combine the entries and have them appear all on one line per case.
sample data:
One case record for each course the students completes:
History 1
History 2
History 3
I would like it to appear two different ways:
1.) History 1 History 2 History 3 (all the coures combine in one field,
some how concatnate the 3 different entries into one variable)
2.) History 1, History 2, History 3 (all separated out in 3 new
fields/columns)
Any help would be great!
Thanks in advance,
Michelle
=====================
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