LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (December 2002)Back to main SPSSX-L pageJoin or leave SPSSX-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Wed, 4 Dec 2002 12:52:02 -0500
Reply-To:     Gil Klajman <klajmang@mail.montclair.edu>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         Gil Klajman <klajmang@mail.montclair.edu>
Organization: Montclair State University
Subject:      Re: select
Comments: To: "Cardwell, Susan" <susan.cardwell@mwsu.edu>
Content-Type: text/plain; charset=us-ascii

Hi, Susan,

First, I'd urge using the SS# and not the name -- people change their names, and different people have the same name.

Second, I assume what you mean by "retention" is that a student enrolls in the Fall of consecutive years, right? Dealing with stop-outs (e.g., enrolled in 1990, not enrolled in 1991 and 1992, re-enrolls in 1993) would be a different matter.

Third, although you suggest you want only people who show up twice <<selecting students who show up twice>> -- I suspect a retention study would want those who are enrolled during six consecutive Fall semesters.

If I understand your need, this should work (without dealing with Spring semester starters):

data list free/Semester (f5.0) SSNO (A11) LANAM (A20) FINAM (A15). begin data. 19905 123-45-1234 doe, j 19915 123-45-1234 doe, j 19905 345-67-6789 smith, m 19905 999-88-7777 smith, m 19905 456-78-9010 bush,g 19915 789-01-2345 claus, s 19925 123-45-1234 Doe-Smithers,Joanie 19935 123-45-1234 Smithers,Joan end data. COMPUTE YEAR = TRUNC (SEMESTER/10). COMPUTE RETAINED = 0. formats year (f4.0)/RETAINED (F1.0). SORT CASES BY ssno (A) year (A). IF ($CASENUM GT 1 AND (SSNO EQ LAG (SSNO)) AND ((YEAR - 1) EQ LAG (YEAR))) RETAINED = 1. SORT CASES BY ssno (A) year (D). IF ($CASENUM GT 1 AND (SSNO EQ LAG (SSNO)) AND ((YEAR + 1) EQ LAG (YEAR))) RETAINED = 1. SORT CASES BY ssno (A) year (A). LIST.

SEMESTER SSNO LANAM FINAM YEAR RETAINED

19905 123-45-1234 doe j 1990 1 19915 123-45-1234 doe j 1991 1 19925 123-45-1234 Doe-Smithers Joanie 1992 1 19935 123-45-1234 Smithers Joan 1993 1 19905 345-67-6789 smith m 1990 0 19905 456-78-9010 bush g 1990 0 19915 789-01-2345 claus s 1991 0 19905 999-88-7777 smith m 1990 0

Hope this helps.

Gil Klajman Sociology Montclair State University Upper Montclair, NJ 07043

"Cardwell, Susan" wrote:

> hello folks. i am doing extensive work on college retention from fall > semester to fall semester for 12 years. i am merging both semesters' data > and selecting students who show up twice. I know there is a way to do this > simply but i can't figure it out. i've tried recount syntax on names and am > able to delete students who have 1 in the 2nd semester but that's as far as > i get. i can't seem to get rid of students who only show up in the first > semester (students not retained). > > Semester SS# name recount > > 19905 123-45-1234 doe, j 1 > 19915 123-45-1234 doe, j 2 > 19905 345-67-6789 smith, m 1 > 19905 456-78-9010 bush,g 1 > 19915 789-01-2345 claus, s 1 > > thank you for your input, > susan


Back to: Top of message | Previous page | Main SPSSX-L page