Converting yearly data to halfyearly

Luca Manzoni

Join Date: Dec 2020

Posts: 5
#1

Converting yearly data to halfyearly

29 Dec 2020, 15:05

Can someone help me to convert my annual data into semi annual using cubic spline function?

This is my dataset:
location year debt_gdp pd_gdp
BEL 1996 129 -4.002527
BEL 1997 124.3 -2.151257
BEL 1998 119.2 -1.024874
BEL 1999 115.4 -.6483495
BEL 2000 109.6 -.0792975
BEL 2001 108.2 .2328486
BEL 2002 105.4 -.0436953
BEL 2003 101.7 -1.864152
BEL 2004 97.2 -.2386971
BEL 2005 95.1 -2.714993
BEL 2006 91.5 .2395806
BEL 2007 87.3 .0664399
BEL 2008 93.2 -1.095345
BEL 2009 100.2 -5.430989
BEL 2010 100.3 -4.087706
BEL 2011 103.5 -4.330078
BEL 2012 104.8 -4.318382
BEL 2013 105.5 -3.129378
BEL 2014 107 -3.055682
BEL 2015 105.2 -2.413671
BEL 2016 105 -2.363113
BEL 2017 102 -.6864632
BEL 2018 99.8 -.7937546
DEU 1996 57.8 -3.570403
DEU 1997 58.9 -2.9421
DEU 1998 59.5 -2.566893
DEU 1999 60.1 -1.71922
DEU 2000 59.1 -1.584665
DEU 2001 57.9 -3.025445
DEU 2002 59.7 -3.874993
DEU 2003 63.3 -3.704201
DEU 2004 65 -3.334158
DEU 2005 67.3 -3.319437
DEU 2006 66.7 -1.653152
DEU 2007 64 .260887
DEU 2008 65.5 -.1163562
DEU 2009 73 -3.150511
DEU 2010 82.3 -4.378646
DEU 2011 79.7 -.8813987
DEU 2012 81.1 .009325
DEU 2013 78.7 .0399808
DEU 2014 75.6 .5795527
....
Tags: None
Luca Manzoni

Join Date: Dec 2020

Posts: 5
#2

29 Dec 2020, 15:16

Thank you in advance!
Comment

Andrew Musau

Join Date: Oct 2014
Posts: 10153

30 Dec 2020, 14:59

Please use dataex to present data examples in the future (FAQ Advice #12). The following uses mipolate from SSC by Nick Cox.

Code:

* Example generated by -dataex-. To install: ssc install dataex
clear
input str4 location int year double(debt_gdp pd_gdp)
"BEL"  1996   129 -4.002527
"BEL"  1997 124.3 -2.151257
"BEL"  1998 119.2 -1.024874
"BEL"  1999 115.4 -.6483495
"BEL"  2000 109.6 -.0792975
"BEL"  2001 108.2  .2328486
"BEL"  2002 105.4 -.0436953
"BEL"  2003 101.7 -1.864152
"BEL"  2004  97.2 -.2386971
"BEL"  2005  95.1 -2.714993
"BEL"  2006  91.5  .2395806
"BEL"  2007  87.3  .0664399
"BEL"  2008  93.2 -1.095345
"BEL"  2009 100.2 -5.430989
"BEL"  2010 100.3 -4.087706
"BEL"  2011 103.5 -4.330078
"BEL"  2012 104.8 -4.318382
"BEL"  2013 105.5 -3.129378
"BEL"  2014   107 -3.055682
"BEL"  2015 105.2 -2.413671
"BEL"  2016   105 -2.363113
"BEL"  2017   102 -.6864632
"BEL"  2018  99.8 -.7937546
"DEU"  1996  57.8 -3.570403
"DEU"  1997  58.9   -2.9421
"DEU"  1998  59.5 -2.566893
"DEU"  1999  60.1  -1.71922
"DEU"  2000  59.1 -1.584665
"DEU"  2001  57.9 -3.025445
"DEU"  2002  59.7 -3.874993
"DEU"  2003  63.3 -3.704201
"DEU"  2004    65 -3.334158
"DEU"  2005  67.3 -3.319437
"DEU"  2006  66.7 -1.653152
"DEU"  2007    64   .260887
"DEU"  2008  65.5 -.1163562
"DEU"  2009    73 -3.150511
"DEU"  2010  82.3 -4.378646
"DEU"  2011  79.7 -.8813987
"DEU"  2012  81.1   .009325
"DEU"  2013  78.7  .0399808
"DEU"  2014  75.6  .5795527
end

expand 2, g(new)
replace year= cond(new, halfyearly(string(year)+"h2", "YH"), halfyearly(string(year)+"h1", "YH"))
format year %th
foreach var in debt_gdp pd_gdp{
    replace `var'=. if new
}
*ssc install mipolate
foreach var in debt_gdp pd_gdp{
    bys location (year): mipolate `var' year, spline gen(`var'_s)
}

Res.:

Code:

 . l, sepby(location)

     +-------------------------------------------------------------------------+
     | location     year   debt_gdp      pd_gdp   new   debt_gd~s     pd_gdp_s |
     |-------------------------------------------------------------------------|
  1. |      BEL   1996h1        129   -4.002527     0         129    -4.002527 |
  2. |      BEL   1996h2          .           .     1   126.74878   -3.0262244 |
  3. |      BEL   1997h1      124.3   -2.151257     0       124.3    -2.151257 |
  4. |      BEL   1997h2          .           .     1   121.60365   -1.4682356 |
  5. |      BEL   1998h1      119.2   -1.024874     0       119.2    -1.024874 |
  6. |      BEL   1998h2          .           .     1   117.44911   -.81356922 |
  7. |      BEL   1999h1      115.4   -.6483495     0       115.4    -.6483495 |
  8. |      BEL   1999h2          .           .     1   112.31241   -.36682436 |
  9. |      BEL   2000h1      109.6   -.0792975     0       109.6    -.0792975 |
 10. |      BEL   2000h2          .           .     1   108.60127    .08987837 |
 11. |      BEL   2001h1      108.2    .2328486     0       108.2     .2328486 |
 12. |      BEL   2001h2          .           .     1   107.05752    .36226471 |
 13. |      BEL   2002h1      105.4   -.0436953     0       105.4    -.0436953 |
 14. |      BEL   2002h2          .           .     1   103.68115   -1.2380526 |
 15. |      BEL   2003h1      101.7   -1.864152     0       101.7    -1.864152 |
 16. |      BEL   2003h2          .           .     1   99.305389    -.8958462 |
 17. |      BEL   2004h1       97.2   -.2386971     0        97.2    -.2386971 |
 18. |      BEL   2004h2          .           .     1   95.997296   -1.5690898 |
 19. |      BEL   2005h1       95.1   -2.714993     0        95.1    -2.714993 |
 20. |      BEL   2005h2          .           .     1   93.717927   -1.5227252 |
 21. |      BEL   2006h1       91.5    .2395806     0        91.5     .2395806 |
 22. |      BEL   2006h2          .           .     1   88.668494    .52164781 |
 23. |      BEL   2007h1       87.3    .0664399     0        87.3     .0664399 |
 24. |      BEL   2007h2          .           .     1   89.195596   -.16034934 |
 25. |      BEL   2008h1       93.2   -1.095345     0        93.2    -1.095345 |
 26. |      BEL   2008h2          .           .     1   97.449123   -3.4872787 |
 27. |      BEL   2009h1      100.2   -5.430989     0       100.2    -5.430989 |
 28. |      BEL   2009h2          .           .     1   100.48291   -5.1564046 |
 29. |      BEL   2010h1      100.3   -4.087706     0       100.3    -4.087706 |
 30. |      BEL   2010h2          .           .     1   101.64423   -3.9315291 |
 31. |      BEL   2011h1      103.5   -4.330078     0       103.5    -4.330078 |
 32. |      BEL   2011h2          .           .     1   104.49017   -4.5372793 |
 33. |      BEL   2012h1      104.8   -4.318382     0       104.8    -4.318382 |
 34. |      BEL   2012h2          .           .     1   104.98258   -3.6858115 |
 35. |      BEL   2013h1      105.5   -3.129378     0       105.5    -3.129378 |
 36. |      BEL   2013h2          .           .     1   106.50449   -3.0550046 |
 37. |      BEL   2014h1        107   -3.055682     0         107    -3.055682 |
 38. |      BEL   2014h2          .           .     1   106.18695   -2.7177243 |
 39. |      BEL   2015h1      105.2   -2.413671     0       105.2    -2.413671 |
 40. |      BEL   2015h2          .           .     1   105.13521   -2.4850496 |
 41. |      BEL   2016h1        105   -2.363113     0         105    -2.363113 |
 42. |      BEL   2016h2          .           .     1   103.72222   -1.5430994 |
 43. |      BEL   2017h1        102   -.6864632     0         102    -.6864632 |
 44. |      BEL   2017h2          .           .     1   100.72593   -.51101248 |
 45. |      BEL   2018h1       99.8   -.7937546     0        99.8    -.7937546 |
 46. |      BEL   2018h2          .           .     1           .            . |
     |-------------------------------------------------------------------------|
 47. |      DEU   1996h1       57.8   -3.570403     0        57.8    -3.570403 |
 48. |      DEU   1996h2          .           .     1   58.410175   -3.2161797 |
 49. |      DEU   1997h1       58.9     -2.9421     0        58.9      -2.9421 |
 50. |      DEU   1997h2          .           .     1   59.206975   -2.7798009 |
 51. |      DEU   1998h1       59.5   -2.566893     0        59.5    -2.566893 |
 52. |      DEU   1998h2          .           .     1   59.899423   -2.1641746 |
 53. |      DEU   1999h1       60.1    -1.71922     0        60.1     -1.71922 |
 54. |      DEU   1999h2          .           .     1   59.795331   -1.4519212 |
 55. |      DEU   2000h1       59.1   -1.584665     0        59.1    -1.584665 |
 56. |      DEU   2000h2          .           .     1   58.294252   -2.2258521 |
 57. |      DEU   2001h1       57.9   -3.025445     0        57.9    -3.025445 |
 58. |      DEU   2001h2          .           .     1   58.377662   -3.5980131 |
 59. |      DEU   2002h1       59.7   -3.874993     0        59.7    -3.874993 |
 60. |      DEU   2002h2          .           .     1   61.595099   -3.8819629 |
 61. |      DEU   2003h1       63.3   -3.704201     0        63.3    -3.704201 |
 62. |      DEU   2003h2          .           .     1   64.229442   -3.4592686 |
 63. |      DEU   2004h1         65   -3.334158     0          65    -3.334158 |
 64. |      DEU   2004h2          .           .     1   66.224634   -3.4155488 |
 65. |      DEU   2005h1       67.3   -3.319437     0        67.3    -3.319437 |
 66. |      DEU   2005h2          .           .     1   67.484524   -2.6772911 |
 67. |      DEU   2006h1       66.7   -1.653152     0        66.7    -1.653152 |
 68. |      DEU   2006h2          .           .     1   65.212272   -.55563915 |
 69. |      DEU   2007h1         64     .260887     0          64      .260887 |
 70. |      DEU   2007h2          .           .     1   64.028888    .46761167 |
 71. |      DEU   2008h1       65.5   -.1163562     0        65.5    -.1163562 |
 72. |      DEU   2008h2          .           .     1   68.447175   -1.4997394 |
 73. |      DEU   2009h1         73   -3.150511     0          73    -3.150511 |
 74. |      DEU   2009h2          .           .     1   78.657412   -4.3756173 |
 75. |      DEU   2010h1       82.3   -4.378646     0        82.3    -4.378646 |
 76. |      DEU   2010h2          .           .     1   81.560677   -2.7688371 |
 77. |      DEU   2011h1       79.7   -.8813987     0        79.7    -.8813987 |
 78. |      DEU   2011h2          .           .     1   80.112379   -.06431092 |
 79. |      DEU   2012h1       81.1     .009325     0        81.1      .009325 |
 80. |      DEU   2012h2          .           .     1   80.414806   -.02346424 |
 81. |      DEU   2013h1       78.7    .0399808     0        78.7     .0399808 |
 82. |      DEU   2013h2          .           .     1   77.065898    .26219128 |
 83. |      DEU   2014h1       75.6    .5795527     0        75.6     .5795527 |
 84. |      DEU   2014h2          .           .     1           .            . |
     +-------------------------------------------------------------------------+

.

Last edited by Andrew Musau; 30 Dec 2020, 15:06.

Announcement

Converting yearly data to halfyearly

Comment

Comment