Date: Thu, 13 Dec 2007 21:06:44 +0200
Reply-To: vlad simion <email@example.com>
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: vlad simion <firstname.lastname@example.org>
Subject: Re: How to get rid of duplicates
Content-Type: text/plain; charset=ISO-8859-1
look at the Identify Duplicate Cases in the Data menu.
It looks something like this:
SORT CASES BY Project_ISIS(A) .
MATCH FILES /FILE = * /BY Project_ISIS
/FIRST = PrimaryFirst /LAST = PrimaryLast.
DO IF (PrimaryFirst).
COMPUTE MatchSequence = 1 - PrimaryLast.
COMPUTE MatchSequence = MatchSequence + 1.
FORMAT MatchSequence (f7).
COMPUTE InDupGrp = MatchSequence > 0.
SORT CASES InDupGrp(D).
MATCH FILES /FILE = * /DROP = PrimaryFirst InDupGrp MatchSequence.
VARIABLE LABELS PrimaryLast 'Indicator of each last matching case as
VALUE LABELS PrimaryLast 0 'Duplicate Case' 1 'Primary Case'.
VARIABLE LEVEL PrimaryLast (ORDINAL).
FREQUENCIES VARIABLES = PrimaryLast .
here it finds duplicate for the Project_ISIS variable.
On Dec 13, 2007 8:58 PM, stace swayne <email@example.com> wrote:
> Dear list,
> I'm working with a data set that has duplicate ID's and I would like to
> delete the duplicates, and so far I have been doing it manually, but I
> wanted to know if there is a way to do this with syntax.
> All suggestions are appreciated,
> thank you,
> Never miss a thing. Make Yahoo your homepage.
> 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
Tel: +40 0751945296
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