发帖
雷达卡
我想将这样两个数据合并：
文件1：
| id | year | ratio |
| 1 | 2009 | 0.2 |
| 1 | 2009 | 0.4 |
| 2 | 2009 | 0.3 |
文件2：
| id | year | price | roe | |
| 1 | 2009 | |||
| 2 | 2009 | |||
| 3 | 2009 |
合并以后希望看到这样：
| id | year | ratio | price | roe | ||
| 1 | ||||||
| 1 | ||||||
| 2 | ||||||
| 3 | 0 |
请问应该用什么命令哇？关键是文件2里面有的id文件1里面根本没有……已经绕晕了。。。谢谢！！
- * Example generated by -dataex-. To install: ssc install dataex
- clear
- input long id float(ratio date price) double mv byte _merge
- 6 .5 18338 11.33 5746386358 3
- 12 .7 18351 19.6 23985267230 3
- 21 .5 18376 12.89 11336993736 3
- 55 .07 18320 9.72 4148363409 3
- 60 .55 18347 27.9 28563796800 3
- 63 .5 18361 44.87 82172055967 3
- 66 1 18376 16.1 8858055780 3
- 157 1.5 18497 26.01 43517331000 3
- 159 1 18350 18.77 4515492274 3
- 338 1 18498 64.48 53714785640 3
- 402 .22 18358 12.13 30097113193 3
- 514 .1 18299 13.58 8608872825 3
- 516 .9 18375 8.52 3199124225 3
- 527 .5 18337 . . 1
- 533 .2 18292 11.17 6430345600 3
- 538 .3 18376 60.4 32256688735 3
- 540 .6 18331 18.53 10578746333 3
- 594 .2 18380 . . 1
- 608 .4 18304 11.16 5977880382 3
- 616 .1 18378 6.89 6221158583 3
- 627 1 18331 7.46 5048890200 3
- 637 .15 18347 9.72 4394076922 3
- 650 .5 18352 20.9 5854304037 3
- 651 .5 18379 28.94 54366466950 3
- 667 .9 18365 8.19 11033190105 3
- 671 1 18334 23.9 4003291419 3
- 671 .6 18499 23.9 4003291419 3
- 683 .5 18361 17.21 8809385771 3
- 690 .5 18295 9.66 11119384500 3
- 713 .2 18303 14.76 3.321e+09 3
- 778 .3 18344 12.43 18328241288 3
- 788 .6 18331 15.33 3988433863 3
- 790 .3 18303 9.17 1830779496 3
- 811 .5 18375 13.36 2343031777 3
- 815 1 18337 10.05 1591920000 3
- 836 .3 18344 9.65 2171233788 3
- 848 .6 18376 26.38 5014468680 3
- 876 .1 18380 13.78 10427345292 3
- 899 .18 18360 8.94 4899406080 3
- 918 .25 18303 16.05 23165818860 3
- 933 .4 18344 36.88 2.766e+10 3
- 936 .7 18502 10.38 4567278691 3
- 939 .6 18282 17.79 6555259200 3
- 950 .5 18324 18.14 7241478749 3
- 961 .5 18326 22.39 17431946847 3
- 969 .8 18337 26.52 11702312794 3
- 978 .3 18347 12.09 2139930000 3
- 982 .5 18505 11.36 1885760000 3
- 983 .3 18352 39.89 96693360000 3
- 1696 .7 18340 18.69 11225594977 3
- 2001 .3 18351 48.9 16726734000 3
- 2001 .5 18501 48.9 16726734000 3
- 2007 .6 18331 55.42 19958293760 3
- 2013 .3 18320 13.72 1763294400 3
- 2018 .2 18333 12.68 3105091080 3
- 2022 .2 18374 21.89 8979962063 3
- 2023 .4 18344 18.24 3431665593 3
- 2024 .5 18337 20.78 96920855050 3
- 2030 .2 18347 15.98 3847472640 3
- 2032 .3 18351 20.8 9236032000 3
- 2035 .3 18331 9.3 1597475880 3
- 2047 .6 18348 9.13 2588724920 3
- 2051 .5 18492 26.98 5.1262e+09 3
- 2054 .4 18500 21.59 4764721281 3
- 2055 .3 18369 15.24 2046699264 3
- 2062 .5 18337 20.07 6.021e+09 3
- 2063 .3 18375 22.77 4501082520 3
- 2064 1 18369 19.08 7044336000 3
- 2068 .3 18318 17.95 3450708000 3
- 2069 1 18316 37.55 8493810000 3
- 2071 .5 18373 10 1.2268e+09 3
- 2073 .5 18352 22.45 11110729500 3
- 2078 1 18374 20.67 10384715422 3
- 2081 .5 18333 30.9 6575396400 3
- 2084 .2 18352 11.46 2670683908 3
- 2087 .4 18472 6.91 1943478960 3
- 2090 1 18344 20.61 2102220000 3
- 2091 .25 18339 21.79 5.2296e+09 3
- 2092 .5 18497 21.83 11719653800 3
- 2093 .5 18320 18.55 4952850000 3
- 2094 .5 18495 11.03 2367160212 3
- 2095 .5 18326 36.97 3.3273e+09 3
- 2097 .5 18372 21.06 5776758000 3
- 2100 .3 18379 22.31 3654668030 3
- 2104 .5 18368 21.11 6201273600 3
- 2106 .3 18348 24.4 8049267200 3
- 2108 .7 18351 36.69 3616900200 3
- 2115 .6 18380 25.8 3459780000 3
- 2118 .7 18296 19.67 2390719338 3
- 2122 1 18345 29.23 17362620000 3
- 2123 .5 18332 37.7 8.4448e+09 3
- 2124 .5 18344 15.71 2152270000 3
- 2127 .6 18330 12.66 2313768946 3
- 2128 .2 18330 27.65 30569060408 3
- 2130 .5 18352 19.33 3151756500 3
- 2131 1 18372 18.67 2810955200 3
- 2138 .5 18474 20.23 2472106000 3
- 2139 .2 18361 16.09 2.2526e+09 3
- 2140 1 18350 41.8 5826326106 3
- 2146 .6 18340 20.71 18556160000 3
- end
- format %tddmy date
- label values _merge _merge
- label def _merge 1 "master only (1)", modify
- label def _merge 3 "matched (3)", modify
这是我采用 merge m:1以后的结果，不知道这样对不对哇？
merge m:1 id using mock2009
Result # of obs.
-----------------------------------------
not matched 1,330
from master 32 (_merge==1)
from using 1,298 (_merge==2)
matched 352 (_merge==3)
-----------------------------------------
主文件是date2010，用来合并的是mock2009
date2010.dta
(5.2 KB)
mock2009.dta
(33.02 KB)
京公网安备 11010802022788号
