Re: st: Loop over time

[Eric Booth <ebooth@ppri.tamu.edu>]

>


********
clear
inp id   time str5 sex str5 race 
1     2     "M"    "W"
1     3     ""      "" 
2     1     "F"     "H"
3     1    "F"     "B"
3     2     ""      ""
3     3     ""      ""
end

foreach v in sex race {
bys id: replace `v' = `v'[_n-1] if !mi(`v'[_n-1])
}
********

~ Eric
__
Eric A. Booth
Public Policy Research Institute
Texas A&M University
ebooth@ppri.tamu.edu
On Mar 11, 2010, at 10:05 AM, Dmitriy Krichevskiy wrote:

> Hello Statalisters,
> I have a small problem which I seem to be unable to solve. I have a
> large panel dataset. But the creators of the data did not carry
> variables such as race and gender beyond the first entry of an
> individual in the dataset. I am attempting to fix this issue via
> creating a simple loop but get an error message that time series
> operators are not allowed (even though I have declared the dataset
> xtset, and even tried tsset). Below I provide an examples of the data,
> all help is much appreciated, as always. Dmitriy
> 
> id   time sex race ....
> 1     2     M    W
> 1     3      .      .
> 2     1     F     H
> 3     1     F     B
> 3     2     .      .
> 3     3     .      .
> 
> 
> Research Associate, College of Education
> Lumina Foundation Project
> *
> *   For searches and help try:
> *   http://www.stata.com/help.cgi?search
> *   http://www.stata.com/support/statalist/faq
> *   http://www.ats.ucla.edu/stat/stata/




*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/