Statalist


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

st: Re: problem with missing data in a loop


From   Indrit Hoxha <Indrit.Hoxha@mail.uh.edu>
To   "Rodrigo Alfaro A." <ralfaro@bcentral.cl>, statalist@hsphsun2.harvard.edu
Subject   st: Re: problem with missing data in a loop
Date   Fri, 11 Jul 2008 15:58:43 -0500

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/




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