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

st: RE: problem with missing data in a loop

From   "Rodrigo Alfaro A." <>
To   <>
Subject   st: RE: problem with missing data in a loop
Date   Thu, 10 Jul 2008 09:17:08 -0400


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 {



[] En nombre de Indrit Hoxha
Enviado el: Jueves, 10 de Julio de 2008 12:35 a.m.
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: 

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:

*   For searches and help try:

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