Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

RE: st: Data Management


From   "Nick Cox" <n.j.cox@durham.ac.uk>
To   <statalist@hsphsun2.harvard.edu>
Subject   RE: st: Data Management
Date   Tue, 18 Nov 2008 11:17:31 -0000

No; this throws away information on sequences, as indicated by the way
"consecutive". 

Nick 
n.j.cox@durham.ac.uk 

Alexander Staus

If I understand you right, e.g

by id count, sort: gen N=_N
drop if count==0 & N>=3

would help.

Raphael Fraser schrieb:

> I have longitudinal data with "id" as unique identifier, "timevar" as
> the time variable and an outcome variable I call "count." The timevar
> contains the elapsed time in minutes. I would like to exclude all
> zeros where there are 3 or more consecutive zeros for each person. Can
> anyone help?
>
> id  timevar count
> 1    1         56
> 1    2         2
> 1    3         0
> 1    4         0
> 1    5         0
> 1    6         0
> 1    7         5
> 1    8         0
> 1    9         0
> 2    1         230
> 2    2         0
> 2    3         0
> 2    4        19

*
*   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/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index