1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
*(Q) I wonder if there is a way that I can capture those patients with all
	their records (for instance, counter=1,2,and 3 for the same person) and
	delete others who appeared only once and who were real unduplicated cases.

*(A) Posted to SPSSX-L list on 2001/09/21 by rlevesque@videotron.ca.

DATA LIST LIST /ss counter.
BEGIN DATA
1 1
1 2
2 1
3 1
3 2
3 3
4 1
5 1
END DATA.
LIST.

* Objective is to delete ss 2, 4 and 5 because these are true unduplicate records.

MATCH FILES FILE=* /BY=ss /FIRST=first /LAST=last.
* If first=last than that record is both the first and the last (it is UNIQUE).
EXECUTE.
SELECT IF last<>first.