check for cases that have the same value of a variable

[jimjohn]

can someone plz help me with this. three of my variables are ID, IssueDate, and Age. I am checking for bad data, and I want to make sure that for the same values of ID and IssueDate, the same age does not appear more than once. Is there a way in SPSS that after sorting my data by these three variables, i can find (and remove) the cases which have the same value of age? Thanks!

[Marks, Jim]

After sorting use

COMPUTE dupe EQ age = LAG (age) and id = lag(id) and issuedate =
lag(issuedate).



-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
jimjohn
Sent: Tuesday, May 27, 2008 10:23 AM
To: [hidden email]
Subject: check for cases that have the same value of a variable

can someone plz help me with this. three of my variables are ID,
IssueDate, and Age. I am checking for bad data, and I want to make sure
that for the same values of ID and IssueDate, the same age does not
appear more than once. Is there a way in SPSS that after sorting my data
by these three variables, i can find (and remove) the cases which have
the same value of age? Thanks!
--
View this message in context:
http://www.nabble.com/check-for-cases-that-have-the-same-value-of-a-vari
able-tp17492937p17492937.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (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

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (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