Combining Variables

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Combining Variables

subscribe SPSSX-l Anonymous-2
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
Reply | Threaded
Open this post in threaded view
|

R: Combining Variables

Luca Meyer-3
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