楼主: cuslton
615 5

[数据管理求助] 求助数据合并问题 [推广有奖]

  • 0关注
  • 0粉丝

初中生

61%

还不是VIP/贵宾

-

威望
0
论坛币
10 个
通用积分
0
学术水平
0 点
热心指数
0 点
信用等级
0 点
经验
63 点
帖子
2
精华
0
在线时间
32 小时
注册时间
2016-1-19
最后登录
2020-1-6

楼主
cuslton 发表于 2019-10-23 23:52:46 |AI写论文

+2 论坛币
k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群
赵安豆老师微信:zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

感谢您参与论坛问题回答

经管之家送您两个论坛币!

+2 论坛币
之前数据是更新到了2017年,现在又有了2018的数据,请问如何利用stata来根据id进行添加?数据附件如下。谢谢大家了!
二维码

扫码加我 拉你入群

请注明:姓名-公司-职位

以便审核进群资格,未注明则拒绝

关键词:stata 数据合并

18年总资产.xlsx
下载链接: https://bbs.pinggu.org/a-2959788.html

110.63 KB

10-17年资产.xlsx

102.45 KB

沙发
黃河泉 在职认证  发表于 2019-10-24 15:43:49
你若要问程序,永远附上相关资料 (请不要用截图);若附上资料,永远用 dataex 印出资料。
•        先 ssc install dataex (并见说明),将原始 Stata 资料中具有”代表性”的一部分资料列出,以供有意回答者实验之用,并能提供具体操作指令。
•        请参考说明 https://bbs.pinggu.org/thread-5048204-1-1.html

藤椅
cuslton 发表于 2019-10-24 18:48:46
黃河泉 发表于 2019-10-24 15:43
你若要问程序,永远附上相关资料 (请不要用截图);若附上资料,永远用 dataex 印出资料。
•        先 ssc  ...
10-17年资产数据:
  1. * Example generated by -dataex-. To install: ssc install dataex
  2. clear
  3. input str6 id byte year double asset
  4. "000002" 10 2.15638e+11
  5. "000002" 11 2.96208e+11
  6. "000002" 12 3.78802e+11
  7. "000002" 13 4.79205e+11
  8. "000002" 14 5.08409e+11
  9. "000002" 15 6.11296e+11
  10. "000002" 16 8.30674e+11
  11. "000002" 17 1.16535e+12
  12. "000004" 10 184219435.7
  13. "000004" 11 196307219.5
  14. "000004" 12 192913568.9
  15. "000004" 13 242152079.6
  16. "000004" 14 338282581.1
  17. "000004" 15 398673507.1
  18. "000004" 16   223716293
  19. "000004" 17 268844295.6
  20. "000005" 10  1293608601
  21. "000005" 11  1260586163
  22. "000005" 12  1319702418
  23. "000005" 13  1188653949
  24. "000005" 14  1366663808
  25. "000005" 15  2194008790
  26. "000005" 16  2527235374
  27. "000005" 17  2912099984
  28. "000006" 10  8568302263
  29. "000006" 11  8321974063
  30. "000006" 12  9343430260
  31. "000006" 13  9968160025
  32. "000006" 14 11753217519
  33. "000006" 15 12703504209
  34. "000006" 16 13170385530
  35. "000006" 17 13139931309
  36. "000007" 10 332421568.1
  37. "000007" 11 362415187.9
  38. "000007" 12 789680006.5
  39. "000007" 13 657511920.8
  40. "000007" 14   680925247
  41. "000007" 15 480364514.3
  42. "000007" 16 514367695.1
  43. "000007" 17   442675593
  44. "000008" 10 77932220.92
  45. "000008" 11 77236597.09
  46. "000008" 12 613829627.3
  47. "000008" 13 626625950.7
  48. "000008" 14 674028043.8
  49. "000008" 15  3589354695
  50. "000008" 16  8192656626
  51. "000008" 17 10678315230
  52. "000009" 10 10024647811
  53. "000009" 11 11785629478
  54. "000009" 12 13171329971
  55. "000009" 13 13611801388
  56. "000009" 14 14725495571
  57. "000009" 15 18113933206
  58. "000009" 16 21622925841
  59. "000009" 17 27109464910
  60. "000010" 10 212201435.7
  61. "000010" 11 238257898.6
  62. "000010" 12 239779833.3
  63. "000010" 13  1027789609
  64. "000010" 14 804218432.4
  65. "000010" 15  5174655864
  66. "000010" 16  4865760551
  67. "000010" 17  3105153052
  68. "000011" 10  2913281354
  69. "000011" 11  3499608314
  70. "000011" 12  3950705939
  71. "000011" 13  3873252714
  72. "000011" 14  3883288145
  73. "000011" 15  4379763486
  74. "000011" 16  6654356144
  75. "000011" 17  5393331549
  76. "000012" 10 12469619167
  77. "000012" 11 15281391077
  78. "000012" 12 14335809746
  79. "000012" 13 15078866777
  80. "000012" 14 15284388305
  81. "000012" 15 15657180160
  82. "000012" 16 17146815630
  83. "000012" 17 19535002368
  84. "000014" 10  1589755396
  85. "000014" 11  1797309398
  86. "000014" 12  2020502626
  87. "000014" 13  1892715842
  88. "000014" 14  2236734317
  89. "000014" 15  2170514993
  90. "000014" 16  1873814393
  91. "000014" 17  1528276983
  92. "000016" 10 16466895565
  93. "000016" 11 16906453313
  94. "000016" 12 16562917198
  95. "000016" 13 15743284335
  96. "000016" 14 16779359277
  97. "000016" 15 14250367548
  98. "000016" 16 17243119598
  99. "000016" 17 23558735470
  100. "000017" 10 138158078.9
  101. "000017" 11 135746630.9
  102. "000017" 12 162649076.3
  103. "000017" 13 151511429.9
  104. end
复制代码
------------------ copy up to and including the previous line ------------------

Listed 100 out of 3497 observations
Use the count() option to list more

.
18年数据:
  1. * Example generated by -dataex-. To install: ssc install dataex
  2. clear
  3. input str6 id int year double asset
  4. "000002" 2018 1.52858e+12
  5. "000004" 2018 351177470.2
  6. "000005" 2018  3121423379
  7. "000006" 2018 13536728185
  8. "000007" 2018 385709995.5
  9. "000008" 2018 10466364830
  10. "000009" 2018 29849801106
  11. "000011" 2018  5820202138
  12. "000012" 2018 19114234184
  13. "000014" 2018  1917248983
  14. "000016" 2018 32985061889
  15. "000017" 2018 73242960.17
  16. "000019" 2018  6468951794
  17. "000020" 2018 617090153.5
  18. "000021" 2018 15539378940
  19. "000023" 2018  2320492791
  20. "000025" 2018  1658295531
  21. "000026" 2018  3599691650
  22. "000027" 2018 85073895249
  23. "000028" 2018 28930300520
  24. "000029" 2018  4665891514
  25. "000030" 2018 11682128692
  26. "000031" 2018 91171929972
  27. "000032" 2018  2153380723
  28. "000034" 2018 25985451950
  29. "000035" 2018  8808911186
  30. "000036" 2018 10893040699
  31. "000037" 2018  3307148290
  32. "000038" 2018  3246477440
  33. "000039" 2018 1.58884e+11
  34. "000040" 2018 34423044803
  35. "000042" 2018 46050688701
  36. "000043" 2018 13235646080
  37. "000045" 2018  4619203417
  38. "000046" 2018 2.12097e+11
  39. "000048" 2018  5182504078
  40. "000049" 2018  8822025314
  41. "000050" 2018 60036990054
  42. "000055" 2018 10658854134
  43. "000056" 2018 13254846349
  44. "000058" 2018  7128009738
  45. "000059" 2018 32460677530
  46. "000060" 2018 19506332203
  47. "000061" 2018 18999687796
  48. "000062" 2018 10301894440
  49. "000063" 2018 1.29351e+11
  50. "000065" 2018 11447974208
  51. "000066" 2018 16002223273
  52. "000068" 2018  3443687264
  53. "000069" 2018 2.94167e+11
  54. "000070" 2018  7553084393
  55. "000078" 2018 41126743376
  56. "000088" 2018 10335820148
  57. "000089" 2018 13453440336
  58. "000090" 2018 31741153853
  59. "000096" 2018  2646942783
  60. "000099" 2018  5663561786
  61. "000100" 2018 1.92764e+11
  62. "000150" 2018  8274170309
  63. "000151" 2018  2157610693
  64. "000153" 2018  3007997786
  65. "000155" 2018  7229036713
  66. "000156" 2018 14773173503
  67. "000157" 2018 93456651846
  68. "000158" 2018 14142745020
  69. "000159" 2018  2740064974
  70. "000301" 2018 29630939073
  71. "000333" 2018 2.63701e+11
  72. "000338" 2018 2.05276e+11
  73. "000400" 2018 14576908667
  74. "000401" 2018 61993306497
  75. "000402" 2018 1.48527e+11
  76. "000403" 2018  1317556724
  77. "000404" 2018 10093935741
  78. "000407" 2018  6427026617
  79. "000408" 2018  9704086066
  80. "000411" 2018  8992511132
  81. "000413" 2018 72576122860
  82. "000415" 2018 2.85819e+11
  83. "000417" 2018 10511662888
  84. "000418" 2018 23561899126
  85. "000419" 2018  4927503025
  86. "000420" 2018  7140258061
  87. "000421" 2018 11434237474
  88. "000423" 2018 13869959247
  89. "000425" 2018 61249882257
  90. "000426" 2018  8933497776
  91. "000428" 2018  7196445970
  92. "000429" 2018 16295910774
  93. "000430" 2018  2495979398
  94. "000488" 2018 1.05319e+11
  95. "000498" 2018 23891517673
  96. "000501" 2018 22886656917
  97. "000502" 2018 416494054.6
  98. "000503" 2018  1280351320
  99. "000505" 2018  4917148996
  100. "000506" 2018  2532760657
  101. "000507" 2018  6838678093
  102. "000509" 2018 206943839.6
  103. "000510" 2018  1484471995
  104. end
复制代码
------------------ copy up to and including the previous line ------------------
stata初学,不知道这样的数据格式是否正确。谢谢您!

板凳
黃河泉 在职认证  发表于 2019-10-25 11:41:44
cuslton 发表于 2019-10-24 18:48
10-17年资产数据:------------------ copy up to and including the previous line ------------------
...
类似
  1. * Example generated by -dataex-. To install: ssc install dataex
  2. clear
  3. input str6 id byte year double asset
  4. "000002" 10 2.15638e+11
  5. "000002" 11 2.96208e+11
  6. "000002" 12 3.78802e+11
  7. "000002" 13 4.79205e+11
  8. "000002" 14 5.08409e+11
  9. "000002" 15 6.11296e+11
  10. "000002" 16 8.30674e+11
  11. "000002" 17 1.16535e+12
  12. "000004" 10 184219435.7
  13. "000004" 11 196307219.5
  14. "000004" 12 192913568.9
  15. "000004" 13 242152079.6
  16. "000004" 14 338282581.1
  17. "000004" 15 398673507.1
  18. "000004" 16   223716293
  19. "000004" 17 268844295.6
  20. "000005" 10  1293608601
  21. "000005" 11  1260586163
  22. "000005" 12  1319702418
  23. "000005" 13  1188653949
  24. "000005" 14  1366663808
  25. "000005" 15  2194008790
  26. "000005" 16  2527235374
  27. "000005" 17  2912099984
  28. "000006" 10  8568302263
  29. "000006" 11  8321974063
  30. "000006" 12  9343430260
  31. "000006" 13  9968160025
  32. "000006" 14 11753217519
  33. "000006" 15 12703504209
  34. "000006" 16 13170385530
  35. "000006" 17 13139931309
  36. "000007" 10 332421568.1
  37. "000007" 11 362415187.9
  38. "000007" 12 789680006.5
  39. "000007" 13 657511920.8
  40. "000007" 14   680925247
  41. "000007" 15 480364514.3
  42. "000007" 16 514367695.1
  43. "000007" 17   442675593
  44. "000008" 10 77932220.92
  45. "000008" 11 77236597.09
  46. "000008" 12 613829627.3
  47. "000008" 13 626625950.7
  48. "000008" 14 674028043.8
  49. "000008" 15  3589354695
  50. "000008" 16  8192656626
  51. "000008" 17 10678315230
  52. "000009" 10 10024647811
  53. "000009" 11 11785629478
  54. "000009" 12 13171329971
  55. "000009" 13 13611801388
  56. "000009" 14 14725495571
  57. "000009" 15 18113933206
  58. "000009" 16 21622925841
  59. "000009" 17 27109464910
  60. "000010" 10 212201435.7
  61. "000010" 11 238257898.6
  62. "000010" 12 239779833.3
  63. "000010" 13  1027789609
  64. "000010" 14 804218432.4
  65. "000010" 15  5174655864
  66. "000010" 16  4865760551
  67. "000010" 17  3105153052
  68. "000011" 10  2913281354
  69. "000011" 11  3499608314
  70. "000011" 12  3950705939
  71. "000011" 13  3873252714
  72. "000011" 14  3883288145
  73. "000011" 15  4379763486
  74. "000011" 16  6654356144
  75. "000011" 17  5393331549
  76. "000012" 10 12469619167
  77. "000012" 11 15281391077
  78. "000012" 12 14335809746
  79. "000012" 13 15078866777
  80. "000012" 14 15284388305
  81. "000012" 15 15657180160
  82. "000012" 16 17146815630
  83. "000012" 17 19535002368
  84. "000014" 10  1589755396
  85. "000014" 11  1797309398
  86. "000014" 12  2020502626
  87. "000014" 13  1892715842
  88. "000014" 14  2236734317
  89. "000014" 15  2170514993
  90. "000014" 16  1873814393
  91. "000014" 17  1528276983
  92. "000016" 10 16466895565
  93. "000016" 11 16906453313
  94. "000016" 12 16562917198
  95. "000016" 13 15743284335
  96. "000016" 14 16779359277
  97. "000016" 15 14250367548
  98. "000016" 16 17243119598
  99. "000016" 17 23558735470
  100. "000017" 10 138158078.9
  101. "000017" 11 135746630.9
  102. "000017" 12 162649076.3
  103. "000017" 13 151511429.9
  104. end

  105. replace year = year+2000
  106. tempfile a
  107. save `a'

  108. * Example generated by -dataex-. To install: ssc install dataex
  109. clear
  110. input str6 id int year double asset
  111. "000002" 2018 1.52858e+12
  112. "000004" 2018 351177470.2
  113. "000005" 2018  3121423379
  114. "000006" 2018 13536728185
  115. "000007" 2018 385709995.5
  116. "000008" 2018 10466364830
  117. "000009" 2018 29849801106
  118. "000011" 2018  5820202138
  119. "000012" 2018 19114234184
  120. "000014" 2018  1917248983
  121. "000016" 2018 32985061889
  122. "000017" 2018 73242960.17
  123. "000019" 2018  6468951794
  124. "000020" 2018 617090153.5
  125. "000021" 2018 15539378940
  126. "000023" 2018  2320492791
  127. "000025" 2018  1658295531
  128. "000026" 2018  3599691650
  129. "000027" 2018 85073895249
  130. "000028" 2018 28930300520
  131. "000029" 2018  4665891514
  132. "000030" 2018 11682128692
  133. "000031" 2018 91171929972
  134. "000032" 2018  2153380723
  135. "000034" 2018 25985451950
  136. "000035" 2018  8808911186
  137. "000036" 2018 10893040699
  138. "000037" 2018  3307148290
  139. "000038" 2018  3246477440
  140. "000039" 2018 1.58884e+11
  141. "000040" 2018 34423044803
  142. "000042" 2018 46050688701
  143. "000043" 2018 13235646080
  144. "000045" 2018  4619203417
  145. "000046" 2018 2.12097e+11
  146. "000048" 2018  5182504078
  147. "000049" 2018  8822025314
  148. "000050" 2018 60036990054
  149. "000055" 2018 10658854134
  150. "000056" 2018 13254846349
  151. "000058" 2018  7128009738
  152. "000059" 2018 32460677530
  153. "000060" 2018 19506332203
  154. "000061" 2018 18999687796
  155. "000062" 2018 10301894440
  156. "000063" 2018 1.29351e+11
  157. "000065" 2018 11447974208
  158. "000066" 2018 16002223273
  159. "000068" 2018  3443687264
  160. "000069" 2018 2.94167e+11
  161. "000070" 2018  7553084393
  162. "000078" 2018 41126743376
  163. "000088" 2018 10335820148
  164. "000089" 2018 13453440336
  165. "000090" 2018 31741153853
  166. "000096" 2018  2646942783
  167. "000099" 2018  5663561786
  168. "000100" 2018 1.92764e+11
  169. "000150" 2018  8274170309
  170. "000151" 2018  2157610693
  171. "000153" 2018  3007997786
  172. "000155" 2018  7229036713
  173. "000156" 2018 14773173503
  174. "000157" 2018 93456651846
  175. "000158" 2018 14142745020
  176. "000159" 2018  2740064974
  177. "000301" 2018 29630939073
  178. "000333" 2018 2.63701e+11
  179. "000338" 2018 2.05276e+11
  180. "000400" 2018 14576908667
  181. "000401" 2018 61993306497
  182. "000402" 2018 1.48527e+11
  183. "000403" 2018  1317556724
  184. "000404" 2018 10093935741
  185. "000407" 2018  6427026617
  186. "000408" 2018  9704086066
  187. "000411" 2018  8992511132
  188. "000413" 2018 72576122860
  189. "000415" 2018 2.85819e+11
  190. "000417" 2018 10511662888
  191. "000418" 2018 23561899126
  192. "000419" 2018  4927503025
  193. "000420" 2018  7140258061
  194. "000421" 2018 11434237474
  195. "000423" 2018 13869959247
  196. "000425" 2018 61249882257
  197. "000426" 2018  8933497776
  198. "000428" 2018  7196445970
  199. "000429" 2018 16295910774
  200. "000430" 2018  2495979398
  201. "000488" 2018 1.05319e+11
  202. "000498" 2018 23891517673
  203. "000501" 2018 22886656917
  204. "000502" 2018 416494054.6
  205. "000503" 2018  1280351320
  206. "000505" 2018  4917148996
  207. "000506" 2018  2532760657
  208. "000507" 2018  6838678093
  209. "000509" 2018 206943839.6
  210. "000510" 2018  1484471995
  211. end

  212. append using `a'
  213. sort id year
复制代码

报纸
黃河泉 在职认证  发表于 2019-10-25 11:43:38
cuslton 发表于 2019-10-24 18:48
10-17年资产数据:------------------ copy up to and including the previous line ------------------
...
已经回答,但在审查中。基本上,在原始档中,你需要
  1. replace year = year+2000
复制代码
然后利用 append 即可。

地板
蓝色 发表于 2019-10-25 12:12:54
年份改好了
用append 命令

您需要登录后才可以回帖 登录 | 我要注册

本版微信群
加好友,备注jltj
拉您入交流群
GMT+8, 2026-2-9 09:14