Hi,

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
 }
even with this I found an error.


Could you please tell me where am I going wrong?

Thank you.

Ritika