Date:         Wed, 4 Dec 2002 08:48:42 -0600
Reply-To:     "Cardwell, Susan" <susan.cardwell@mwsu.edu>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         "Cardwell, Susan" <susan.cardwell@mwsu.edu>
Subject:      select
Content-Type: text/plain; charset="iso-8859-1"

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