Question (Percentage)- Final Period- Initial Value

Carlo Lazzaro

Join Date: Apr 2014
Posts: 17084

#16

22 Jan 2022, 12:04

Hugo:
the possible fix is to prefix everything for both -NAMES_STD1- and -industry-:

Code:

. bysort NAMES_STD1: g industry=runiform()

. replace industry=0 if industry<0.5


. replace industry=1 if industry>=0.5


. bysort NAMES_STD1 industry : g ln_1970=ln(val_added_worker) if Year==1970


. replace ln_1970=0 if ln_1970==.
(98 real changes made)

. gen check=0 if ln_1970!=0

. sort NAMES_STD1 industry check

. drop check

. bysort NAMES_STD1 industry : replace ln_1970=sum( ln_1970)


. bysort NAMES_STD1 Year industry : gen perc_wanted= lval_added_worker/ln_1970
(74 missing values generated)

. list

         +------------------------------------------------------------------------------------------------+
     | NAMES_~1   Year   MANVA_Q05      MANEMP   val_ad~r   lval_a~r   industry    ln_1970   perc_w~d |
     |------------------------------------------------------------------------------------------------|
  1. |        1   1950   40415.975   1603.2487    25.2088   3.227193          0     3.6253   .8901864 |
  2. |        1   1951   41425.265   1640.9271   25.24504    3.22863          1          0          . |
  3. |        1   1952   38394.621   1690.1175   22.71713   3.123119          1          0          . |
  4. |        1   1953   37586.314   1578.1245   23.81708   3.170403          0     3.6253   .8745214 |
  5. |        1   1954   40819.545   1721.9975   23.70477   3.165676          0     3.6253   .8732176 |
     |------------------------------------------------------------------------------------------------|
  6. |        1   1955   44536.581   1839.9443    24.2054   3.186576          0     3.6253   .8789826 |
  7. |        1   1956   43852.174   1870.1773   23.44814   3.154791          1          0          . |
  8. |        1   1957   46044.045   1939.5803   23.73918   3.167127          0     3.6253   .8736178 |
  9. |        1   1958   48480.769    2042.999    23.7302   3.166749          1          0          . |
 10. |        1   1959   42206.058   1931.8565   21.84741   3.084082          0     3.6253   .8507109 |
     |------------------------------------------------------------------------------------------------|
 11. |        1   1960   45347.839   2050.8917   22.11128   3.096088          0     3.6253   .8540224 |
 12. |        1   1961   49732.739    2087.512   23.82393   3.170691          0     3.6253   .8746008 |
 13. |        1   1962   47484.481   1990.2596   23.85844   3.172138          0     3.6253   .8750001 |
 14. |        1   1963   45300.003   1927.1958   23.50566   3.157241          1          0          . |
 15. |        1   1964   52156.393   2029.1571   25.70348   3.246626          1          0          . |
     |------------------------------------------------------------------------------------------------|
 16. |        1   1965    58789.55   2094.2724   28.07159   3.334758          0     3.6253    .919857 |
 17. |        1   1966    58661.99   2051.6872   28.59207    3.35313          1          0          . |
 18. |        1   1967   59092.507   1979.7033   29.84917   3.396157          0     3.6253   .9367933 |
 19. |        1   1968   63477.407   2005.6411   31.64944    3.45472          1          0          . |
 20. |        1   1969   71034.241   2049.4972   34.65935   3.545568          0     3.6253   .9780065 |
     |------------------------------------------------------------------------------------------------|
 21. |        1   1970   75568.342   2013.2231     37.536     3.6253          0     3.6253          1 |
 22. |        1   1971   83125.176   2009.7845   41.36024    3.72232          1          0          . |
 23. |        1   1972   87659.276   2012.0142   43.56792   3.774321          1          0          . |
 24. |        1   1973   91139.921   2004.7825   45.46125    3.81686          1          0          . |
 25. |        1   1974   96474.387   2068.4354   46.64124   3.842485          1          0          . |
     |------------------------------------------------------------------------------------------------|
 26. |        1   1975   94015.236   1984.9229   47.36468   3.857877          1          0          . |
 27. |        1   1976   91177.754     1982.92   45.98156    3.82824          1          0          . |
 28. |        1   1977   98290.376   2038.0339   48.22804   3.875941          0     3.6253   1.069136 |
 29. |        1   1978   87961.941   2079.3635   42.30234   3.744843          0     3.6253   1.032974 |
 30. |        1   1979   96928.384   2029.6833   47.75542   3.866093          1          0          . |
     |------------------------------------------------------------------------------------------------|
 31. |        1   1980   93220.741   2078.7117   44.84544   3.803222          0     3.6253   1.049078 |
 32. |        1   1981   82051.926   1924.8148   42.62848   3.752522          0     3.6253   1.035093 |
 33. |        1   1982   79849.125   1781.2045   44.82872   3.802849          1          0          . |
 34. |        1   1983   85735.087   1895.7093   45.22586   3.811669          1          0          . |
 35. |        1   1984   88002.392   2104.9178   41.80799   3.733088          0     3.6253   1.029732 |
     |------------------------------------------------------------------------------------------------|
 36. |        1   1985   79287.943    1939.158   40.88782   3.710832          1          0          . |
 37. |        1   1986   88292.659     2090.74   42.23034   3.743139          0     3.6253   1.032505 |
 38. |        1   1987   89147.333   2100.2995   42.44506    3.74821          0     3.6253   1.033903 |
 39. |        1   1988   85131.978   2097.5279   40.58681   3.703443          1          0          . |
 40. |        1   1989   78659.032   2068.8763   38.02017   3.638117          0     3.6253   1.003535 |
     |------------------------------------------------------------------------------------------------|
 41. |        1   1990   75749.915   2081.9236   36.38458   3.594145          0     3.6253   .9914061 |
 42. |        1   1991   83503.259   2105.2073    39.6651   3.680472          1          0          . |
 43. |        1   1992   93169.138   2140.8638   43.51941   3.773207          1          0          . |
 44. |        1   1993   97497.336    2041.901   47.74832   3.865944          1          0          . |
 45. |        1   1994   101884.36   1977.5463    51.5206   3.941982          1          0          . |
     |------------------------------------------------------------------------------------------------|
 46. |        1   1995   94584.768   1732.2203    54.6032   4.000093          0     3.6253   1.103382 |
 47. |        1   1996   100687.26   1693.1115   59.46877   4.085451          1          0          . |
 48. |        1   1997   109901.59   1802.9866    60.9553   4.110141          0     3.6253   1.133738 |
 49. |        1   1998    111933.4   1774.2771   63.08677   4.144511          0     3.6253   1.143219 |
 50. |        1   1999   103058.35   1674.4346   61.54815    4.11982          1          0          . |
     |------------------------------------------------------------------------------------------------|
 51. |        1   2000   99118.205   1614.1982   61.40399   4.117475          0     3.6253   1.135761 |
 52. |        1   2001   91821.135   1558.8799     58.902   4.075875          0     3.6253   1.124286 |
 53. |        1   2002   81761.927   1456.1682   56.14868   4.028003          1          0          . |
 54. |        1   2003   94817.008   1626.6699   58.28903   4.065414          0     3.6253   1.121401 |
 55. |        1   2004   106172.35    1833.868    57.8953   4.058636          1          0          . |
     |------------------------------------------------------------------------------------------------|
 56. |        1   2005   114091.12   1879.9724   60.68766   4.105741          1          0          . |
 57. |        1   2006   124249.44   1965.8034   63.20543    4.14639          0     3.6253   1.143737 |
 58. |        1   2007   133692.07   2058.3685    64.9505   4.173625          1          0          . |
 59. |        1   2008   139769.61   2080.6019   67.17749   4.207338          1          0          . |
 60. |        1   2009   139003.54    1979.562   70.21934   4.251624          1          0          . |
     |------------------------------------------------------------------------------------------------|
 61. |        1   2010   152664.48    2097.053   72.79953    4.28771          1          0          . |
 62. |        1   2011   169423.55   2163.6021   78.30624   4.360627          0     3.6253   1.202832 |
 63. |        2   1950   1876.5492   117.17787   16.01454   2.773497          1   3.219797   .8613888 |
 64. |        2   1951   1978.8063   117.08796   16.90017   2.827324          0          0          . |
 65. |        2   1952   1990.3013   115.31912   17.25907   2.848338          1   3.219797   .8846327 |
     |------------------------------------------------------------------------------------------------|
 66. |        2   1953   1887.8047   121.50604   15.53671   2.743206          0          0          . |
 67. |        2   1954   2225.2291   140.88023   15.79518   2.759705          1   3.219797   .8571053 |
 68. |        2   1955   2358.1394   139.40724   16.91547   2.828229          0          0          . |
 69. |        2   1956    2172.065   132.99345   16.33212   2.793134          0          0          . |
 70. |        2   1957   1535.2932   93.036428   16.50207   2.803486          1   3.219797   .8707026 |
     |------------------------------------------------------------------------------------------------|
 71. |        2   1958   1679.4589    91.09551   18.43624   2.914319          0          0          . |
 72. |        2   1959   1679.4589   89.236725   18.82027   2.934934          0          0          . |
 73. |        2   1960   1808.3564   91.724016   19.71519    2.98139          1   3.219797   .9259557 |
 74. |        2   1961   1812.1475   89.479892   20.25201   3.008254          0          0          . |
 75. |        2   1962   2005.4938   97.349679   20.60093   3.025336          0          0          . |
     |------------------------------------------------------------------------------------------------|
 76. |        2   1963   2126.8091   98.381181   21.61805   3.073529          1   3.219797   .9545721 |
 77. |        2   1964   2316.3486   105.74071   21.90593   3.086757          1   3.219797   .9586807 |
 78. |        2   1965   2530.1315   110.92662   22.80906   3.127158          1   3.219797   .9712282 |
 79. |        2   1966    2843.092   120.69012   23.55696   3.159421          1   3.219797   .9812484 |
 80. |        2   1967   2959.9012   125.82938   23.52313   3.157984          0          0          . |
     |------------------------------------------------------------------------------------------------|
 81. |        2   1968   3034.8354   120.70283   25.14303   3.224581          1   3.219797   1.001486 |
 82. |        2   1969   3270.6577   135.63049   24.11447   3.182812          0          0          . |
 83. |        2   1970   3446.9735   137.75198   25.02304   3.219797          1   3.219797   .9999999 |
 84. |        2   1971   3543.9472   141.66909   25.01567   3.219502          1   3.219797   .9999084 |
 85. |        2   1972   3733.4867   149.18258   25.02629   3.219927          0          0          . |
     |------------------------------------------------------------------------------------------------|
 86. |        2   1973   3919.7884   154.53408    25.3652   3.233378          1   3.219797   1.004218 |
 87. |        2   1974   4363.1865   169.12794   25.79814   3.250303          1   3.219797   1.009474 |
 88. |        2   1975    4629.598   176.09729      26.29   3.269189          1   3.219797    1.01534 |
 89. |        2   1976   5015.2426   186.54709   26.88459   3.291553          0          0          . |
 90. |        2   1977   5363.6268    195.7458   27.40098   3.310579          1   3.219797   1.028195 |
     |------------------------------------------------------------------------------------------------|
 91. |        2   1978   5607.6821   202.70465    27.6643   3.320143          0          0          . |
 92. |        2   1979   5764.1755   207.74629   27.74623     3.3231          1   3.219797   1.032084 |
 93. |        2   1980   5836.8332   212.43403   27.47598   3.313312          0          0          . |
 94. |        2   1981   5384.4738    194.4481   27.69106    3.32111          0          0          . |
 95. |        2   1982   4718.7617   171.91522   27.44819     3.3123          1   3.219797   1.028729 |
     |------------------------------------------------------------------------------------------------|
 96. |        2   1983   4727.5296   166.88967   28.32728   3.343825          0          0          . |
 97. |        2   1984   4775.9155    167.1502    28.5726   3.352448          0          0          . |
 98. |        2   1985   4378.4367   158.22174   27.67279    3.32045          0          0          . |
 99. |        2   1986   4462.5438   155.27146   28.74027   3.358299          0          0          . |
100. |        2   1987   4574.5782   162.16061   28.21017   3.339683          0          0          . |
     +------------------------------------------------------------------------------------------------+

.

.

Last edited by Carlo Lazzaro; 22 Jan 2022, 12:24.

Kind regards,
Carlo
(Stata 18.0 SE)

Comment

Hugo Rocha

Join Date: Feb 2021
Posts: 288

#17

22 Jan 2022, 12:17

Is it possible with this data? In this case industry would be isic.

Thank you so much! (my apologies for this extension of the question)

[CODE]

Code:

* Example generated by -dataex-. To install: ssc install dataex
clear
input int(country year) str2 isic str3 isiccomb byte sourcecode long(Establishments Employment) double(Wages Output ValueAdded GrossFixed) long FemaleEmployees float(val_per_worker lval_per_worker)
4 1973 "33" "33"  3 .     0 . . . . . . .
4 1973 "18" "18A" 3 .   725 . . . . . . .
4 1973 "32" "31A" 3 .     . . . . . . . .
4 1973 "25" "25"  3 .   360 . . . . . . .
4 1973 "30" "29C" 3 .     . . . . . . . .
4 1973 "D"  "D"   3 . 22743 . . . . . . .
4 1973 "26" "26"  3 .  1295 . . . . . . .
4 1973 "16" "16"  3 .     0 . . . . . . .
4 1973 "24" "24"  3 .   259 . . . . . . .
4 1973 "19" "18A" 3 .     . . . . . . . .
4 1973 "15" "15"  3 .  4321 . . . . . . .
4 1973 "29" "29C" 3 .     0 . . . . . . .
4 1973 "36" "20C" 3 .     . . . . . . . .
4 1973 "23" "23"  3 .     0 . . . . . . .
4 1973 "17" "17"  3 . 12555 . . . . . . .
4 1973 "31" "31A" 3 .     0 . . . . . . .
4 1973 "35" "34A" 3 .     . . . . . . . .
4 1973 "34" "34A" 3 .     0 . . . . . . .
4 1973 "20" "20C" 3 .  1941 . . . . . . .
4 1973 "21" "21"  3 .     0 . . . . . . .
4 1973 "22" "22"  3 .  1287 . . . . . . .
4 1973 "27" "27"  3 .     0 . . . . . . .
4 1973 "28" "28"  3 .     0 . . . . . . .
4 1974 "29" "29C" 3 .     0 . . . . . . .
4 1974 "35" "34A" 3 .     . . . . . . . .
4 1974 "24" "24"  3 .  3281 . . . . . . .
4 1974 "28" "28"  3 .     0 . . . . . . .
4 1974 "25" "25"  3 .   427 . . . . . . .
4 1974 "D"  "D"   3 . 28121 . . . . . . .
4 1974 "23" "23"  3 .     0 . . . . . . .
4 1974 "21" "21"  3 .     0 . . . . . . .
4 1974 "16" "16"  3 .     0 . . . . . . .
4 1974 "22" "22"  3 .  1326 . . . . . . .
4 1974 "31" "31A" 3 .     0 . . . . . . .
4 1974 "17" "17"  3 . 14243 . . . . . . .
4 1974 "27" "27"  3 .     0 . . . . . . .
4 1974 "34" "34A" 3 .     0 . . . . . . .
4 1974 "30" "29C" 3 .     . . . . . . . .
4 1974 "26" "26"  3 .  1235 . . . . . . .
4 1974 "33" "33"  3 .     0 . . . . . . .
4 1974 "15" "15"  3 .  4845 . . . . . . .
4 1974 "20" "20C" 3 .  2044 . . . . . . .
4 1974 "36" "20C" 3 .     . . . . . . . .
4 1974 "18" "18A" 3 .   720 . . . . . . .
4 1974 "19" "18A" 3 .     . . . . . . . .
4 1974 "32" "31A" 3 .     . . . . . . . .
4 1975 "D"  "D"   3 . 33146 . . . . . . .
4 1975 "35" "34A" 3 .     . . . . . . . .
4 1975 "24" "24"  3 .  4046 . . . . . . .
4 1975 "30" "29C" 3 .     . . . . . . . .
4 1975 "34" "34A" 3 .     0 . . . . . . .
4 1975 "28" "28"  3 .     0 . . . . . . .
4 1975 "36" "20C" 3 .     . . . . . . . .
4 1975 "23" "23"  3 .     0 . . . . . . .
4 1975 "15" "15"  3 .  5103 . . . . . . .
4 1975 "32" "31A" 3 .     . . . . . . . .
4 1975 "22" "22"  3 .  1447 . . . . . . .
4 1975 "18" "18A" 3 .   874 . . . . . . .
4 1975 "26" "26"  3 .  1646 . . . . . . .
4 1975 "20" "20C" 3 .  2321 . . . . . . .
4 1975 "33" "33"  3 .     0 . . . . . . .
4 1975 "25" "25"  3 .   507 . . . . . . .
4 1975 "27" "27"  3 .     0 . . . . . . .
4 1975 "29" "29C" 3 .     0 . . . . . . .
4 1975 "31" "31A" 3 .     0 . . . . . . .
4 1975 "17" "17"  3 . 17202 . . . . . . .
4 1975 "21" "21"  3 .     0 . . . . . . .
4 1975 "16" "16"  3 .     0 . . . . . . .
4 1975 "19" "18A" 3 .     . . . . . . . .
4 1976 "20" "20C" 3 .  2317 . . . . . . .
4 1976 "34" "34A" 3 .     0 . . . . . . .
4 1976 "26" "26"  3 .  1335 . . . . . . .
4 1976 "19" "18A" 3 .     . . . . . . . .
4 1976 "24" "24"  3 .  4479 . . . . . . .
4 1976 "23" "23"  3 .     0 . . . . . . .
4 1976 "17" "17"  3 . 20520 . . . . . . .
4 1976 "29" "29C" 3 .     0 . . . . . . .
4 1976 "28" "28"  3 .     0 . . . . . . .
4 1976 "31" "31A" 3 .     0 . . . . . . .
4 1976 "33" "33"  3 .     0 . . . . . . .
4 1976 "25" "25"  3 .   583 . . . . . . .
4 1976 "35" "34A" 3 .     . . . . . . . .
4 1976 "27" "27"  3 .     0 . . . . . . .
4 1976 "16" "16"  3 .     0 . . . . . . .
4 1976 "D"  "D"   3 . 36079 . . . . . . .
4 1976 "22" "22"  3 .  1465 . . . . . . .
4 1976 "30" "29C" 3 .     . . . . . . . .
4 1976 "15" "15"  3 .  4540 . . . . . . .
4 1976 "18" "18A" 3 .   840 . . . . . . .
4 1976 "32" "31A" 3 .     . . . . . . . .
4 1976 "36" "20C" 3 .     . . . . . . . .
4 1976 "21" "21"  3 .     0 . . . . . . .
4 1977 "16" "16"  3 .     0 . . . . . . .
4 1977 "19" "18A" 3 .     . . . . . . . .
4 1977 "21" "21"  3 .     0 . . . . . . .
4 1977 "33" "33"  3 .     0 . . . . . . .
4 1977 "31" "31A" 3 .     0 . . . . . . .
4 1977 "28" "28"  3 .     0 . . . . . . .
4 1977 "23" "23"  3 .     0 . . . . . . .
4 1977 "24" "24"  3 .  4714 . . . . . . .
end

Comment

Carlo Lazzaro

Join Date: Apr 2014

Posts: 17084
#18

22 Jan 2022, 14:08

Hugo:
sorry, I cannot test at the moment.

Kind regards,
Carlo
(Stata 18.0 SE)
Comment
Hugo Rocha

Join Date: Feb 2021

Posts: 288
#19

22 Jan 2022, 17:15

This code really helped!
I see what is the problem! The only issue that I see is that:
bysort NAMES_STD1 Year industry : gen perc_wanted= lval_added_worker/ln_1970
Once I put bysort NAMES_STD1 Year industry: gen perc_wanted= (lval_added_per_worker-ln_1970)/abs(year-1970) (given that I want the average annual percentage change). I get strange values, which do not match my manual work.

Last edited by Hugo Rocha; 22 Jan 2022, 17:26.
Comment

Carlo Lazzaro

Join Date: Apr 2014
Posts: 17084

#20

23 Jan 2022, 03:46

Hugo:
as some variables are missing (along with 1970), the following toy-example elaborated on your data excerpt and used 1973 instead of 1970:

Code:

. replace val_per_worker=10000*runiform()
. bysort country isic: g ln_1973=ln(val_per_worker) if year==1973
. replace ln_1973=0 if ln_1973==.
. gen check=0 if ln_1973!=0
. sort country isic check
. drop check
. bysort country isic : replace ln_1973=sum( ln_1973)
. g lval_per_worker=ln( val_per_worker)
. bysort country isic year: gen perc_wanted= lval_per_worker/ln_1973
. list country isic year ln_1973 val_per_worker lval_per_worker perc_wanted

     +-------------------------------------------------------------------+
     | country   isic   year    ln_1973   val_pe~r   lval_p~r   perc_w~d |
     |-------------------------------------------------------------------|
  1. |       4     15   1973   7.624177   2047.095   7.624177          1 |
  2. |       4     15   1974   7.624177   9011.049   9.106207   1.194386 |
  3. |       4     15   1975   7.624177   3227.766   8.079546   1.059727 |
  4. |       4     15   1976   7.624177   2275.435   7.729927    1.01387 |
  5. |       4     16   1973   8.081376   3233.679   8.081376          1 |
     |-------------------------------------------------------------------|
  6. |       4     16   1974   8.081376   1340.755   7.200989   .8910598 |
  7. |       4     16   1975   8.081376   1375.693   7.226713   .8942428 |
  8. |       4     16   1976   8.081376   843.8109   6.737928     .83376 |
  9. |       4     16   1977   8.081376   8941.061    9.09841   1.125849 |
 10. |       4     17   1973   9.048563    8506.31   9.048563          1 |
     |-------------------------------------------------------------------|
 11. |       4     17   1974   9.048563   7664.684   8.944379   .9884861 |
 12. |       4     17   1975   9.048563   1874.017    7.53584   .8328217 |
 13. |       4     17   1976   9.048563   6659.978   8.803871   .9729579 |
 14. |       4     18   1973   7.889406   2668.857   7.889406          1 |
 15. |       4     18   1974   7.889406    8821.12   9.084904   1.151532 |
     |-------------------------------------------------------------------|
 16. |       4     18   1975   7.889406   3060.019   8.026176   1.017336 |
 17. |       4     18   1976   7.889406    8514.68   9.049547    1.14705 |
 18. |       4     19   1973   9.077941    8759.91   9.077941          1 |
 19. |       4     19   1974   9.077941    7489.33   8.921235   .9827377 |
 20. |       4     19   1975   9.077941   6537.739   8.785347   .9677687 |
     |-------------------------------------------------------------------|
 21. |       4     19   1976   9.077941   1114.704   7.016344   .7729004 |
 22. |       4     19   1977   9.077941   9684.734   9.178307   1.011056 |
 23. |       4     20   1973   8.846531   6950.233   8.846531          1 |
 24. |       4     20   1974   8.846531   2643.649   7.879916   .8907351 |
 25. |       4     20   1975   8.846531    7247.31   8.888386   1.004731 |
     |-------------------------------------------------------------------|
 26. |       4     20   1976   8.846531   2701.319   7.901495   .8931745 |
 27. |       4     21   1973   8.834359   6866.152   8.834359          1 |
 28. |       4     21   1974   8.834359    8597.42   9.059217   1.025453 |
 29. |       4     21   1975   8.834359   3146.128   8.053927   .9116595 |
 30. |       4     21   1976   8.834359   9874.847   9.197746   1.041133 |
     |-------------------------------------------------------------------|
 31. |       4     21   1977   8.834359   2392.203    7.77997    .880649 |
 32. |       4     22   1973   9.139848   9319.346   9.139848          1 |
 33. |       4     22   1974   9.139848   4884.418   8.493806   .9293159 |
 34. |       4     22   1975   9.139848   8053.645    8.99388   .9840295 |
 35. |       4     22   1976   9.139848   3200.437   8.071043    .883061 |
     |-------------------------------------------------------------------|
 36. |       4     23   1973   8.215491   3697.792   8.215491          1 |
 37. |       4     23   1974   8.215491   7167.162   8.877265   1.080552 |
 38. |       4     23   1975   8.215491   5861.199   8.676109   1.056067 |
 39. |       4     23   1976   8.215491   30.52204   3.418449   .4160979 |
 40. |       4     23   1977   8.215491   5858.005   8.675565   1.056001 |
     |-------------------------------------------------------------------|
 41. |       4     24   1973   8.621739   5551.032   8.621739          1 |
 42. |       4     24   1974   8.621739   7264.384   8.890738     1.0312 |
 43. |       4     24   1975   8.621739   8285.889   9.022309   1.046461 |
 44. |       4     24   1976   8.621739   4145.227   8.329713   .9661291 |
 45. |       4     24   1977   8.621739   3787.092   8.239354   .9556487 |
     |-------------------------------------------------------------------|
 46. |       4     25   1973   5.654482   285.5687   5.654482          1 |
 47. |       4     25   1974   5.654482   7459.667   8.917266   1.577026 |
 48. |       4     25   1975   5.654482   9119.345   9.118154   1.612553 |
 49. |       4     25   1976   5.654482   3295.547   8.100327    1.43255 |
 50. |       4     26   1973   6.566744   711.0509   6.566744          1 |
     |-------------------------------------------------------------------|
 51. |       4     26   1974   6.566744   9805.113    9.19066   1.399576 |
 52. |       4     26   1975   6.566744   2190.997   7.692112   1.171374 |
 53. |       4     26   1976   6.566744   5734.232   8.654209   1.317884 |
 54. |       4     27   1973   8.422637   4548.882   8.422637          1 |
 55. |       4     27   1974   8.422637   2512.555   7.829056   .9295255 |
     |-------------------------------------------------------------------|
 56. |       4     27   1975   8.422637   6795.634   8.824036   1.047657 |
 57. |       4     27   1976   8.422637   360.8474   5.888455   .6991225 |
 58. |       4     28   1973   6.513247    674.011   6.513247          1 |
 59. |       4     28   1974   6.513247   454.1512    6.11843   .9393826 |
 60. |       4     28   1975   6.513247   3526.046   8.167933   1.254049 |
     |-------------------------------------------------------------------|
 61. |       4     28   1976   6.513247   780.2349   6.659595   1.022469 |
 62. |       4     28   1977   6.513247   4376.452   8.383993   1.287222 |
 63. |       4     29   1973   9.096901   8927.587   9.096901          1 |
 64. |       4     29   1974   9.096901   3379.889   8.125598    .893227 |
 65. |       4     29   1975   9.096901   3549.416   8.174539    .898607 |
     |-------------------------------------------------------------------|
 66. |       4     29   1976   9.096901   3462.876   8.149855   .8958935 |
 67. |       4     30   1973   9.069852   8689.333   9.069852          1 |
 68. |       4     30   1974   9.069852   7437.958   8.914351   .9828553 |
 69. |       4     30   1975   9.069852   442.1535   6.091657    .671638 |
 70. |       4     30   1976   9.069852   51.96965    3.95066   .4355815 |
     |-------------------------------------------------------------------|
 71. |       4     31   1973   8.272269   3913.819   8.272269          1 |
 72. |       4     31   1974   8.272269   8712.188   9.072478   1.096734 |
 73. |       4     31   1975   8.272269     7389.7   8.907843   1.076832 |
 74. |       4     31   1976   8.272269   1275.813   7.151339   .8644955 |
 75. |       4     31   1977   8.272269   4884.358   8.493793   1.026779 |
     |-------------------------------------------------------------------|
 76. |       4     32   1973   7.219981   1366.463   7.219981          1 |
 77. |       4     32   1974   7.219981   9196.262   9.126553   1.264069 |
 78. |       4     32   1975   7.219981   1729.307   7.455476   1.032617 |
 79. |       4     32   1976   7.219981   9820.066   9.192183   1.273159 |
 80. |       4     33   1973    8.15729   3488.717    8.15729          1 |
     |-------------------------------------------------------------------|
 81. |       4     33   1974    8.15729   7295.772    8.89505   1.090442 |
 82. |       4     33   1975    8.15729   6964.866   8.848634   1.084752 |
 83. |       4     33   1976    8.15729   2297.006   7.739362   .9487664 |
 84. |       4     33   1977    8.15729   6927.336    8.84323   1.084089 |
 85. |       4     34   1973     8.9283   7542.434     8.9283          1 |
     |-------------------------------------------------------------------|
 86. |       4     34   1974     8.9283   1663.648   7.416768   .8307033 |
 87. |       4     34   1975     8.9283   8630.378   9.063044   1.015092 |
 88. |       4     34   1976     8.9283   8998.395   9.104801   1.019769 |
 89. |       4     35   1973   7.087251   1196.613   7.087251          1 |
 90. |       4     35   1974   7.087251   9748.849   9.184904   1.295976 |
     |-------------------------------------------------------------------|
 91. |       4     35   1975   7.087251   2154.026   7.675094   1.082944 |
 92. |       4     35   1976   7.087251   4144.089   8.329438   1.175271 |
 93. |       4     36   1973   8.673284   5844.658   8.673284          1 |
 94. |       4     36   1974   8.673284    8856.51   9.088908    1.04792 |
 95. |       4     36   1975   8.673284     7720.4   8.951621   1.032091 |
     |-------------------------------------------------------------------|
 96. |       4     36   1976   8.673284   324.7919   5.783185   .6667814 |
 97. |       4      D   1973   8.162958   3508.549   8.162958          1 |
 98. |       4      D   1974   8.162958   4961.259   8.509415   1.042443 |
 99. |       4      D   1975   8.162958   6934.533   8.844269   1.083464 |
100. |       4      D   1976   8.162958   98.76247   4.592718   .5626291 |
     +-------------------------------------------------------------------+

.

Kind regards,
Carlo
(Stata 18.0 SE)

Comment

Hugo Rocha

Join Date: Feb 2021

Posts: 288
#21

23 Jan 2022, 11:27

Great! Thank you so much, Professor Lazzaro!

what would happen if instead of (bysort country isic year: gen perc_wanted= lval_per_worker/ln_1973), I write bysort country isic year: gen perc_wanted= (lval_per_worker- ln_1973)/ abs(year-1973)? The data covers the a period in between 1963 and 2018 but it is very unbalanced if that expression could be used...
Comment
Carlo Lazzaro

Join Date: Apr 2014

Posts: 17084
#22

23 Jan 2022, 13:26

Hugo:
sorry, I can't test at the moment.

Last edited by Carlo Lazzaro; 23 Jan 2022, 13:29.

Kind regards,
Carlo
(Stata 18.0 SE)
Comment
Hugo Rocha

Join Date: Feb 2021

Posts: 288
#23

23 Jan 2022, 13:51

I think that's where the problem lies more than the unbalanced nature of the panel. It's in the construction of perc_wanted (average annual percentage change) that I am doing

bysort country year isic: gen perc_wanted= (lval_added_per_worker-ln_1970)/abs(year-1970)

When I try that syntax, I get the wrong plot (even when I exclude the zeros ln_1970 (or 1973))

Last edited by Hugo Rocha; 23 Jan 2022, 13:56.
Comment

Carlo Lazzaro

Join Date: Apr 2014
Posts: 17084

#24

24 Jan 2022, 00:47

Hugo:
this is what I got:

Code:

. replace val_per_worker=10000*runiform()

. bysort country isic: g ln_1973=ln(val_per_worker) if year==1973

. replace ln_1973=0 if ln_1973==.

. gen check=0 if ln_1973!=0

. sort country isic check

. drop check

. bysort country isic : replace ln_1973=sum( ln_1973)

. replace lval_per_worker=ln( val_per_worker)

. bysort country isic year: gen perc_wanted= (lval_per_worker- ln_1973)/abs(year-1973)

. list country isic year ln_1973 val_per_worker lval_per_worker perc_wanted

     +--------------------------------------------------------------------+
     | country   isic   year    ln_1973   val_pe~r   lval_p~r   perc_wa~d |
     |--------------------------------------------------------------------|
  1. |       4     15   1973   8.574774   5296.353   8.574774           . |
  2. |       4     15   1974   8.574774   5662.266    8.64158    .0668058 |
  3. |       4     15   1975   8.574774   6701.369   8.810067    .1176467 |
  4. |       4     15   1976   8.574774    1745.77   7.464951   -.3699411 |
  5. |       4     16   1973   6.876152   968.8907   6.876152           . |
     |--------------------------------------------------------------------|
  6. |       4     16   1974   6.876152     432.55   6.069698   -.8064542 |
  7. |       4     16   1975   6.876152   1900.222   7.549726     .336787 |
  8. |       4     16   1976   6.876152     1799.3   7.495153    .2063336 |
  9. |       4     16   1977   6.876152   6517.417   8.782233    .4765203 |
 10. |       4     17   1973   8.619059   5536.171   8.619059           . |
     |--------------------------------------------------------------------|
 11. |       4     17   1974   8.619059   7551.366   8.929483    .3104248 |
 12. |       4     17   1975   8.619059   8464.646   9.043653    .2122974 |
 13. |       4     17   1976   8.619059   9180.508   9.124838    .1685931 |
 14. |       4     18   1973   9.189585   9794.578   9.189585           . |
 15. |       4     18   1974   9.189585   5955.869   8.692132   -.4974527 |
     |--------------------------------------------------------------------|
 16. |       4     18   1975   9.189585   867.4778    6.76559   -1.211998 |
 17. |       4     18   1976   9.189585   3617.646   8.193579    -.332002 |
 18. |       4     19   1973   9.073943    8724.96   9.073943           . |
 19. |       4     19   1974   9.073943   6251.604   8.740593   -.3333502 |
 20. |       4     19   1975   9.073943   3869.604   8.260907    -.406518 |
     |--------------------------------------------------------------------|
 21. |       4     19   1976   9.073943   7484.396   8.920575   -.0511227 |
 22. |       4     19   1977   9.073943   9252.081   9.132604    .0146651 |
 23. |       4     20   1973   7.928473   2775.184   7.928473           . |
 24. |       4     20   1974   7.928473   1778.325   7.483427   -.4450455 |
 25. |       4     20   1975   7.928473   5890.286    8.68106    .3762937 |
     |--------------------------------------------------------------------|
 26. |       4     20   1976   7.928473   2387.134   7.777849   -.0502079 |
 27. |       4     21   1973   8.352794   4242.016   8.352794           . |
 28. |       4     21   1974   8.352794   2468.877   7.811519    -.541275 |
 29. |       4     21   1975   8.352794   7908.313    8.97567    .3114381 |
 30. |       4     21   1976   8.352794       2571    7.85205   -.1669145 |
     |--------------------------------------------------------------------|
 31. |       4     21   1977   8.352794   8233.367    9.01595    .1657891 |
 32. |       4     22   1973   7.214509   1359.005   7.214509           . |
 33. |       4     22   1974   7.214509   3764.437   8.233354    1.018845 |
 34. |       4     22   1975   7.214509   9537.622   9.162999    .9742453 |
 35. |       4     22   1976   7.214509   4081.415   8.314199    .3665636 |
     |--------------------------------------------------------------------|
 36. |       4     23   1973   7.467309   1749.891   7.467309           . |
 37. |       4     23   1974   7.467309   8745.815    9.07633    1.609021 |
 38. |       4     23   1975   7.467309   75.38023   4.322545   -1.572382 |
 39. |       4     23   1976   7.467309   1677.032   7.424781   -.0141761 |
 40. |       4     23   1977   7.467309   4022.151   8.299572    .2080657 |
     |--------------------------------------------------------------------|
 41. |       4     24   1973   8.837109   6885.059   8.837109           . |
 42. |       4     24   1974   8.837109   722.9638   6.583359   -2.253749 |
 43. |       4     24   1975   8.837109   1736.788   7.459793    -.688658 |
 44. |       4     24   1976   8.837109   2303.784   7.742308   -.3649335 |
 45. |       4     24   1977   8.837109   8681.989   9.069006    .0579743 |
     |--------------------------------------------------------------------|
 46. |       4     25   1973   8.690947   5948.808   8.690947           . |
 47. |       4     25   1974   8.690947   880.4953   6.780485   -1.910462 |
 48. |       4     25   1975   8.690947   6654.901   8.803109    .0560813 |
 49. |       4     25   1976   8.690947   8147.295   9.005442    .1048317 |
 50. |       4     26   1973   8.786662   6546.342   8.786662           . |
     |--------------------------------------------------------------------|
 51. |       4     26   1974   8.786662   6794.177   8.823821     .037159 |
 52. |       4     26   1975   8.786662   8949.648    9.09937     .156354 |
 53. |       4     26   1976   8.786662   7795.682   8.961326    .0582212 |
 54. |       4     27   1973   8.109412   3325.624   8.109412           . |
 55. |       4     27   1974   8.109412   4476.188   8.406528    .2971153 |
     |--------------------------------------------------------------------|
 56. |       4     27   1975   8.109412   4198.387   8.342456    .1165218 |
 57. |       4     27   1976   8.109412   259.9352   5.560432   -.8496599 |
 58. |       4     28   1973   8.450096   4675.523   8.450096           . |
 59. |       4     28   1974   8.450096   6817.465   8.827243    .3771467 |
 60. |       4     28   1975   8.450096   3678.161   8.210168   -.1199641 |
     |--------------------------------------------------------------------|
 61. |       4     28   1976   8.450096   9019.141   9.107104    .2190027 |
 62. |       4     28   1977   8.450096   5214.147   8.559131    .0272586 |
 63. |       4     29   1973   9.024277   8302.209   9.024277           . |
 64. |       4     29   1974   9.024277   5160.881   8.548862   -.4754143 |
 65. |       4     29   1975   9.024277   7472.054   8.918925   -.0526757 |
     |--------------------------------------------------------------------|
 66. |       4     29   1976   9.024277   3138.996   8.051659    -.324206 |
 67. |       4     30   1973   8.983552   7970.893   8.983552           . |
 68. |       4     30   1974   8.983552   2977.743   7.998921   -.9846311 |
 69. |       4     30   1975   8.983552   6107.705   8.717306   -.1331229 |
 70. |       4     30   1976   8.983552   6155.495   8.725101   -.0861505 |
     |--------------------------------------------------------------------|
 71. |       4     31   1973   8.584132   5346.152   8.584132           . |
 72. |       4     31   1974   8.584132   7677.862   8.946096    .3619642 |
 73. |       4     31   1975   8.584132   7190.144   8.880466    .1481671 |
 74. |       4     31   1976   8.584132   774.0517   6.651639   -.6441646 |
 75. |       4     31   1977   8.584132   7480.426   8.920045    .0839782 |
     |--------------------------------------------------------------------|
 76. |       4     32   1973   8.810152   6701.937   8.810152           . |
 77. |       4     32   1974   8.810152   6348.989   8.756051    -.054101 |
 78. |       4     32   1975   8.810152   4241.406    8.35265   -.2287512 |
 79. |       4     32   1976   8.810152   1338.996   7.199676   -.5368255 |
 80. |       4     33   1973   8.836462   6880.604   8.836462           . |
     |--------------------------------------------------------------------|
 81. |       4     33   1974   8.836462   7124.024   8.871228    .0347662 |
 82. |       4     33   1975   8.836462   4005.832   8.295506   -.2704778 |
 83. |       4     33   1976   8.836462   6341.382   8.754852   -.0272032 |
 84. |       4     33   1977   8.836462   9229.402    9.13015     .073422 |
 85. |       4     34   1973   7.161426   1288.747   7.161426           . |
     |--------------------------------------------------------------------|
 86. |       4     34   1974   7.161426   4087.105   8.315592    1.154166 |
 87. |       4     34   1975   7.161426   5754.215   8.657688    .7481313 |
 88. |       4     34   1976   7.161426   3447.001    8.14526    .3279448 |
 89. |       4     35   1973   8.957742   7767.793   8.957742           . |
 90. |       4     35   1974   8.957742   669.4305   6.506427   -2.451314 |
     |--------------------------------------------------------------------|
 91. |       4     35   1975   8.957742   7497.677   8.922349   -.0176964 |
 92. |       4     35   1976   8.957742   8788.922   9.081247    .0411685 |
 93. |       4     36   1973   9.142046   9339.853   9.142046           . |
 94. |       4     36   1974   9.142046    1139.99   7.038774   -2.103271 |
 95. |       4     36   1975   9.142046   3005.246   8.008115   -.5669656 |
     |--------------------------------------------------------------------|
 96. |       4     36   1976   9.142046   13.63096   2.612344   -2.176568 |
 97. |       4      D   1973   8.966465   7835.854   8.966465           . |
 98. |       4      D   1974   8.966465   1327.082   7.190738   -1.775727 |
 99. |       4      D   1975   8.966465   9944.572   9.204782    .1191587 |
100. |       4      D   1976   8.966465   5778.896   8.661968   -.1014989 |
     +--------------------------------------------------------------------+

.

As expected, when -year-=1973, -perc_wanted- =.

Kind regards,
Carlo
(Stata 18.0 SE)

Comment

Hugo Rocha

Join Date: Feb 2021

Posts: 288
#25

24 Jan 2022, 16:30

Thank you so much, Professor Lazzaro!
Comment
Carlo Lazzaro

Join Date: Apr 2014

Posts: 17084
#26

25 Jan 2022, 00:47

Hugo:
Carlo is enough. Thanks.

Kind regards,
Carlo
(Stata 18.0 SE)
1 like
Comment

Hugo Rocha

Join Date: Feb 2021
Posts: 288

#27

28 May 2022, 13:10

Originally posted by Carlo Lazzaro View Post

Hugo:
this is what I got:

Code:

. replace val_per_worker=10000*runiform()

. bysort country isic: g ln_1973=ln(val_per_worker) if year==1973

. replace ln_1973=0 if ln_1973==.

. gen check=0 if ln_1973!=0

. sort country isic check

. drop check

. bysort country isic : replace ln_1973=sum( ln_1973)

. replace lval_per_worker=ln( val_per_worker)

. bysort country isic year: gen perc_wanted= (lval_per_worker- ln_1973)/abs(year-1973)

. list country isic year ln_1973 val_per_worker lval_per_worker perc_wanted

+--------------------------------------------------------------------+
| country isic year ln_1973 val_pe~r lval_p~r perc_wa~d |
|--------------------------------------------------------------------|
1. | 4 15 1973 8.574774 5296.353 8.574774 . |
2. | 4 15 1974 8.574774 5662.266 8.64158 .0668058 |
3. | 4 15 1975 8.574774 6701.369 8.810067 .1176467 |
4. | 4 15 1976 8.574774 1745.77 7.464951 -.3699411 |
5. | 4 16 1973 6.876152 968.8907 6.876152 . |
|--------------------------------------------------------------------|
6. | 4 16 1974 6.876152 432.55 6.069698 -.8064542 |
7. | 4 16 1975 6.876152 1900.222 7.549726 .336787 |
8. | 4 16 1976 6.876152 1799.3 7.495153 .2063336 |
9. | 4 16 1977 6.876152 6517.417 8.782233 .4765203 |
10. | 4 17 1973 8.619059 5536.171 8.619059 . |
|--------------------------------------------------------------------|
11. | 4 17 1974 8.619059 7551.366 8.929483 .3104248 |
12. | 4 17 1975 8.619059 8464.646 9.043653 .2122974 |
13. | 4 17 1976 8.619059 9180.508 9.124838 .1685931 |
14. | 4 18 1973 9.189585 9794.578 9.189585 . |
15. | 4 18 1974 9.189585 5955.869 8.692132 -.4974527 |
|--------------------------------------------------------------------|
16. | 4 18 1975 9.189585 867.4778 6.76559 -1.211998 |
17. | 4 18 1976 9.189585 3617.646 8.193579 -.332002 |
18. | 4 19 1973 9.073943 8724.96 9.073943 . |
19. | 4 19 1974 9.073943 6251.604 8.740593 -.3333502 |
20. | 4 19 1975 9.073943 3869.604 8.260907 -.406518 |
|--------------------------------------------------------------------|
21. | 4 19 1976 9.073943 7484.396 8.920575 -.0511227 |
22. | 4 19 1977 9.073943 9252.081 9.132604 .0146651 |
23. | 4 20 1973 7.928473 2775.184 7.928473 . |
24. | 4 20 1974 7.928473 1778.325 7.483427 -.4450455 |
25. | 4 20 1975 7.928473 5890.286 8.68106 .3762937 |
|--------------------------------------------------------------------|
26. | 4 20 1976 7.928473 2387.134 7.777849 -.0502079 |
27. | 4 21 1973 8.352794 4242.016 8.352794 . |
28. | 4 21 1974 8.352794 2468.877 7.811519 -.541275 |
29. | 4 21 1975 8.352794 7908.313 8.97567 .3114381 |
30. | 4 21 1976 8.352794 2571 7.85205 -.1669145 |
|--------------------------------------------------------------------|
31. | 4 21 1977 8.352794 8233.367 9.01595 .1657891 |
32. | 4 22 1973 7.214509 1359.005 7.214509 . |
33. | 4 22 1974 7.214509 3764.437 8.233354 1.018845 |
34. | 4 22 1975 7.214509 9537.622 9.162999 .9742453 |
35. | 4 22 1976 7.214509 4081.415 8.314199 .3665636 |
|--------------------------------------------------------------------|
36. | 4 23 1973 7.467309 1749.891 7.467309 . |
37. | 4 23 1974 7.467309 8745.815 9.07633 1.609021 |
38. | 4 23 1975 7.467309 75.38023 4.322545 -1.572382 |
39. | 4 23 1976 7.467309 1677.032 7.424781 -.0141761 |
40. | 4 23 1977 7.467309 4022.151 8.299572 .2080657 |
|--------------------------------------------------------------------|
41. | 4 24 1973 8.837109 6885.059 8.837109 . |
42. | 4 24 1974 8.837109 722.9638 6.583359 -2.253749 |
43. | 4 24 1975 8.837109 1736.788 7.459793 -.688658 |
44. | 4 24 1976 8.837109 2303.784 7.742308 -.3649335 |
45. | 4 24 1977 8.837109 8681.989 9.069006 .0579743 |
|--------------------------------------------------------------------|
46. | 4 25 1973 8.690947 5948.808 8.690947 . |
47. | 4 25 1974 8.690947 880.4953 6.780485 -1.910462 |
48. | 4 25 1975 8.690947 6654.901 8.803109 .0560813 |
49. | 4 25 1976 8.690947 8147.295 9.005442 .1048317 |
50. | 4 26 1973 8.786662 6546.342 8.786662 . |
|--------------------------------------------------------------------|
51. | 4 26 1974 8.786662 6794.177 8.823821 .037159 |
52. | 4 26 1975 8.786662 8949.648 9.09937 .156354 |
53. | 4 26 1976 8.786662 7795.682 8.961326 .0582212 |
54. | 4 27 1973 8.109412 3325.624 8.109412 . |
55. | 4 27 1974 8.109412 4476.188 8.406528 .2971153 |
|--------------------------------------------------------------------|
56. | 4 27 1975 8.109412 4198.387 8.342456 .1165218 |
57. | 4 27 1976 8.109412 259.9352 5.560432 -.8496599 |
58. | 4 28 1973 8.450096 4675.523 8.450096 . |
59. | 4 28 1974 8.450096 6817.465 8.827243 .3771467 |
60. | 4 28 1975 8.450096 3678.161 8.210168 -.1199641 |
|--------------------------------------------------------------------|
61. | 4 28 1976 8.450096 9019.141 9.107104 .2190027 |
62. | 4 28 1977 8.450096 5214.147 8.559131 .0272586 |
63. | 4 29 1973 9.024277 8302.209 9.024277 . |
64. | 4 29 1974 9.024277 5160.881 8.548862 -.4754143 |
65. | 4 29 1975 9.024277 7472.054 8.918925 -.0526757 |
|--------------------------------------------------------------------|
66. | 4 29 1976 9.024277 3138.996 8.051659 -.324206 |
67. | 4 30 1973 8.983552 7970.893 8.983552 . |
68. | 4 30 1974 8.983552 2977.743 7.998921 -.9846311 |
69. | 4 30 1975 8.983552 6107.705 8.717306 -.1331229 |
70. | 4 30 1976 8.983552 6155.495 8.725101 -.0861505 |
|--------------------------------------------------------------------|
71. | 4 31 1973 8.584132 5346.152 8.584132 . |
72. | 4 31 1974 8.584132 7677.862 8.946096 .3619642 |
73. | 4 31 1975 8.584132 7190.144 8.880466 .1481671 |
74. | 4 31 1976 8.584132 774.0517 6.651639 -.6441646 |
75. | 4 31 1977 8.584132 7480.426 8.920045 .0839782 |
|--------------------------------------------------------------------|
76. | 4 32 1973 8.810152 6701.937 8.810152 . |
77. | 4 32 1974 8.810152 6348.989 8.756051 -.054101 |
78. | 4 32 1975 8.810152 4241.406 8.35265 -.2287512 |
79. | 4 32 1976 8.810152 1338.996 7.199676 -.5368255 |
80. | 4 33 1973 8.836462 6880.604 8.836462 . |
|--------------------------------------------------------------------|
81. | 4 33 1974 8.836462 7124.024 8.871228 .0347662 |
82. | 4 33 1975 8.836462 4005.832 8.295506 -.2704778 |
83. | 4 33 1976 8.836462 6341.382 8.754852 -.0272032 |
84. | 4 33 1977 8.836462 9229.402 9.13015 .073422 |
85. | 4 34 1973 7.161426 1288.747 7.161426 . |
|--------------------------------------------------------------------|
86. | 4 34 1974 7.161426 4087.105 8.315592 1.154166 |
87. | 4 34 1975 7.161426 5754.215 8.657688 .7481313 |
88. | 4 34 1976 7.161426 3447.001 8.14526 .3279448 |
89. | 4 35 1973 8.957742 7767.793 8.957742 . |
90. | 4 35 1974 8.957742 669.4305 6.506427 -2.451314 |
|--------------------------------------------------------------------|
91. | 4 35 1975 8.957742 7497.677 8.922349 -.0176964 |
92. | 4 35 1976 8.957742 8788.922 9.081247 .0411685 |
93. | 4 36 1973 9.142046 9339.853 9.142046 . |
94. | 4 36 1974 9.142046 1139.99 7.038774 -2.103271 |
95. | 4 36 1975 9.142046 3005.246 8.008115 -.5669656 |
|--------------------------------------------------------------------|
96. | 4 36 1976 9.142046 13.63096 2.612344 -2.176568 |
97. | 4 D 1973 8.966465 7835.854 8.966465 . |
98. | 4 D 1974 8.966465 1327.082 7.190738 -1.775727 |
99. | 4 D 1975 8.966465 9944.572 9.204782 .1191587 |
100. | 4 D 1976 8.966465 5778.896 8.661968 -.1014989 |
+--------------------------------------------------------------------+

.

As expected, when -year-=1973, -perc_wanted- =.

If I wanted to obtain average annual growth rates between periods 2019 and 1973. How would this syntax change with respect to what was described? Thank you so much!

Comment

Carlo Lazzaro

Join Date: Apr 2014
Posts: 17084

#28

29 May 2022, 11:58

Hugo:
I'm not sure what follows helps, but anyway I give it a shot:

Code:

. g val_per_worker=10000*runiform()

. bysort country isic: g ln_all_year=ln(val_per_worker)

. gen check=0 if ln_all_year !=0

. sort country isic check

. drop check

. bysort country isic : replace ln_all_year =sum( ln_all_year )

. g lval_per_worker=ln( val_per_worker)

. bysort country isic year: gen perc_wanted_all_year=abs((lval_per_worker- ln_all_year)/(year-1973))

. list country isic year ln_all_year val_per_worker lval_per_worker perc_wanted_all_year


     +-------------------------------------------------------------------+
     | country   isic   year   ln_all~r   val_pe~r   lval_p~r   perc_w~r |
     |-------------------------------------------------------------------|
  1. |       4     15   1973   8.880046   7187.118   8.880046          . |
  2. |       4     15   1974   16.58514   2219.616    7.70509   8.880047 |
  3. |       4     15   1975   24.28124   2199.756   7.696102   8.292567 |
  4. |       4     15   1976   31.77023   1788.245    7.48899   8.093746 |
  5. |       4     16   1973   8.190465     3606.4   8.190465          . |
     |-------------------------------------------------------------------|
  6. |       4     16   1974    14.0969   367.3937   5.906434   8.190465 |
  7. |       4     16   1975   22.75451   5753.792   8.657615   7.048449 |
  8. |       4     16   1976   30.45961    2219.64     7.7051   7.584838 |
  9. |       4     16   1977   39.44426   7979.596   8.984643   7.614903 |
 10. |       4     17   1973    7.40835   1649.701    7.40835          . |
     |-------------------------------------------------------------------|
 11. |       4     17   1974    16.5096   8966.501   9.101251   7.408349 |
 12. |       4     17   1975   25.57367   8639.233   9.064069   8.254801 |
 13. |       4     17   1976   33.88894   4085.775   8.315267   8.524556 |
 14. |       4     18   1973   7.575145   1949.142   7.575145          . |
 15. |       4     18   1974   16.54217   7840.244   8.967025   7.575145 |
     |-------------------------------------------------------------------|
 16. |       4     18   1975   23.10077     705.28   6.558595   8.271086 |
 17. |       4     18   1976   30.89587   2428.684   7.795105   7.700255 |
 18. |       4     19   1973   7.625093    2048.97   7.625093          . |
 19. |       4     19   1974    15.2583   2065.663   7.633206   7.625093 |
 20. |       4     19   1975   23.75538   4900.448   8.497082   7.629149 |
     |-------------------------------------------------------------------|
 21. |       4     19   1976   31.64487   2669.083    7.88949    7.91846 |
 22. |       4     19   1977   36.25663   100.6614   4.611763   7.911218 |
 23. |       4     20   1973   9.031445   8361.934   9.031445          . |
 24. |       4     20   1974   17.50056   4765.315   8.469119   9.031446 |
 25. |       4     20   1975   25.95893   4714.345   8.458365   8.750282 |
     |-------------------------------------------------------------------|
 26. |       4     20   1976   34.20219   3801.901   8.243257   8.652977 |
 27. |       4     21   1973   9.008052    8168.59   9.008052          . |
 28. |       4     21   1974   17.33366    4128.24   8.325606   9.008052 |
 29. |       4     21   1975   24.49792   1292.402   7.164258    8.66683 |
 30. |       4     21   1976   32.14906   2103.053   7.651145   8.165973 |
     |-------------------------------------------------------------------|
 31. |       4     21   1977   41.02214   7137.254   8.873083   8.037266 |
 32. |       4     22   1973   8.161633   3503.907   8.161633          . |
 33. |       4     22   1974   14.72498   708.6408   6.563349   8.161633 |
 34. |       4     22   1975    23.5616   6881.662   8.836616   7.362491 |
 35. |       4     22   1976   31.99608   4603.092   8.434484   7.853866 |
     |-------------------------------------------------------------------|
 36. |       4     23   1973   7.741401   2301.694   7.741401          . |
 37. |       4     23   1974   16.46914   6171.731   8.727735   7.741401 |
 38. |       4     23   1975   25.31552   6949.196   8.846381   8.234568 |
 39. |       4     23   1976   33.43942   3374.159   8.123901   8.438506 |
 40. |       4     23   1977   41.70048    3870.21   8.261064   8.359855 |
     |-------------------------------------------------------------------|
 41. |       4     24   1973   6.883958   976.4836   6.883958          . |
 42. |       4     24   1974   16.06504   9711.645   9.181081   6.883958 |
 43. |       4     24   1975   20.86186    121.125   4.796823   8.032519 |
 44. |       4     24   1976   29.60941    6295.22   8.747546   6.953954 |
 45. |       4     24   1977   37.32881    2251.61   7.719401   7.402352 |
     |-------------------------------------------------------------------|
 46. |       4     25   1973   9.168204   9587.393   9.168204          . |
 47. |       4     25   1974   17.24205   3209.424   8.073847   9.168203 |
 48. |       4     25   1975   26.35163   9041.464   9.109576   8.621025 |
 49. |       4     25   1976   33.93297   1961.261   7.581343   8.783875 |
 50. |       4     26   1973   9.121167   9146.875   9.121167          . |
     |-------------------------------------------------------------------|
 51. |       4     26   1974   14.24649   168.2284   5.125322   9.121167 |
 52. |       4     26   1975   22.91317   5806.194    8.66668   7.123245 |
 53. |       4     26   1976   32.06535   9434.988   9.152181   7.637723 |
 54. |       4     27   1973   9.038897   8424.475   9.038897          . |
 55. |       4     27   1974   18.17181   9254.969   9.132915   9.038897 |
     |-------------------------------------------------------------------|
 56. |       4     27   1975   26.71581   5135.824   8.543996   9.085907 |
 57. |       4     27   1976   35.66273   7684.242   8.946927    8.90527 |
 58. |       4     28   1973   5.557983   259.2992   5.557983          . |
 59. |       4     28   1974   14.39899   6911.973    8.84101   5.557982 |
 60. |       4     28   1975   23.11866   6122.161    8.71967   7.199497 |
     |-------------------------------------------------------------------|
 61. |       4     28   1976   31.86491   6287.054   8.746248   7.706221 |
 62. |       4     28   1977   40.50319   5643.624   8.638282   7.966228 |
 63. |       4     29   1973   8.723305   6144.452   8.723305          . |
 64. |       4     29   1974   16.62382    2698.66   7.900511   8.723305 |
 65. |       4     29   1975   22.47868   348.9263   5.854861   8.311908 |
     |-------------------------------------------------------------------|
 66. |       4     29   1976   31.53843   8602.024   9.059752   7.492892 |
 67. |       4     30   1973   8.181468   3574.097   8.181468          . |
 68. |       4     30   1974     15.791   2017.341   7.609536   8.181469 |
 69. |       4     30   1975   24.78041   8017.713   8.989408   7.895502 |
 70. |       4     30   1976   32.15665   1597.559   7.376233   8.260138 |
     |-------------------------------------------------------------------|
 71. |       4     31   1973   8.915335   7445.277   8.915335          . |
 72. |       4     31   1974   17.48354     5261.7    8.56821   8.915334 |
 73. |       4     31   1975    26.4948   8194.775   9.011252   8.741772 |
 74. |       4     31   1976   34.55143   3154.643   8.056631   8.831599 |
 75. |       4     31   1977   40.42806   356.6065   5.876633   8.637857 |
     |-------------------------------------------------------------------|
 76. |       4     32   1973   7.625723   2050.263   7.625723          . |
 77. |       4     32   1974   14.93475    1493.72   7.309025   7.625723 |
 78. |       4     32   1975   18.28811   28.59864   3.353359   7.467374 |
 79. |       4     32   1976   26.65056   4283.178   8.362451   6.096036 |
 80. |       4     33   1973   8.879726   7184.824   8.879726          . |
     |-------------------------------------------------------------------|
 81. |       4     33   1974   17.91346    8381.08   9.033732   8.879727 |
 82. |       4     33   1975   25.44116    1858.82   7.527697    8.95673 |
 83. |       4     33   1976   34.52919   8848.767   9.088034   8.480386 |
 84. |       4     33   1977   43.13614   5469.507   8.606944   8.632298 |
 85. |       4     34   1973   8.760368   6376.462   8.760368          . |
     |-------------------------------------------------------------------|
 86. |       4     34   1974   17.25675   4897.037   8.496386   8.760368 |
 87. |       4     34   1975   24.90948   2106.372   7.652722   8.628378 |
 88. |       4     34   1976   33.81373   7363.224   8.904253   8.303159 |
 89. |       4     35   1973   9.026129   8317.598   9.026129          . |
 90. |       4     35   1974   18.18443   9492.906     9.1583   9.026129 |
     |-------------------------------------------------------------------|
 91. |       4     35   1975   27.09295    7394.67   8.908515   9.092215 |
 92. |       4     35   1976   36.06257   7860.632   8.969623   9.030982 |
 93. |       4     36   1973   8.206132   3663.345   8.206132          . |
 94. |       4     36   1974   16.67481   4763.205   8.468676   8.206133 |
 95. |       4     36   1975   25.04704   4325.287   8.372233   8.337404 |
     |-------------------------------------------------------------------|
 96. |       4     36   1976   33.82034   6459.438   8.773297   8.349014 |
 97. |       4      D   1973   7.791623   2420.242   7.791623          . |
 98. |       4      D   1974   16.88504   8896.526   9.093416   7.791622 |
 99. |       4      D   1975   24.04038   1280.932   7.155343    8.44252 |
100. |       4      D   1976   31.33325   1469.777   7.292866   8.013461 |
     +-------------------------------------------------------------------+

.

Kind regards,
Carlo
(Stata 18.0 SE)

Comment

Hugo Rocha

Join Date: Feb 2021
Posts: 288

#29

29 May 2022, 12:35

Originally posted by Carlo Lazzaro View Post

Hugo:
I'm not sure what follows helps, but anyway I give it a shot:

Code:

. g val_per_worker=10000*runiform()

. bysort country isic: g ln_all_year=ln(val_per_worker)

. gen check=0 if ln_all_year !=0

. sort country isic check

. drop check

. bysort country isic : replace ln_all_year =sum( ln_all_year )

. g lval_per_worker=ln( val_per_worker)

. bysort country isic year: gen perc_wanted_all_year=abs((lval_per_worker- ln_all_year)/(year-1973))

. list country isic year ln_all_year val_per_worker lval_per_worker perc_wanted_all_year


+-------------------------------------------------------------------+
| country isic year ln_all~r val_pe~r lval_p~r perc_w~r |
|-------------------------------------------------------------------|
1. | 4 15 1973 8.880046 7187.118 8.880046 . |
2. | 4 15 1974 16.58514 2219.616 7.70509 8.880047 |
3. | 4 15 1975 24.28124 2199.756 7.696102 8.292567 |
4. | 4 15 1976 31.77023 1788.245 7.48899 8.093746 |
5. | 4 16 1973 8.190465 3606.4 8.190465 . |
|-------------------------------------------------------------------|
6. | 4 16 1974 14.0969 367.3937 5.906434 8.190465 |
7. | 4 16 1975 22.75451 5753.792 8.657615 7.048449 |
8. | 4 16 1976 30.45961 2219.64 7.7051 7.584838 |
9. | 4 16 1977 39.44426 7979.596 8.984643 7.614903 |
10. | 4 17 1973 7.40835 1649.701 7.40835 . |
|-------------------------------------------------------------------|
11. | 4 17 1974 16.5096 8966.501 9.101251 7.408349 |
12. | 4 17 1975 25.57367 8639.233 9.064069 8.254801 |
13. | 4 17 1976 33.88894 4085.775 8.315267 8.524556 |
14. | 4 18 1973 7.575145 1949.142 7.575145 . |
15. | 4 18 1974 16.54217 7840.244 8.967025 7.575145 |
|-------------------------------------------------------------------|
16. | 4 18 1975 23.10077 705.28 6.558595 8.271086 |
17. | 4 18 1976 30.89587 2428.684 7.795105 7.700255 |
18. | 4 19 1973 7.625093 2048.97 7.625093 . |
19. | 4 19 1974 15.2583 2065.663 7.633206 7.625093 |
20. | 4 19 1975 23.75538 4900.448 8.497082 7.629149 |
|-------------------------------------------------------------------|
21. | 4 19 1976 31.64487 2669.083 7.88949 7.91846 |
22. | 4 19 1977 36.25663 100.6614 4.611763 7.911218 |
23. | 4 20 1973 9.031445 8361.934 9.031445 . |
24. | 4 20 1974 17.50056 4765.315 8.469119 9.031446 |
25. | 4 20 1975 25.95893 4714.345 8.458365 8.750282 |
|-------------------------------------------------------------------|
26. | 4 20 1976 34.20219 3801.901 8.243257 8.652977 |
27. | 4 21 1973 9.008052 8168.59 9.008052 . |
28. | 4 21 1974 17.33366 4128.24 8.325606 9.008052 |
29. | 4 21 1975 24.49792 1292.402 7.164258 8.66683 |
30. | 4 21 1976 32.14906 2103.053 7.651145 8.165973 |
|-------------------------------------------------------------------|
31. | 4 21 1977 41.02214 7137.254 8.873083 8.037266 |
32. | 4 22 1973 8.161633 3503.907 8.161633 . |
33. | 4 22 1974 14.72498 708.6408 6.563349 8.161633 |
34. | 4 22 1975 23.5616 6881.662 8.836616 7.362491 |
35. | 4 22 1976 31.99608 4603.092 8.434484 7.853866 |
|-------------------------------------------------------------------|
36. | 4 23 1973 7.741401 2301.694 7.741401 . |
37. | 4 23 1974 16.46914 6171.731 8.727735 7.741401 |
38. | 4 23 1975 25.31552 6949.196 8.846381 8.234568 |
39. | 4 23 1976 33.43942 3374.159 8.123901 8.438506 |
40. | 4 23 1977 41.70048 3870.21 8.261064 8.359855 |
|-------------------------------------------------------------------|
41. | 4 24 1973 6.883958 976.4836 6.883958 . |
42. | 4 24 1974 16.06504 9711.645 9.181081 6.883958 |
43. | 4 24 1975 20.86186 121.125 4.796823 8.032519 |
44. | 4 24 1976 29.60941 6295.22 8.747546 6.953954 |
45. | 4 24 1977 37.32881 2251.61 7.719401 7.402352 |
|-------------------------------------------------------------------|
46. | 4 25 1973 9.168204 9587.393 9.168204 . |
47. | 4 25 1974 17.24205 3209.424 8.073847 9.168203 |
48. | 4 25 1975 26.35163 9041.464 9.109576 8.621025 |
49. | 4 25 1976 33.93297 1961.261 7.581343 8.783875 |
50. | 4 26 1973 9.121167 9146.875 9.121167 . |
|-------------------------------------------------------------------|
51. | 4 26 1974 14.24649 168.2284 5.125322 9.121167 |
52. | 4 26 1975 22.91317 5806.194 8.66668 7.123245 |
53. | 4 26 1976 32.06535 9434.988 9.152181 7.637723 |
54. | 4 27 1973 9.038897 8424.475 9.038897 . |
55. | 4 27 1974 18.17181 9254.969 9.132915 9.038897 |
|-------------------------------------------------------------------|
56. | 4 27 1975 26.71581 5135.824 8.543996 9.085907 |
57. | 4 27 1976 35.66273 7684.242 8.946927 8.90527 |
58. | 4 28 1973 5.557983 259.2992 5.557983 . |
59. | 4 28 1974 14.39899 6911.973 8.84101 5.557982 |
60. | 4 28 1975 23.11866 6122.161 8.71967 7.199497 |
|-------------------------------------------------------------------|
61. | 4 28 1976 31.86491 6287.054 8.746248 7.706221 |
62. | 4 28 1977 40.50319 5643.624 8.638282 7.966228 |
63. | 4 29 1973 8.723305 6144.452 8.723305 . |
64. | 4 29 1974 16.62382 2698.66 7.900511 8.723305 |
65. | 4 29 1975 22.47868 348.9263 5.854861 8.311908 |
|-------------------------------------------------------------------|
66. | 4 29 1976 31.53843 8602.024 9.059752 7.492892 |
67. | 4 30 1973 8.181468 3574.097 8.181468 . |
68. | 4 30 1974 15.791 2017.341 7.609536 8.181469 |
69. | 4 30 1975 24.78041 8017.713 8.989408 7.895502 |
70. | 4 30 1976 32.15665 1597.559 7.376233 8.260138 |
|-------------------------------------------------------------------|
71. | 4 31 1973 8.915335 7445.277 8.915335 . |
72. | 4 31 1974 17.48354 5261.7 8.56821 8.915334 |
73. | 4 31 1975 26.4948 8194.775 9.011252 8.741772 |
74. | 4 31 1976 34.55143 3154.643 8.056631 8.831599 |
75. | 4 31 1977 40.42806 356.6065 5.876633 8.637857 |
|-------------------------------------------------------------------|
76. | 4 32 1973 7.625723 2050.263 7.625723 . |
77. | 4 32 1974 14.93475 1493.72 7.309025 7.625723 |
78. | 4 32 1975 18.28811 28.59864 3.353359 7.467374 |
79. | 4 32 1976 26.65056 4283.178 8.362451 6.096036 |
80. | 4 33 1973 8.879726 7184.824 8.879726 . |
|-------------------------------------------------------------------|
81. | 4 33 1974 17.91346 8381.08 9.033732 8.879727 |
82. | 4 33 1975 25.44116 1858.82 7.527697 8.95673 |
83. | 4 33 1976 34.52919 8848.767 9.088034 8.480386 |
84. | 4 33 1977 43.13614 5469.507 8.606944 8.632298 |
85. | 4 34 1973 8.760368 6376.462 8.760368 . |
|-------------------------------------------------------------------|
86. | 4 34 1974 17.25675 4897.037 8.496386 8.760368 |
87. | 4 34 1975 24.90948 2106.372 7.652722 8.628378 |
88. | 4 34 1976 33.81373 7363.224 8.904253 8.303159 |
89. | 4 35 1973 9.026129 8317.598 9.026129 . |
90. | 4 35 1974 18.18443 9492.906 9.1583 9.026129 |
|-------------------------------------------------------------------|
91. | 4 35 1975 27.09295 7394.67 8.908515 9.092215 |
92. | 4 35 1976 36.06257 7860.632 8.969623 9.030982 |
93. | 4 36 1973 8.206132 3663.345 8.206132 . |
94. | 4 36 1974 16.67481 4763.205 8.468676 8.206133 |
95. | 4 36 1975 25.04704 4325.287 8.372233 8.337404 |
|-------------------------------------------------------------------|
96. | 4 36 1976 33.82034 6459.438 8.773297 8.349014 |
97. | 4 D 1973 7.791623 2420.242 7.791623 . |
98. | 4 D 1974 16.88504 8896.526 9.093416 7.791622 |
99. | 4 D 1975 24.04038 1280.932 7.155343 8.44252 |
100. | 4 D 1976 31.33325 1469.777 7.292866 8.013461 |
+-------------------------------------------------------------------+

.

Thank you! My end goal is to regress average annual growth in log of value added per worker by country and industry (isic) between years (2019-1980). For a different data what I did is reading Professor Cox's cond application as follows:

bysort country isic: egen ln_1980= mean (cond(year==1980, ln(val_per_worker),.))
bysort country isic: egen ln_1980= mean (cond(year==2019, ln(val_per_worker),.)) Later I calculated
gen av_ann_growth= (ln_2015-ln_1980)/abs(2015-1980). (the average annual growth) Once, I regress this av_ann_growth on ln_1980, I get the following (controlling for year, industry, and country fixed effects).

Code:

 reg av_ann_growth ln_1980 i.isic1 i.country i.year, robust  Linear regression                               Number of obs     =     46,417                                                 F(114, 46302)     =    5184.15                                                 Prob > F          =     0.0000                                                 R-squared         =     0.5540                                                 Root MSE          =      .0112  ------------------------------------------------------------------------------              |               Robust av_ann_gro~h |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval] -------------+----------------------------------------------------------------      ln_1980 |  -.0144639   .0002282   -63.37   0.000    -.0149113   -.0140165              |        isic1 |          16  |   .0256422   .0006048    42.40   0.000     .0244568    .0268276          17  |  -.0060568   .0001894   -31.97   0.000    -.0064281   -.0056855          18  |  -.0132921   .0003256   -40.83   0.000    -.0139302    -.012654          20  |  -.0023949   .0002952    -8.11   0.000    -.0029735   -.0018163          21  |   .0007609   .0002206     3.45   0.001     .0003285    .0011933          22  |  -.0037764   .0002281   -16.56   0.000    -.0042234   -.0033294          23  |   .0320916   .0005054    63.50   0.000      .031101    .0330823          24  |   .0105373   .0002522    41.79   0.000     .0100431    .0110315          25  |  -.0025594   .0001814   -14.11   0.000    -.0029149   -.0022038          26  |   .0030878    .000173    17.85   0.000     .0027487     .003427          27  |   .0053608   .0002581    20.77   0.000     .0048549    .0058668          28  |  -.0033837    .000161   -21.02   0.000    -.0036992   -.0030682          29  |   .0004632   .0002467     1.88   0.060    -.0000204    .0009468          31  |   .0003658   .0002062     1.77   0.076    -.0000384      .00077          33  |  -.0075173   .0003295   -22.82   0.000    -.0081631   -.0068715          34  |   .0033789   .0002721    12.42   0.000     .0028456    .0039122          36  |  -.0045743    .000214   -21.38   0.000    -.0049937   -.0041549              |      country |          40  |   .0052477   .0001924    27.27   0.000     .0048706    .0056249          56  |   .0029425   .0002745    10.72   0.000     .0024044    .0034806         124  |   .0057026    .000208    27.41   0.000     .0052948    .0061104         144  |  -.0185602   .0007913   -23.45   0.000    -.0201113   -.0170092         152  |  -.0170001    .000469   -36.25   0.000    -.0179194   -.0160808         170  |    -.01504   .0003063   -49.10   0.000    -.0156404   -.0144397         196  |  -.0144011   .0003651   -39.44   0.000    -.0151167   -.0136855         208  |   .0047527   .0003161    15.04   0.000     .0041332    .0053722         218  |  -.0161957   .0003111   -52.05   0.000    -.0168055   -.0155858         242  |  -.0236709   .0004228   -55.99   0.000    -.0244995   -.0228422         246  |   .0019806   .0002331     8.50   0.000     .0015237    .0024375         250  |  -.0023249   .0002051   -11.33   0.000     -.002727   -.0019228         300  |  -.0165873   .0003209   -51.69   0.000    -.0172162   -.0159583         344  |  -.0085419   .0012219    -6.99   0.000    -.0109368    -.006147         348  |  -.0123845   .0003937   -31.45   0.000    -.0131562   -.0116127         352  |  -.0010037   .0004292    -2.34   0.019    -.0018449   -.0001626         356  |  -.0220642   .0006137   -35.96   0.000     -.023267   -.0208614         360  |    -.00497   .0006434    -7.72   0.000    -.0062312   -.0037089         376  |  -.0049149   .0002516   -19.53   0.000    -.0054081   -.0044217         380  |  -.0040007   .0002626   -15.23   0.000    -.0045155   -.0034859         404  |  -.0162886   .0007435   -21.91   0.000    -.0177458   -.0148313         410  |   .0223102   .0003132    71.24   0.000     .0216964     .022924         458  |   -.014243   .0004778   -29.81   0.000    -.0151794   -.0133065         470  |  -.0068744   .0002984   -23.04   0.000    -.0074593   -.0062895         480  |  -.0165557   .0006941   -23.85   0.000    -.0179162   -.0151952         504  |  -.0284459   .0009675   -29.40   0.000    -.0303422   -.0265495         528  |    .003238   .0002506    12.92   0.000     .0027469    .0037292         554  |  -.0028149    .000249   -11.30   0.000    -.0033031   -.0023268         578  |   .0061896   .0001973    31.38   0.000      .005803    .0065763         608  |  -.0211199   .0004625   -45.66   0.000    -.0220265   -.0202133         616  |   -.008483   .0004545   -18.67   0.000    -.0093738   -.0075922         620  |  -.0044148   .0004011   -11.01   0.000    -.0052009   -.0036287         702  |   .0008227   .0006009     1.37   0.171    -.0003551    .0020005         710  |  -.0250015   .0003567   -70.08   0.000    -.0257007   -.0243022         724  |   -.004281   .0001738   -24.63   0.000    -.0046217   -.0039404         752  |   .0019322   .0002342     8.25   0.000     .0014731    .0023913         788  |  -.0268564   .0006664   -40.30   0.000    -.0281625   -.0255502         792  |  -.0214914   .0003391   -63.38   0.000     -.022156   -.0208268         826  |  -.0016445   .0002712    -6.06   0.000     -.002176   -.0011129         840  |    .017782    .000301    59.07   0.000     .0171919     .018372              |         year |        1964  |   2.34e-06   .0007255     0.00   0.997    -.0014196    .0014243        1965  |  -5.36e-06   .0007178    -0.01   0.994    -.0014123    .0014016        1966  |   4.54e-06   .0007189     0.01   0.995    -.0014044    .0014135        1967  |   .0000469   .0007109     0.07   0.947    -.0013465    .0014402        1968  |   .0000122   .0007032     0.02   0.986     -.001366    .0013904        1969  |  -.0001641   .0006975    -0.24   0.814    -.0015313    .0012031        1970  |  -.0000175    .000702    -0.02   0.980    -.0013935    .0013584        1971  |  -9.39e-06   .0007027    -0.01   0.989    -.0013867    .0013679        1972  |  -9.39e-06   .0007027    -0.01   0.989    -.0013867    .0013679        1973  |   .0000463   .0007074     0.07   0.948    -.0013403    .0014328        1974  |   .0000258   .0007126     0.04   0.971    -.0013708    .0014225        1975  |   .0000199   .0007141     0.03   0.978    -.0013796    .0014195        1976  |   .0000172   .0007263     0.02   0.981    -.0014065    .0014408        1977  |   .0000986   .0007192     0.14   0.891    -.0013111    .0015082        1978  |   .0001781   .0007196     0.25   0.805    -.0012324    .0015886        1979  |   .0000264   .0007209     0.04   0.971    -.0013864    .0014393        1980  |   .0000264   .0007209     0.04   0.971    -.0013864    .0014393        1981  |   .0000626   .0006413     0.10   0.922    -.0011943    .0013195        1982  |  -.0000464   .0006423    -0.07   0.942    -.0013054    .0012126        1983  |   .0000839   .0006402     0.13   0.896     -.001171    .0013388        1984  |   .0000865   .0006425     0.13   0.893    -.0011728    .0013458        1985  |  -.0000953   .0006539    -0.15   0.884     -.001377    .0011864        1986  |  -.0001171   .0006535    -0.18   0.858    -.0013979    .0011637        1987  |  -.0000527   .0006548    -0.08   0.936    -.0013361    .0012307        1988  |  -.0001492   .0006539    -0.23   0.820    -.0014308    .0011324        1989  |   -.000099    .000656    -0.15   0.880    -.0013847    .0011867        1990  |  -.0000304   .0006395    -0.05   0.962    -.0012838    .0012231        1991  |  -.0000235   .0006295    -0.04   0.970    -.0012574    .0012104        1992  |   .0000365   .0006087     0.06   0.952    -.0011565    .0012295        1993  |   .0000575   .0006016     0.10   0.924    -.0011217    .0012368        1994  |   8.64e-06   .0006005     0.01   0.989    -.0011684    .0011857        1995  |   .0000562   .0005893     0.10   0.924    -.0010989    .0012113        1996  |   .0000823   .0005893     0.14   0.889    -.0010727    .0012373        1997  |  -.0000522   .0005852    -0.09   0.929    -.0011992    .0010947        1998  |   .0000725   .0005857     0.12   0.901    -.0010754    .0012204        1999  |   .0001266   .0005911     0.21   0.830     -.001032    .0012852        2000  |   .0000841   .0005881     0.14   0.886    -.0010686    .0012367        2001  |   .0000797   .0005918     0.13   0.893    -.0010802    .0012396        2002  |   .0000373   .0005948     0.06   0.950    -.0011285    .0012031        2003  |   6.18e-06   .0005946     0.01   0.992    -.0011592    .0011716        2004  |   .0000486   .0005986     0.08   0.935    -.0011247    .0012218        2005  |   .0001321   .0005987     0.22   0.825    -.0010413    .0013055        2006  |   .0000909   .0006024     0.15   0.880    -.0010897    .0012716        2007  |   .0001609   .0006033     0.27   0.790    -.0010216    .0013435        2008  |   .0001861   .0006101     0.31   0.760    -.0010096    .0013818        2009  |   .0000775   .0006522     0.12   0.905    -.0012007    .0013557        2010  |   .0000308   .0006609     0.05   0.963    -.0012646    .0013262        2011  |   .0001302   .0006664     0.20   0.845     -.001176    .0014363        2012  |   .0001022   .0006757     0.15   0.880    -.0012222    .0014265        2013  |   .0001339   .0006689     0.20   0.841    -.0011772    .0014449        2014  |   .0002441   .0006738     0.36   0.717    -.0010766    .0015648        2015  |   .0002396   .0006882     0.35   0.728    -.0011092    .0015885        2016  |   .0002973   .0006788     0.44   0.661    -.0010331    .0016277        2017  |     .00031   .0006876     0.45   0.652    -.0010377    .0016578        2018  |   .0001147   .0006502     0.18   0.860    -.0011597     .001389        2019  |   .0000524   .0005987     0.09   0.930    -.0011209    .0012258              |.         _cons |   .1779282   .0023894    74.47   0.000      .173245    .1826114

------------------------------------------------------------------------------ Is it normal to get year dummies before 1980? I am just verifying if I am doing the regression properly

Comment

Carlo Lazzaro

Join Date: Apr 2014

Posts: 17084
#30

30 May 2022, 02:01

Unreadable.

Kind regards,
Carlo
(Stata 18.0 SE)
1 like
Comment

Announcement

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment