No; this throws away information on sequences, as indicated by the way
"consecutive".
Nick
[email protected]
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/
