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]
Re: st: Repeated rows for the same study participant
From
Nick Cox <[email protected]>
To
[email protected]
Subject
Re: st: Repeated rows for the same study participant
Date
Fri, 30 Sep 2011 14:22:58 +0100
. help duplicates
, duplicates drop
On Fri, Sep 30, 2011 at 2:12 PM, Ziad Khatib <[email protected]> wrote:
> I have dataset for a longitudinal dataset (at study enrolment, labeled
> visit 1 and 4 follow-up time points).
> Sometimes there is more than one row per patient per time point. I am
> trying to clean the dataset to keep it one row per patient per time
> point.
>
> Example below for the current dataset (ID numbers 101 and 103 were
> repeated at visits 1 and 2 respectively)
>
> visit id HPV6 HPV18
> 1 101 1 0
> 1 101 1 0
> 1 102 0 0
> 1 103 1 1
> 2 100 1 1
> 2 101 1 0
> 2 103 1 0
> 2 103 1 0
> etc...
>
*
* 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/