I am trying to merge 12 files with similar files name. Each file just has one variable.
I was following this thread (similar to what I want): https://www.statalist.org/forums/for...=1552507542959
Basing on that I ran my code but I get an error message: II2.dta not found.
The code that I ran was:
Code:
use "C:\Users\rk0022\Desktop\Env Eco\II1.dta", clear forval i = 2/12 { merge 1:1 country year using II`i', nogen drop _merge }
Also, I tried this code:
Code:
use "C:\Users\rk0022\Desktop\Env Eco\II1.dta", clear local files II2 II2 II4 II5 II5 II6 II7 II8 II9 II10 II11 II12 local vars var2 var3 var4 var5 var6 var7 var8 var8 var9 var10 var11 var12 forval i = 2/12 { local f : word `i' of `files' local v : word `i' of `vars' merge 1:1 country year using `files', keepusing(`v') drop _merge }
Could you please tell me where am I going wrong?
Thank you.
Ritika
0 Response to Merging multiple files in a loop
Post a Comment