Date: Mon, 16 Feb 2009 13:19:52 -0600
Reply-To: "Oliver, Richard" <firstname.lastname@example.org>
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: "Oliver, Richard" <email@example.com>
Subject: Re: change varying records into one record per individual
Look at the CASESTOVARS command (or the Restructure Data Wizard on the Data menu).
From: SPSSX(r) Discussion on behalf of Martin Sherman
Sent: Mon 2/16/2009 12:34 PM
Subject: change varying records into one record per individual
Dear list: I have the following situation.
I have students applying to anywhere from 1 to 111 schools. If they apply to one school they only have one record, but if they apply to more schools then they will have a record for each school they apply to. In addition, for each school they apply to I have whether the school accepted them (0 vs 1-yes) and also whether they attended that school (0 vs. 1-yes). I can add up these two variables and come up with missing, 0, 1, or 2. Missing being that they did not apply to that school. 0 is they applied but was not accepted, 1 if the were accepted but did not enroll, and 2 if they were accepted and enrolled. I now want to have a single record for each student so that I have the students status in regard to all 111 schools. Looking across the record I should see missing values, 0's, 1's, and only one 2. What is the most convenient way of converting what I currently have to what I would want to have. Suggestions appreciated. thanks, martin sherman
Martin F. Sherman, Ph.D.
Professor of Psychology
Director of Masters Education, Thesis Track
4501 North Charles Street
222 B Beatty Hall
Baltimore, MD 21210
Phone: 410 617-2417
Fax: 410 617-5341
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
For a list of commands to manage subscriptions, send the command