Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
From | Jeph Herrin <stata@spandrel.net> |
To | statalist@hsphsun2.harvard.edu |
Subject | Re: st: Identifying unique values within duplicate IDs |
Date | Wed, 27 Mar 2013 16:45:36 -0400 |
try bys ID (PHQ9) : gen byte tagged=PHQ[1]!=PHQ[_N] cheers, Jeph On 3/27/2013 4:33 PM, Rebecca M Sacks wrote:
Hi all! I'm dealing with a large dataset that had some errors occur when data were being recorded. Although each ID should only have one record, most of them have two. Anyway, I'm trying to get a list of IDs where the ID variable is a duplicate but the values for a second variable (PHQ9 score) are different within the duplicate ID. Any advice would be greatly appreciated. Thanks, Rebecca Sacks * * For searches and help try: * http://www.stata.com/help.cgi?search * http://www.stata.com/support/faqs/resources/statalist-faq/ * http://www.ats.ucla.edu/stat/stata/
* * For searches and help try: * http://www.stata.com/help.cgi?search * http://www.stata.com/support/faqs/resources/statalist-faq/ * http://www.ats.ucla.edu/stat/stata/