Statalist The Stata Listserver


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: loop breaks if missing value is encountered


From   "Olga Gorbachev Melloni" <olga_gorbachev@hotmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   st: loop breaks if missing value is encountered
Date   Mon, 17 Jul 2006 11:42:25 -0400

I am trying to run rolling prais regressions with a panel data set,
rolling command seems not to be working well for this purpose (I
already posted with that question and so far no solution was
found).

I wrote a small loop to do the same, the problem is that I have an
unbalanced panel dataset and as soon as missing observation is
encountered, the loop brakes (I tried 'tsfill, full' and replacing
all missing with 99999999, but then prais regression doesn't like
that either and the loop breaks again).

Is there a way to write the loop to skip those missing observations,
put a missing value into the "anwswer" and continue on?

Here is the main code:

forvalues y=1973/1996 {
  gen resid`y'=.
  gen pred`y'=.
        forvalues i=1/3824 {
           prais r exp if (year>=`y'-14 & year<=`y') & s==`i'
          predict r if e(sample), resid
           predict p if e(sample)
           replace resid`y'=r if (year>=`y'-4 & year<=`y') & s==`i'
           replace pred`y'=p if (year>=`y'-4 & year<=`y') & s==`i'
          drop r p
        }
}



Olga Gorbachev Melloni
Ph.D. student in Economics at Columbia University
(212)866-6091
502 W122 Street, apt. 62
NY, NY 10027


*
*   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