Date:         Thu, 13 Dec 2007 21:06:44 +0200
Reply-To:     vlad simion <vlad.simion@gmail.com>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         vlad simion <vlad.simion@gmail.com>
Subject:      Re: How to get rid of duplicates
Comments: To: stace swayne <jladyl@yahoo.com>
In-Reply-To:  <258899.41401.qm@web55811.mail.re3.yahoo.com>
Content-Type: text/plain; charset=ISO-8859-1

Hi Stace,

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.
ELSE.
COMPUTE MatchSequence = MatchSequence + 1.
END IF.
LEAVE MatchSequence.
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
Primary' .
VALUE LABELS PrimaryLast 0 'Duplicate Case' 1 'Primary Case'.
VARIABLE LEVEL PrimaryLast (ORDINAL).
FREQUENCIES VARIABLES = PrimaryLast .
EXECUTE.

here it finds duplicate for the Project_ISIS variable.

hth,
Vlad

On Dec 13, 2007 8:58 PM, stace swayne <jladyl@yahoo.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,
>
>  Stace
>
>
> ---------------------------------
> 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
>



--
Vlad Simion
Data Analyst
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
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD