Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
From | Malin Lundberg Rasmussen <Malin.Lundberg.Rasmussen@ouh.regionsyddanmark.dk> |
To | "'statalist@hsphsun2.harvard.edu'" <statalist@hsphsun2.harvard.edu> |
Subject | st: how to drop duplicate values |
Date | Fri, 14 Sep 2012 13:53:38 +0200 |
My problem: I have a cohort of patients with a severity grade for each eye. I am only going to use one eye, and I want it to be the eye with a certain grade, say 2. I have made the variable long, so the data looks like this: 1. id:1 var*:2 2. Id:1 var*:2 3. Id:2 var*:2 4.Id2: var*:3 I use the command Keep if var*==2 But then I have some patients who have the same grade in both eyes. 1. id:1 var*:2 2. Id:1 var*:2 3. Id:2 var*:2 How do I drop these? (in the above list 1 or 2). Hope anyone has the answers?! Best regards Malin Rasmussen Med venlig hilsen læge, ph.d.-studerende Malin Lundberg Rasmussen Øjenafdeling E, OUH * * 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/