经管之家App
让优质教育人人可得
立即打开
下面的数据是中国和韩国SITC3分类的7和8的4分位或5分位商品的贸易数据，现在把数据按照SITC3分位数进行归结为几个行业，即7119前三位为711，归结为普通机械制造业，7132、71333、7139前三位为713也为普通机械制造业，我想得到各个行业的贸易额， 我想得到各个行业按年度的贸易额， 现在给出2006年和2005年的数据（有些分位的商品可能不能归入某一类，因为行业不全），希望大家帮帮忙。谢谢大家！
普通机械制造业 711 712 713 714 716 718 731 733 735 737 741 742 743 744 745 746 747 748 749
专用设配制造业 721 722 723 724 725 726 727 728 774 872 881 882 883
交通运输设备制造业 781 782 783 784 785 786 791 792 793
电器机械及器材制造业 771 772 773 775 776 778 813
电子及通信设备制造业 752 761 762 763 764
仪器仪表及文化办公用机械 751 759 871 873 874 884 885
2006年数据
2006 7119 12663177 2006 7128 71771441 2006 7132 122673130 2006 71333 188479787 2006 7139 235127864 2006 714 55857 2006 7169 118425466 2006 71819 16529713 2006 71878 3000 2006 71899 3624231 2006 72119 1389611 2006 72129 2226647 2006 72139 13500 2006 72199 66368 2006 7239 251592429 2006 72439 7867873 2006 72449 2770636 2006 7246 12139353 2006 72488 455709 2006 7249 9801854 2006 7259 2336580 2006 72635 550183 2006 7269 435010 2006 72719 1713 2006 72729 361184 2006 72819 2695781 2006 72839 2086347 2006 7285 81353609 2006 735 62853293 2006 73719 10872385 2006 73729 29787383 2006 73739 8499430 2006 73749 1875248 2006 74128 664423 2006 74135 1613717 2006 74139 525677 2006 74149 20133161 2006 74159 39784202 2006 74172 347528 2006 7419 13112747 2006 7429 17606351 2006 7438 43723885 2006 7439 21421665 2006 74419 65591 2006 7449 17253143 2006 74519 664526 2006 74529 1463542 2006 74539 590369 2006 74568 10663808 2006 74593 1898844 2006 74597 333405 2006 746 65568347 2006 747 175507746 2006 7481 40488347 2006 7482 25033440 2006 7484 34616783 2006 7485 13924984 2006 7486 5734117 2006 7489 34490869 2006 7492 18654256 2006 7499 14272821 2006 759 2896604111 2006 7621 443329 2006 7649 4881152937 2006 77129 201047042 2006 772 2081636560 2006 77313 16436958 2006 77322 120259 2006 77323 3700901 2006 77324 1758089 2006 77423 16000 2006 77429 2580751 2006 776 20194007798 2006 77812 656207587 2006 77822 229964833 2006 77823 130645 2006 77824 1583590 2006 77831 30451510 2006 77833 9639016 2006 77834 63854759 2006 77869 23375486 2006 77879 26492176 2006 77883 75319 2006 77885 3329386 2006 77886 17367284 2006 77889 11042017 2006 784 1539585678 2006 78535 1354702 2006 78536 209840 2006 78537 25790 2006 78689 3268772 2006 79199 1707205 2006 7929 463351 81219 1947927 2006 82112 3897109 2006 87119 672 2006 87139 170522 2006 87149 80273 2006 87199 193564053 2006 87319 3070956 2006 87329 2404660 2006 87412 1535 2006 87414 5423 2006 87426 13652655 2006 87439 3473202 2006 87454 92946 2006 87456 1654868 2006 87469 25007039 2006 87479 53503594 2006 8749 50942210 2006 88112 56002 2006 88113 387744 2006 88123 59968 2006 88124 27216 2006 88134 22873 2006 88136 1709122 2006 88571 4097492
2005年数据
| 2005 | 7119 | 35050176 |
| 2005 | 7128 | 53946483 |
| 2005 | 7132 | 166688099 |
| 2005 | 71333 | 79418185 |
| 2005 | 7139 | 188493879 |
| 2005 | 714 | 14727 |
| 2005 | 7169 | 114277309 |
| 2005 | 71819 | 8269658 |
| 2005 | 71878 | 60075 |
| 2005 | 71899 | 5282240 |
| 2005 | 72119 | 978127 |
| 2005 | 72129 | 1607415 |
| 2005 | 72199 | 62046 |
| 2005 | 7239 | 169481398 |
| 2005 | 72439 | 16206275 |
| 2005 | 72449 | 5576844 |
| 2005 | 7246 | 11250787 |
| 2005 | 72488 | 694041 |
| 2005 | 7249 | 8170397 |
| 2005 | 7259 | 3198267 |
| 2005 | 72635 | 547524 |
| 2005 | 72689 | 12 |
| 2005 | 7269 | 701805 |
| 2005 | 72719 | 12207 |
| 2005 | 72729 | 525745 |
| 2005 | 72819 | 6486844 |
| 2005 | 72839 | 1860930 |
| 2005 | 7285 | 86794928 |
| 2005 | 735 | 56788935 |
| 2005 | 73719 | 492747 |
| 2005 | 73729 | 25067204 |
| 2005 | 73739 | 13572982 |
| 2005 | 73749 | 5604406 |
| 2005 | 74128 | 370329 |
| 2005 | 74135 | 3174664 |
| 2005 | 74139 | 2079175 |
| 2005 | 74149 | 25652065 |
| 2005 | 74159 | 38482648 |
| 2005 | 74172 | 146505 |
| 2005 | 7419 | 9059835 |
| 2005 | 7429 | 13363822 |
| 2005 | 7438 | 27567570 |
| 2005 | 7439 | 18351190 |
| 2005 | 74419 | 3988 |
| 2005 | 7449 | 17045686 |
| 2005 | 74519 | 991041 |
| 2005 | 74529 | 1352822 |
| 2005 | 74539 | 665912 |
| 2005 | 74568 | 8606500 |
| 2005 | 74593 | 1754297 |
| 2005 | 74597 | 261337 |
| 2005 | 746 | 48937502 |
| 2005 | 747 | 135318289 |
| 2005 | 7481 | 24555916 |
| 2005 | 7482 | 16859609 |
| 2005 | 7484 | 33655906 |
| 2005 | 7485 | 8160790 |
| 2005 | 7486 | 4064638 |
| 2005 | 7489 | 23177897 |
| 2005 | 7492 | 17170241 |
| 2005 | 7499 | 14753806 |
| 2005 | 759 | 1897890201 |
| 2005 | 7621 | 2373190 |
| 2005 | 7649 | 4421689926 |
| 2005 | 77129 | 167662915 |
| 2005 | 772 | 1556268593 |
| 2005 | 77313 | 27286003 |
| 2005 | 77322 | 175192 |
| 2005 | 77323 | 4076358 |
| 2005 | 77324 | 1401678 |
| 2005 | 77423 | 33672 |
| 2005 | 77429 | 2949367 |
| 2005 | 776 | 16068679438 |
| 2005 | 77812 | 437894004 |
| 2005 | 77822 | 147517017 |
| 2005 | 77823 | 6646 |
| 2005 | 77824 | 473202 |
| 2005 | 77831 | 42620985 |
| 2005 | 77833 | 9005703 |
| 2005 | 77834 | 53314605 |
| 2005 | 77869 | 22524752 |
| 2005 | 77879 | 31982037 |
| 2005 | 77883 | 1283568 |
| 2005 | 77885 | 5615953 |
| 2005 | 77886 | 6994313 |
| 2005 | 77889 | 9203759 |
| 2005 | 784 | 1641269708 |
| 2005 | 78535 | 1510165 |
| 2005 | 78536 | 457009 |
| 2005 | 78537 | 201873 |
| 2005 | 78689 | 2066859 |
| 2005 | 79199 | 191307 |
| 2005 | 7929 | 215260 |
| 2005 | 88136 | 424983 |
| 2005 | 88571 | 3550718 |
| 2005 | 82111 | 1897 |
| 2005 | 82112 | 6102474 |
| 2005 | 87119 | 245 |
| 2005 | 87139 | 2653 |
| 2005 | 87149 | 14194 |
| 2005 | 87199 | 370190804 |
| 2005 | 87319 | 2439391 |
| 2005 | 87329 | 1344240 |
| 2005 | 87414 | 4417 |
| 2005 | 87426 | 8231100 |
| 2005 | 87439 | 1529834 |
| 2005 | 87454 | 302565 |
| 2005 | 87456 | 1121520 |
| 2005 | 87469 | 14758506 |
| 2005 | 87479 | 30757094 |
| 2005 | 8749 | 32887938 |
| 2005 | 88112 | 92004 |
| 2005 | 88113 | 350627 |
| 2005 | 88123 | 12825 |
| 2005 | 88134 | 6717 |
| 2005 | 81219 | 1485739 |
把你的数据转换为stata格式，存为 trade.dta
变量名称：year sic trade
use "D:\stata9\ado\personal\others\trade.dta",clear
egen av_sic = mean(trade), by(sic)
preserve
duplicates drop sic,force
list year sic av_sic
*-----------------结果----------------
. preserve
. duplicates drop sic,force
Duplicates in terms of sic
(138 observations deleted)
. list year sic av_sic
+--------------------------+
| year sic av_sic |
|--------------------------|
1. | 2006 7119 23856677 |
2. | 2006 7128 62858962 |
3. | 2006 7132 1.447e+08 |
4. | 2006 71333 1.339e+08 |
5. | 2006 7139 2.118e+08 |
|--------------------------|
6. | 2006 714 35292 |
7. | 2006 7169 1.164e+08 |
8. | 2006 71819 12399686 |
9. | 2006 71878 31537.5 |
10. | 2006 71899 4453235.5 |
|--------------------------|
11. | 2006 72119 1183869 |
12. | 2006 72129 1917031 |
13. | 2006 72139 13500 |
14. | 2006 72199 64207 |
15. | 2006 7239 2.105e+08 |
|--------------------------|
16. | 2006 72439 12037074 |
17. | 2006 72449 4173740 |
18. | 2006 7246 11695070 |
19. | 2006 72488 574875 |
20. | 2006 7249 8986125.5 |
|--------------------------|
21. | 2006 7259 2767423.5 |
22. | 2006 72635 548853.5 |
23. | 2006 7269 568407.5 |
24. | 2006 72719 6960 |
25. | 2006 72729 443464.5 |
|--------------------------|
26. | 2006 72819 4591312.5 |
27. | 2006 72839 1973638.5 |
28. | 2006 7285 84074269 |
29. | 2006 735 59821114 |
30. | 2006 73719 5682566 |
|--------------------------|
31. | 2006 73729 27427294 |
32. | 2006 73739 11036206 |
33. | 2006 73749 3739827 |
34. | 2006 74128 517376 |
35. | 2006 74135 2394190.5 |
|--------------------------|
36. | 2006 74139 1302426 |
37. | 2006 74149 22892613 |
38. | 2006 74159 39133425 |
39. | 2006 74172 247016.5 |
40. | 2006 7419 11086291 |
|--------------------------|
41. | 2006 7429 15485087 |
42. | 2006 7438 35645728 |
43. | 2006 7439 19886428 |
44. | 2006 74419 34789.5 |
45. | 2006 7449 17149415 |
|--------------------------|
46. | 2006 74519 827783.5 |
47. | 2006 74529 1408182 |
48. | 2006 74539 628140.5 |
49. | 2006 74568 9635154 |
50. | 2006 74593 1826570.5 |
|--------------------------|
51. | 2006 74597 297371 |
52. | 2006 746 57252925 |
53. | 2006 747 1.554e+08 |
54. | 2006 7481 32522132 |
55. | 2006 7482 20946525 |
|--------------------------|
56. | 2006 7484 34136345 |
57. | 2006 7485 11042887 |
58. | 2006 7486 4899377.5 |
59. | 2006 7489 28834383 |
60. | 2006 7492 17912249 |
|--------------------------|
61. | 2006 7499 14513314 |
62. | 2006 759 2.397e+09 |
63. | 2006 7621 1408259.5 |
64. | 2006 7649 4.651e+09 |
65. | 2006 77129 1.844e+08 |
|--------------------------|
66. | 2006 772 1.819e+09 |
67. | 2006 77313 21861481 |
68. | 2006 77322 147725.5 |
69. | 2006 77323 3888629.5 |
70. | 2006 77324 1579883.5 |
|--------------------------|
71. | 2006 77423 24836 |
72. | 2006 77429 2765059 |
73. | 2006 776 1.813e+10 |
74. | 2006 77812 5.471e+08 |
75. | 2006 77822 1.887e+08 |
|--------------------------|
76. | 2006 77823 68645.5 |
77. | 2006 77824 1028396 |
78. | 2006 77831 36536248 |
79. | 2006 77833 9322359.5 |
80. | 2006 77834 58584682 |
|--------------------------|
81. | 2006 77869 22950119 |
82. | 2006 77879 29237107 |
83. | 2006 77883 679443.5 |
84. | 2006 77885 4472669.5 |
85. | 2006 77886 12180799 |
|--------------------------|
86. | 2006 77889 10122888 |
87. | 2006 784 1.590e+09 |
88. | 2006 78535 1432433.5 |
89. | 2006 78536 333424.5 |
90. | 2006 78537 113831.5 |
|--------------------------|
91. | 2006 78689 2667815.5 |
92. | 2006 79199 949256 |
93. | 2006 7929 339305.5 |
94. | 2006 81219 1793864.3 |
95. | 2006 82112 4632230.7 |
|--------------------------|
96. | 2006 87119 529.66667 |
97. | 2006 87139 114565.67 |
98. | 2006 87149 58246.667 |
99. | 2006 87199 2.524e+08 |
100. | 2006 87319 2860434.3 |
|--------------------------|
101. | 2006 87329 2051186.7 |
102. | 2006 87412 1535 |
103. | 2006 87414 5087.6667 |
104. | 2006 87426 11845470 |
105. | 2006 87439 2825412.7 |
|--------------------------|
106. | 2006 87454 162819 |
107. | 2006 87456 1477085.3 |
108. | 2006 87469 21590861 |
109. | 2006 87479 45921427 |
110. | 2006 8749 44924119 |
|--------------------------|
111. | 2006 88112 68002.667 |
112. | 2006 88113 375371.67 |
113. | 2006 88123 44253.667 |
114. | 2006 88124 27216 |
115. | 2006 88134 17487.667 |
|--------------------------|
116. | 2006 88136 1281075.7 |
117. | 2006 88571 3915234 |
118. | 2005 72689 12 |
119. | 2005 82111 1897 |
三位sic处理过程：
use "D:\stata9\ado\personal\others\trade.dta",clear
rename sic sic0
tostring sic0, gen(sicstr)
gen sic3 = substr(sicstr,1,3)
destring sic3, gen(sic)
egen av_sic = mean(trade), by(sic)
duplicates drop sic,force
format av_sic %18.3f
list year sic av_sic
*------------结果-----------------
| year | sic | av_sic |
| 2006 | 711 | 23856676.5 |
| 2006 | 712 | 62858962 |
| 2006 | 713 | 163480157.3 |
| 2006 | 714 | 35292 |
| 2006 | 716 | 116351387.5 |
| 2006 | 718 | 5628152.833 |
| 2006 | 721 | 906244.857 |
| 2006 | 723 | 210536913.5 |
| 2006 | 724 | 7493376.9 |
| 2006 | 725 | 2767423.5 |
| 2006 | 726 | 446906.8 |
| 2006 | 727 | 225212.25 |
| 2006 | 728 | 30213073.17 |
| 2006 | 735 | 59821114 |
| 2006 | 737 | 11971473.13 |
| 2006 | 741 | 11081905.43 |
| 2006 | 742 | 15485086.5 |
| 2006 | 743 | 27766077.5 |
| 2006 | 744 | 8592102 |
| 2006 | 745 | 2437200.25 |
| 2006 | 746 | 57252924.5 |
| 2006 | 747 | 155413017.5 |
| 2006 | 748 | 22063608 |
| 2006 | 749 | 16212781 |
| 2006 | 759 | 2397247156 |
| 2006 | 762 | 1408259.5 |
| 2006 | 764 | 4651421432 |
| 2006 | 771 | 184354978.5 |
| 2006 | 772 | 1818952577 |
| 2006 | 773 | 6869429.75 |
| 2006 | 774 | 1394947.5 |
| 2006 | 776 | 18131343618 |
| 2006 | 778 | 70844236.62 |
| 2006 | 784 | 1590427693 |
| 2006 | 785 | 626563.167 |
| 2006 | 786 | 2667815.5 |
| 2006 | 791 | 949256 |
| 2006 | 792 | 339305.5 |
| 2006 | 812 | 1793864.333 |
| 2006 | 821 | 3474647.25 |
| 2006 | 871 | 63153244.67 |
| 2006 | 873 | 2455810.5 |
| 2006 | 874 | 14856150.69 |
| 2006 | 881 | 318412.118 |
| 2006 | 885 | 3915234 |
非常感谢你的回复。我还有几个问题，请指教，三位sic的数据，如果多年的数据，程序怎么改一下了，如果711 712 713 714 716 718 等三位数代码的的贸易额再进一步加总作为 普通机械制造业的贸易额，应如何做。非常感谢，麻烦你了。
use "D:\stata9\ado\personal\others\trade.dta",clear
rename sic sic0
tostring sic0, gen(sicstr)
gen sic3 = substr(sicstr,1,3)
destring sic3, gen(sic)
* 三位行业代码
preserve
egen av_sic = mean(trade), by(sic)
duplicates drop sic,force
format av_sic %18.3f
list year sic av_sic
restore
* 一位行业代码
preserve
gen sic1 = floor(sic/100)
egen av_sic1 = mean(trade), by(sic1)
duplicates drop sic1,force
format av_sic1 %18.3f
list year sic1 av_sic1
* --------一位行业代码结果--------------
+-----------------------------+
| year sic1 av_sic1 |
|-----------------------------|
1. | 2006 7 338219245.710 |
2. | 2006 8 16834825.451 |
+-----------------------------+
* 其他的你要看看相应命令的帮助文件作相应的修改。进口，吸收，这是中国人学习的过程，呵呵
[此贴子已经被作者于2007-11-2 10:39:56编辑过]
扫码加好友，拉您进群
全部版块
我的主页
收藏
