Statalist


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

Re: st: Data Management


From   Alexander Staus <alexander.staus@uni-hohenheim.de>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: Data Management
Date   Tue, 18 Nov 2008 11:41:48 +0100

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: alexander.staus@uni-hohenheim.de
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/



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