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

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


From   "Nick Cox" <n.j.cox@durham.ac.uk>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: RE: Specification for a 1/0 variable with consecutive non-missing observations
Date   Fri, 10 Jun 2005 19:25:55 +0100

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/



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