最近也是在用merge合并数据,该帖子真的帮了我好多啊。现在把我自己的合并命令写出来,供大家参考,如果有不妥的地方还望大家指教,互相学习。
import excel "/Users/xxx/Documents/stata/growth2008.xls", sheet("Sheet1") firstrow
duplicates report
duplicates drop
save /Users/xxx/Documents/stata/growth2008.dta
clear
import excel "/Users/xxx/Documents/stata/2008.xlsx", sheet("??") firstrow
encode code,gen(code1)
drop code
rename code1 code
duplicates report
duplicates drop
merge 1:1 code using "/Users/xxx/Documents/stata/growth2008.dta",gen(merge_growth)
clear
注:在stata 14.0MP for Mac下进行.
|