st: Re: problem with missing data in a loop

[Indrit Hoxha <Indrit.Hoxha@mail.uh.edu>]

Thank you. I had to include some other steps to these commands, and finally 
it worked.

----- Original Message ----- 
From: "Rodrigo Alfaro A." <ralfaro@bcentral.cl>
To: <statalist@hsphsun2.harvard.edu>
Cc: "Indrit Hoxha" <Indrit.Hoxha@mail.uh.edu>
Sent: Thursday, July 10, 2008 8:17 AM
Subject: RE: problem with missing data in a loop



///

Did you try something like this?

forvalues i=1/130 {
forvalues j=1980/2005 {
cap reg y x if id==`i' & year==`j'
if _rc==0 {
reg
}
}
}

Rodrigo.




________________________________

De: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] En nombre de Indrit Hoxha
Enviado el: Jueves, 10 de Julio de 2008 12:35 a.m.
Para: statalist@hsphsun2.harvard.edu
Asunto: st: problem with missing data in a loop


I am sorry for sending many times but my code was broken somehow in the
previous emails.


I have a panel dataset with countries and years. I am trying to do some
overlapping  regressions for every country in windows of 5 years. I want
these 5 years to be overlapping so for example for United States, I want
the first regression to be for 1980-1984, the second 1981-1985, third
1982-1986 and goes on like this. I have used loop within a loop to do
this. As you can see from the do file below

"i" stands for countries and "j" stands for years




local i=1

while `i'<131 {

local j=1980

while `j'< 2006 {

reg y  x1 x2 x3  if cc==`i' & (year==`j'|year ==`j'+1|year ==`j'+2|year
==`j'+3|year ==`j'+4)

local j= `j'+1

}

local i= `i'+1

}



However I have missing data for some countries and years, so when the
loop starts if it does not find any data for the first country and/or
first group of years the do file stops.

I have tried to use capture command, but still was unable to make the
loop work.
Could someone help me out here, how should I do these regressions.
I'd really appreciate any help .



Indrit Hoxha

Univesity of Houston




********************************************************************************
ADVERTENCIA: La  informaci�n  contenida  en  esta  transmisi�n, y  en 
cualquier archivo  adjunto, est�  sujeta a reserva legal conforme a la 
normativa aplicable  al  Banco  Central  de  Chile, y  no  puede  ser usada 
o difundida  por personas distintas  de  su o sus destinatarios. Si usted ha 
recibido esta transmisi�n por error,  por  favor  notifique  inmediatamente 
al remitente respondiendo por este mismo medio y elim�nela de su sistema.
El  Banco Central de Chile no se har� responsable de la exactitud y 
veracidad de la informaci�n contenida en este mensaje, as�  como  de su 
modificaci�n, copia, divulgaci�n  o  reenv�o,  total  o  parcial.   Su  uso 
no  autorizado puede ser sancionado de conformidad con las leyes chilenas.
El  Banco  Central  de  Chile  transmite  sus decisiones a trav�s de 
comunicados oficiales, los  que  pone  a  disposici�n  del p�blico en su 
p�gina de Internet: www.bcentral.cl


DISCLAIMER: The information  contained  in  this  email or any attached 
file, is subject to legal  privilege  pursuant  to the laws and regulations 
applicable to the Central  Bank  of  Chile , and may not be used or 
disseminated by any person other  than  its  intended recipients. If you 
have received this transmission in error, please  notify  the sender 
immediately by reply to this email address and delete it from your system.
The Central Bank  of  Chile shall not be liable for the accuracy or 
authenticity of the contents of this message, whether amended, copied, 
forwarded or disclosed in  any  form, in  whole  or  in part.  Please note 
that unauthorized use may be penalized  in  conformity  with  the  Chilean 
law.
The Central  Bank of Chile communicates its decisions by  official releases, 
and
makes them available to the public in its WebPages: www.bcentral.cl 
*
*   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/