Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: filling in missing values


From   Thushyanthan Baskaran <baskaran@staff.uni-marburg.de>
To   statalist@hsphsun2.harvard.edu
Subject   st: filling in missing values
Date   Wed, 05 Oct 2005 12:01:43 +0200

Hello!

I have some panel data on educational attainment which is organized in 5-year intervals.
(e.g.


country year edu

UK 1960 10
UK 1965 20
.
.
USA 1960 12
USA 1965 15

etc.)

However, for the particular model I want to estimate, I also need observations in between the intervals (i.e. for 1961, 1962,...). Therefore, I would like to "create" these observations by "extrapolating" them "linearly".

( i.e. by calculating

edu1961 = edu1960 + ((edu1965-edu1960)/5)*1,
edu1962 = edu1960+((edu1965-edu1960)/5)*2 ,
...
edu1997 = edu1995 + ((edu2000-edu1995)/5) * 2 )

Is there some build-in command in STATA for this task or do I have to write a special do-file?

Many thanks in advance for your help...


*
* 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