Statalist The Stata Listserver


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

st: Help Creating a Lagged Variable


From   Michael Horowitz <horowitz@fas.harvard.edu>
To   statalist@hsphsun2.harvard.edu
Subject   st: Help Creating a Lagged Variable
Date   Tue, 12 Sep 2006 14:42:58 -0400 (EDT)

To whom it may concern:

I have data set up in country-year format, where there is one observation
per country per year.  There is also a regime change variable that is a 0
if no regime change occurred in that year and a 1 otherwise.  The dataset
runs from 1945-2002.

I am interested in creating a lagged variable for each country for each
year that will take on the value of the start year for the dataset if
no regime change has occurred for that country since the beginning of the
dataset and the year of the regime change if a regime change has occurred.

For example, what I want is something where for the observations for the
United States in 1992, the value of the lagged variable is 1945, since
there has been no regime change in the United States, according to the
definition I am using, since 1945.  However, for China in 1992, the value
of the lagged variable is 1949, since that is the beginning of the
Communist era in China.

However, I am not sure how to create this variable. . any advice would be
*very much* appreciated. . .thank you for your help in advance.

Sincerely,
Michael Horowitz
*
*   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