MySQL不同行记录合并,stata如何将两年不同数据库合并且不自动覆盖被合并库中相同的变量...

* Example generated by -dataex-. To install: ssc install dataex

clear

input double(pid fid16 fid14 age) float year

100051502 100051 100051 50 2016

120009102 100160 100160 25 2016

130005103 100286 100286 38 2016

130167104 100531 130167 31 2016

130299106 100569 100569 71 2016

130517102 100782 130517 42 2016

130630103 100879 130630 26 2016

130681103 100920 130681 27 2016

130813104 101021 130813 32 2016

130815105 101023 130815 35 2016

130896107 101129 101129 26 2016

130897103 101130 101130 22 2016

140122105 101303 140122 18 2016

140519105 101581 140519 27 2016

140838103 101802 140838 25 2016

411737103 102161 189590 22 2016

210223103 102448 210223 24 2016

210547103 102666 210547 29 2016

210638104 102730 210638 29 2016

210727103 102783 210727 27 2016

210966105 102888 102888 37 2016

211093102 102992 102992 81 2016

211233103 103169 211233 38 2016

211584103 103465 211584 30 2016

211775101 103614 103614 58 2016

211934103 103766 103766 19 2016

103788501 103788 103788 29 2016

220098103 103924 103924 34 2016

220195103 103952 220195 33 2016

230016102 104182 230016 23 2016

230103103 104256 230103 25 2016

230624103 104690 230624 25 2016

310912103 105492 105492 36 2016

312144431 106335 106335 59 2016

211940104 106601 106601 59 2016

320111102 106605 320111 53 2016

320107104 106761 106761 26 2016

330067104 106867 330067 29 2016

330187104 106945 330187 26 2016

350005105 107388 350005 20 2016

340342104 107643 107643 30 2016

360172101 107684 360172 30 2016

370089102 107911 370089 51 2016

360278103 108165 108165 25 2016

360320103 108211 108211 27 2016

370115104 108244 108244 35 2016

108476551 108476     -8 31 2016

108660552 108660     -8 43 2016

410353105 108807 410353 27 2016

370611104 108908 108908 28 2016

370707104 108979 108979 37 2016

410046102 109137 109137 57 2016

410134104 109216 109216 29 2016

410881104 109250 410881 42 2016

410969103 109336 410969 34 2016

411010102 109372 411010 51 2016

411044105 109404 411044 25 2016

410426105 109508 109508 27 2016

410447104 109531 109531 19 2016

410695103 109783 109783 27 2016

410708104 109791 109791 29 2016

411631103 109849 411631 23 2016

411739104 109942 411739 28 2016

410865103 109949 109949 32 2016

411774104 109970 411774 39 2016

110003101 110003 110003 45 2016

110006101 110006 110006 56 2016

110009102 110009 110009 60 2016

110011101 110011 110011 43 2016

110015101 110015 110015 50 2016

110020101 110020 110020 71 2016

110021102 110021 110021 76 2016

110024102 110024 110024 80 2016

110026104 110026 110026 72 2016

110030431 110030 110030 68 2016

110033104 110033 110033 48 2016

110035101 110035 110035 64 2016

110038104 110038 110038 59 2016

110043103 110043 110043 31 2016

110047102 110047 110047 39 2016

110050101 110050 110050 85 2016

110051102 110051 110051 84 2016

110052101 110052 110052 56 2016

110057101 110057 110057 66 2016

110060102 110060 110060 66 2016

110061102 110061 110061 56 2016

110062101 110062 110062 58 2016

110066102 110066 110066 73 2016

110067101 110067 110067 30 2016

110069101 110069 110069 65 2016

110071101 110071 110071 66 2016

110072102 110072 110072 68 2016

110073101 110073 110073 83 2016

110074101 110074 110074 68 2016

110076101 110076 110076 56 2016

110078103 110078 110078 78 2016

110079102 110079 110079 44 2016

110081102 110081 110081 61 2016

110083103 110083 110083 38 2016

110084101 110084 110084 58 2016

end

label values pid pid

label values fid16 fid16

label values fid14 fid14

label def fid14 -8 "不适用", modify

label values age cfps_age