Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Building capital stock with missing values

    Hello StataList community, it's my first post, so thanks to all those that are answering me and helping me with my master's thesis.

    I am working with panel data for EU28 NUTS2 regions, calculating the capital and knowledge stock according to perpetual inventory method.

    1-year-growth average of Fixed Capital Formation (gr_gfcf_07_00_ calculated in year 2000): (ln(FCFormation)2007 - ln(FCFormation)2000)/7
    Initial capital_stock (capital_stock_ in year 2000): (FCFormation/(gr_gfcf_07_00_ +0.075))
    Next capital stocks (capital_stock_ in 2001<year<2017): ((L.capital_stock_)*(.925)+(FCFormation))


    Unfortunately, there are recurrent missing data for FCFormation so I had to calculate the avg growth for different timespans.
    I am not correctly taking into account this problem when using the solution I propose. In particular, the last code doesn't work, but I'll put all the process to arrive to that, just in case you have a quicker way to do so.

    Here you have the two different types of data: AT33 as complete, and BE1 as having missing data.

    Code:
    clear
    input str5 tl2 int year float(capital_stock_ gr_gfcf_07_00_) long FCFormation
    " AT33" 1990        .         .     .
    " AT33" 1991        .         .     .
    " AT33" 1992        .         .     .
    " AT33" 1993        .         .     .
    " AT33" 1994        .         .     .
    " AT33" 1995        .         .     .
    " AT33" 1996        .         .     .
    " AT33" 1997        .         .     .
    " AT33" 1998        .         .     .
    " AT33" 1999        .         .     .
    " AT33" 2000 47952.36 .03020859  5045
    " AT33" 2001        .         .  4941
    " AT33" 2002        .         .  5000
    " AT33" 2003        .         .  5336
    " AT33" 2004        .         .  4970
    " AT33" 2005        .         .  5724
    " AT33" 2006        .         .  5893
    " AT33" 2007        .         .  6233
    " AT33" 2008        .         .  6454
    " AT33" 2009        .         .  5965
    " AT33" 2010        .         .  6027
    " AT33" 2011        .         .  6702
    " AT33" 2012        .         .  6871
    " AT33" 2013        .         .  7095
    " AT33" 2014        .         .  7268
    " AT33" 2015        .         .  7727
    " AT33" 2016        .         .     .
    " AT33" 2017        .         .     .
    " BE1"  1990        .         .     .
    " BE1"  1991        .         .     .
    " BE1"  1992        .         .     .
    " BE1"  1993        .         .     .
    " BE1"  1994        .         .     .
    " BE1"  1995        .         .     .
    " BE1"  1996        .         .     .
    " BE1"  1997        .         .     .
    " BE1"  1998        .         .     .
    " BE1"  1999        .         .     .
    " BE1"  2000        . .08150125     .
    " BE1"  2001        .         .     .
    " BE1"  2002        .         .     .
    " BE1"  2003        .         .  8492
    " BE1"  2004        .         . 10014
    " BE1"  2005        .         . 10534
    " BE1"  2006        .         . 11321
    " BE1"  2007        .         . 11765
    " BE1"  2008        .         . 12163
    " BE1"  2009        .         . 11434
    " BE1"  2010        .         . 11115
    " BE1"  2011        .         . 11388
    " BE1"  2012        .         . 11460
    " BE1"  2013        .         . 11938
    " BE1"  2014        .         . 12594
    " BE1"  2015        .         . 13475
    " BE1"  2016        .         .     .
    " BE1"  2017        .         .     .
    end

    Code:
    bysort tl2_n (year): replace gr_gfcf_07_00_ = gr_gfcf_07_00_[_n-1] if missing(capital_stock[_n-1]) & year>=2001 & year<=2007
    
    forvalues i=1(1)299 {
        forvalues j=2001(1)2007 {
            quietly replace capital_stock_ = (FCFormation/(gr_gfcf_07_00_ +0.075)) ///
            if year==`j' & tl2_count==`i'
        }
    }
    Code:
    clear
    input str5 tl2 int year float(capital_stock_ gr_gfcf_07_00_) long FCFormation
    " AT33" 1990         .         .     .
    " AT33" 1991         .         .     .
    " AT33" 1992         .         .     .
    " AT33" 1993         .         .     .
    " AT33" 1994         .         .     .
    " AT33" 1995         .         .     .
    " AT33" 1996         .         .     .
    " AT33" 1997         .         .     .
    " AT33" 1998         .         .     .
    " AT33" 1999         .         .     .
    " AT33" 2000  47952.36 .03020859  5045
    " AT33" 2001         .         .  4941
    " AT33" 2002         .         .  5000
    " AT33" 2003         .         .  5336
    " AT33" 2004         .         .  4970
    " AT33" 2005         .         .  5724
    " AT33" 2006         .         .  5893
    " AT33" 2007         .         .  6233
    " AT33" 2008         .         .  6454
    " AT33" 2009         .         .  5965
    " AT33" 2010         .         .  6027
    " AT33" 2011         .         .  6702
    " AT33" 2012         .         .  6871
    " AT33" 2013         .         .  7095
    " AT33" 2014         .         .  7268
    " AT33" 2015         .         .  7727
    " AT33" 2016         .         .     .
    " AT33" 2017         .         .     .
    " BE1"  1990         .         .     .
    " BE1"  1991         .         .     .
    " BE1"  1992         .         .     .
    " BE1"  1993         .         .     .
    " BE1"  1994         .         .     .
    " BE1"  1995         .         .     .
    " BE1"  1996         .         .     .
    " BE1"  1997         .         .     .
    " BE1"  1998         .         .     .
    " BE1"  1999         .         .     .
    " BE1"  2000         . .08150125     .
    " BE1"  2001         . .08150125     .
    " BE1"  2002         . .08150125     .
    " BE1"  2003  54261.55 .08150125  8492
    " BE1"  2004  63986.71 .08150125 10014
    " BE1"  2005  67309.37 .08150125 10534
    " BE1"  2006 72338.086 .08150125 11321
    " BE1"  2007  75175.12 .08150125 11765
    " BE1"  2008         .         . 12163
    " BE1"  2009         .         . 11434
    " BE1"  2010         .         . 11115
    " BE1"  2011         .         . 11388
    " BE1"  2012         .         . 11460
    " BE1"  2013         .         . 11938
    " BE1"  2014         .         . 12594
    " BE1"  2015         .         . 13475
    " BE1"  2016         .         .     .
    " BE1"  2017         .         .     .

    Code:
    forvalues i =1(1)299 {
        forvalues j=2001(1)2017 {
        if capital_stock_[_n-1]!=. ///
        quietly replace capital_stock_=((L.capital_stock_)*(.925)+(FCFormation)) ///
        if year==`j' & tl2_count==`i'
        }
    }
    Last edited by Francesco Androni; 05 Jul 2019, 13:54.
Working...
X