Announcement

Collapse
No announcement yet.
X
Collapse
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts
  • #1

    Adding observations for one group in a panel dataset

    Dear All,

    I have a panel data with N=125 and T=51. For some groups however I have less observations. An example is below:

    Code:
    * Example generated by -dataex-. For more info, type help dataex
clear
input str3 scode str24 country int year
"SLO" "Slovak Republic" 1993
"SLO" "Slovak Republic" 1994
"SLO" "Slovak Republic" 1995
"SLO" "Slovak Republic" 1996
"SLO" "Slovak Republic" 1997
"SLO" "Slovak Republic" 1998
"SLO" "Slovak Republic" 1999
"SLO" "Slovak Republic" 2000
"SLO" "Slovak Republic" 2001
"SLO" "Slovak Republic" 2002
"SLO" "Slovak Republic" 2003
"SLO" "Slovak Republic" 2004
"SLO" "Slovak Republic" 2005
"SLO" "Slovak Republic" 2006
"SLO" "Slovak Republic" 2007
"SLO" "Slovak Republic" 2008
"SLO" "Slovak Republic" 2009
"SLO" "Slovak Republic" 2010
"SLO" "Slovak Republic" 2011
"SLO" "Slovak Republic" 2012
"SLO" "Slovak Republic" 2013
"SLO" "Slovak Republic" 2014
"SLO" "Slovak Republic" 2015
"SLO" "Slovak Republic" 2016
"SLO" "Slovak Republic" 2017
"SLO" "Slovak Republic" 2018
"USA" "United States"   1970
"USA" "United States"   1971
"USA" "United States"   1972
"USA" "United States"   1973
"USA" "United States"   1974
"USA" "United States"   1975
"USA" "United States"   1976
"USA" "United States"   1977
"USA" "United States"   1978
"USA" "United States"   1979
"USA" "United States"   1980
"USA" "United States"   1981
"USA" "United States"   1982
"USA" "United States"   1983
"USA" "United States"   1984
"USA" "United States"   1985
"USA" "United States"   1986
"USA" "United States"   1987
"USA" "United States"   1988
"USA" "United States"   1989
"USA" "United States"   1990
"USA" "United States"   1991
"USA" "United States"   1992
"USA" "United States"   1993
"USA" "United States"   1994
"USA" "United States"   1995
"USA" "United States"   1996
"USA" "United States"   1997
"USA" "United States"   1998
"USA" "United States"   1999
"USA" "United States"   2000
"USA" "United States"   2001
"USA" "United States"   2002
"USA" "United States"   2003
"USA" "United States"   2004
"USA" "United States"   2005
"USA" "United States"   2006
"USA" "United States"   2007
"USA" "United States"   2008
"USA" "United States"   2009
"USA" "United States"   2010
"USA" "United States"   2011
"USA" "United States"   2012
"USA" "United States"   2013
"USA" "United States"   2014
"USA" "United States"   2015
"USA" "United States"   2016
"USA" "United States"   2017
"USA" "United States"   2018
"USA" "United States"   2019
"USA" "United States"   2020
end
    For instance for Slovak Rep I would include observations from 1970 to 1992. I do not want to modify all the other groups. Is there a quick way to do what I need? I cannot find a simple way. I might create a second file, and then I append it, But since I might need to repeat this procedure for another couple of times, I would like to find out a way which avoids creating additional files.

    Thanks in advance
    Tags: panel data
  • #2
    Code:
    * Example generated by -dataex-. For more info, type help dataex
clear
input str3 scode str24 country int year
"SLO" "Slovak Republic" 1993
"SLO" "Slovak Republic" 1994
"SLO" "Slovak Republic" 1995
"SLO" "Slovak Republic" 1996
"SLO" "Slovak Republic" 1997
"SLO" "Slovak Republic" 1998
"SLO" "Slovak Republic" 1999
"SLO" "Slovak Republic" 2000
"SLO" "Slovak Republic" 2001
"SLO" "Slovak Republic" 2002
"SLO" "Slovak Republic" 2003
"SLO" "Slovak Republic" 2004
"SLO" "Slovak Republic" 2005
"SLO" "Slovak Republic" 2006
"SLO" "Slovak Republic" 2007
"SLO" "Slovak Republic" 2008
"SLO" "Slovak Republic" 2009
"SLO" "Slovak Republic" 2010
"SLO" "Slovak Republic" 2011
"SLO" "Slovak Republic" 2012
"SLO" "Slovak Republic" 2013
"SLO" "Slovak Republic" 2014
"SLO" "Slovak Republic" 2015
"SLO" "Slovak Republic" 2016
"SLO" "Slovak Republic" 2017
"SLO" "Slovak Republic" 2018
"USA" "United States"   1970
"USA" "United States"   1971
"USA" "United States"   1972
"USA" "United States"   1973
"USA" "United States"   1974
"USA" "United States"   1975
"USA" "United States"   1976
"USA" "United States"   1977
"USA" "United States"   1978
"USA" "United States"   1979
"USA" "United States"   1980
"USA" "United States"   1981
"USA" "United States"   1982
"USA" "United States"   1983
"USA" "United States"   1984
"USA" "United States"   1985
"USA" "United States"   1986
"USA" "United States"   1987
"USA" "United States"   1988
"USA" "United States"   1989
"USA" "United States"   1990
"USA" "United States"   1991
"USA" "United States"   1992
"USA" "United States"   1993
"USA" "United States"   1994
"USA" "United States"   1995
"USA" "United States"   1996
"USA" "United States"   1997
"USA" "United States"   1998
"USA" "United States"   1999
"USA" "United States"   2000
"USA" "United States"   2001
"USA" "United States"   2002
"USA" "United States"   2003
"USA" "United States"   2004
"USA" "United States"   2005
"USA" "United States"   2006
"USA" "United States"   2007
"USA" "United States"   2008
"USA" "United States"   2009
"USA" "United States"   2010
"USA" "United States"   2011
"USA" "United States"   2012
"USA" "United States"   2013
"USA" "United States"   2014
"USA" "United States"   2015
"USA" "United States"   2016
"USA" "United States"   2017
"USA" "United States"   2018
"USA" "United States"   2019
"USA" "United States"   2020
end

fillin country year
bys country (scode): replace scode= scode[_N]
keep if !_fillin & scode!="SLO" | scode=="SLO" & inrange(year, 1970, 1992)
    Res.:

    Code:
    . sort country year

. l, sepby(country)

     +------------------------------------------+
     | scode           country   year   _fillin |
     |------------------------------------------|
  1. |   SLO   Slovak Republic   1970         1 |
  2. |   SLO   Slovak Republic   1971         1 |
  3. |   SLO   Slovak Republic   1972         1 |
  4. |   SLO   Slovak Republic   1973         1 |
  5. |   SLO   Slovak Republic   1974         1 |
  6. |   SLO   Slovak Republic   1975         1 |
  7. |   SLO   Slovak Republic   1976         1 |
  8. |   SLO   Slovak Republic   1977         1 |
  9. |   SLO   Slovak Republic   1978         1 |
 10. |   SLO   Slovak Republic   1979         1 |
 11. |   SLO   Slovak Republic   1980         1 |
 12. |   SLO   Slovak Republic   1981         1 |
 13. |   SLO   Slovak Republic   1982         1 |
 14. |   SLO   Slovak Republic   1983         1 |
 15. |   SLO   Slovak Republic   1984         1 |
 16. |   SLO   Slovak Republic   1985         1 |
 17. |   SLO   Slovak Republic   1986         1 |
 18. |   SLO   Slovak Republic   1987         1 |
 19. |   SLO   Slovak Republic   1988         1 |
 20. |   SLO   Slovak Republic   1989         1 |
 21. |   SLO   Slovak Republic   1990         1 |
 22. |   SLO   Slovak Republic   1991         1 |
 23. |   SLO   Slovak Republic   1992         1 |
     |------------------------------------------|
 24. |   USA     United States   1970         0 |
 25. |   USA     United States   1971         0 |
 26. |   USA     United States   1972         0 |
 27. |   USA     United States   1973         0 |
 28. |   USA     United States   1974         0 |
 29. |   USA     United States   1975         0 |
 30. |   USA     United States   1976         0 |
 31. |   USA     United States   1977         0 |
 32. |   USA     United States   1978         0 |
 33. |   USA     United States   1979         0 |
 34. |   USA     United States   1980         0 |
 35. |   USA     United States   1981         0 |
 36. |   USA     United States   1982         0 |
 37. |   USA     United States   1983         0 |
 38. |   USA     United States   1984         0 |
 39. |   USA     United States   1985         0 |
 40. |   USA     United States   1986         0 |
 41. |   USA     United States   1987         0 |
 42. |   USA     United States   1988         0 |
 43. |   USA     United States   1989         0 |
 44. |   USA     United States   1990         0 |
 45. |   USA     United States   1991         0 |
 46. |   USA     United States   1992         0 |
 47. |   USA     United States   1993         0 |
 48. |   USA     United States   1994         0 |
 49. |   USA     United States   1995         0 |
 50. |   USA     United States   1996         0 |
 51. |   USA     United States   1997         0 |
 52. |   USA     United States   1998         0 |
 53. |   USA     United States   1999         0 |
 54. |   USA     United States   2000         0 |
 55. |   USA     United States   2001         0 |
 56. |   USA     United States   2002         0 |
 57. |   USA     United States   2003         0 |
 58. |   USA     United States   2004         0 |
 59. |   USA     United States   2005         0 |
 60. |   USA     United States   2006         0 |
 61. |   USA     United States   2007         0 |
 62. |   USA     United States   2008         0 |
 63. |   USA     United States   2009         0 |
 64. |   USA     United States   2010         0 |
 65. |   USA     United States   2011         0 |
 66. |   USA     United States   2012         0 |
 67. |   USA     United States   2013         0 |
 68. |   USA     United States   2014         0 |
 69. |   USA     United States   2015         0 |
 70. |   USA     United States   2016         0 |
 71. |   USA     United States   2017         0 |
 72. |   USA     United States   2018         0 |
 73. |   USA     United States   2019         0 |
 74. |   USA     United States   2020         0 |
     +------------------------------------------+

.
    Last edited by Andrew Musau; 18 Apr 2024, 10:34.

    Comment

    • #3
      Andrew Musau thanks s lot for your help!

      Comment

      Previous Next
      Working...
      X