Hi Raphael,
If I understand you right, e.g
by id count, sort: gen N=_N
drop if count==0 & N>=3
would help.
Greetings,
Alex
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
Raphael
*
* 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/
--
Dipl.-Volkswirt
Alexander Staus
Institute for Agricultural Policy and Markets (420B)
University of Hohenheim
D-70593 Stuttgart
Germany
Ph: +49 (0)711-459-24304
Fax: +49 (0)711-459-22601
Email: [email protected]
Homepage: http://www.uni-hohenheim.de/marktlehre
*
* 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/
