楼主: cuslton
615 5

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

  • 0关注
  • 0粉丝

初中生

61%

还不是VIP/贵宾

-

0%
威望
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进行添加？数据附件如下。谢谢大家了！
二维码

扫码加我 拉你入群

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

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

分享0
关键词：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

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

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

  215. append using `a'
  216. 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 命令
返回列表
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 我要注册

本版微信群
加好友,备注jltj
拉您入交流群

京ICP备16021002号-2 京B2-20170662号 京公网安备 11010802022788号 论坛法律顾问：王进律师 知识产权保护声明   免责及隐私声明

GMT+8, 2026-2-9 09:14