Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
st: Identifying differences in partial duplicates
From
David Puddicombe <[email protected]>
To
"[email protected]" <[email protected]>
Subject
st: Identifying differences in partial duplicates
Date
Fri, 17 Dec 2010 16:01:37 +0000
I am working with a dataset which contains 80,000 observations and 100 variables. There are a few hundred partial duplicates which need to be investigated to determine whether they are duplicate observations with slightly different data or unique observations.
I can identify the partial duplicates but not which variables have different values for the very similar observations.
dups b1 b5 b6 c1 d2_dt d3 d4 t2 d5_dt d6 d7 d13 d14, key(id lcm_id tcode xcode ppob) verbose
Can anyone suggest an efficient method of highlighting the difference(s) between the potentially duplicated observations.
Thanks you
David
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/