Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: RE: Specification for a 1/0 variable with consecutive non-missing observations


From   Alejandro Delafuente <alejandro.delafuente@st-antonys.oxford.ac.uk>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: RE: Specification for a 1/0 variable with consecutive non-missing observations
Date   Mon, 13 Jun 2005 10:54:01 +0100 (BST)

Thanks for the comment. In this particular occasion, there is indeed a strong 
case for keeping the data that way.
Alejandro
In message <031173627889364697C50B3B266CBB8A101B5E@GEOGMAIL.geog.ad.dur.ac.uk> 
statalist@hsphsun2.harvard.edu writes:
> This problem was solved. However, 
> an over-arching comment: keeping 
> time series as observations is 
> like running uphill. Can be done, 
> but much more exhausting than the 
> alternative. 
> 
> Unless there are special reasons
> for this structure, consider 
> transposing your data. 
> 
> Nick 
> n.j.cox@durham.ac.uk 
> 
> Alejandro Delafuente
> 
> > I have a time series for 40 years (40 continuos variables) 
> > and am trying to 
> > create a 1/0 variable that indicates 1 (for each row) if at 
> > least 20 variables 
> > in the series have consecutive non-missing values and 0 if 
> > this condition is 
> > not accomplished. I do have more than 20 non-missing values 
> > for most of the 
> > variables per row, but there are gaps (ie, missing values) 
> > between them. Thus I 
> > want to know how many fulfill the condition of 20 non-missing 
> > values in a road. 
> > Any clues as to how can I accomplish this with programming? 
> 
> *
> *   For searches and help try:
> *   http://www.stata.com/support/faqs/res/findit.html
> *   http://www.stata.com/support/statalist/faq
> *   http://www.ats.ucla.edu/stat/stata/
> 

-- 
Alejandro de la Fuente
QEH/Department of International Development
Oxford University
*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   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