Date:         Mon, 19 Jul 2010 15:00:30 -0400
Reply-To:     "Lacay, Phebe" <placay@RARITANVAL.EDU>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         "Lacay, Phebe" <placay@RARITANVAL.EDU>
Subject:      Re: SUBSTR into new variable
Content-Type: text/plain; charset="us-ascii"

Thank you Sonia for your response.  I was hoping for something
simpler...maybe using an IfAny( or using the comma as an INDEX..??
anyone else have any suggestions?
Thanks,
Phebe

-----Original Message-----
From: Lacay, Phebe
Sent: Thursday, July 15, 2010 10:42 AM
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: SUBSTR into new variable

Hi All,

I am looking to do some type of SUBSTR to get the following results for
the data in the variable 'Race'.  Race has multiple items separated by a
comma.  I would like to see each item in race separated into the
appropriate variables (r1 to r5).

Race    -->     r1      r2      r3      r4      r5
1,2,3           1       1       1       0       0
1,5,            1       0       0       0       1
2,4             0       1       0       1       0

Any help would be much appreciated.

Thank you,




Phebe Lacay
Assistant Director of Institutional Research Raritan Valley Community
College P.O. Box 3300 Somerville, NJ 08876
908.526.1200 x 8355
908.429.0034 (fax)
placay@raritanval.edu

=====================
To manage your subscription to SPSSX-L, send a message to
LISTSERV@LISTSERV.UGA.EDU (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