从单一文件夹中读取多个规律命名的CSV文件,并append\me

2018-11-01  本文已影响0人  Kevin_d316

cd "D:\SUNBOW"

forv i=2001/2014 {

clear

    insheet using `i'indegree.csv

    save `i'indegree.dta, replace

}

***append

clear

use 2000indegree.dta, clear

forv i=2001/2014 {

    append using `i'indegree.dta

}

save indegree2000-2014.dta, replace

***merge

***merge前对变量名重命名

clear

use 2000indegree.dta, clear

rename x indegree2000

save 2000indegree.dta,replace

clear

forv i=2001/2014 {

    use `i'indegree.dta

rename x indegree`i'

save `i'indegree.dta,replace

}

***merge

clear

use 2000indegree.dta, clear

forv i=2001/2014 {

    merge 1:1 v1 using `i'indegree.dta

drop _merge

}

save 2000-2014indegreemerged.dta, replace

上一篇下一篇

猜你喜欢

热点阅读