So I have 20 .dta files on test score of 9-12 graders during years 2008-2012 (4*5=20). I want to rename v1 and v2 to id and score. Followings are what I wrote. after running it v1 is erased and instead i see <stata_dta><header><release>118</release><byteorder>LSF</byteorder><K>, v2 is completely gone, and program gives "v2 not found" error. I check data before running and all variables are there. I am completely new to STATA, do not anything about coding, so may have made basic mistakes.
local myfilelist : dir . files"*.dta"
foreach file of local myfilelist {
drop _all
insheet using `file'
rename (v1 v2) (id score)
save "`outfile'", replace
}
P.S. these .dta files were produced by following code:
local myfilelist : dir . files"*.csv"
foreach file of local myfilelist {
drop _all
insheet using `file'
local outfile = subinstr("`file'",".csv","",.)
save "`outfile'", replace
}
local myfilelist : dir . files"*.dta"
foreach file of local myfilelist {
drop _all
insheet using `file'
rename (v1 v2) (id score)
save "`outfile'", replace
}
P.S. these .dta files were produced by following code:
local myfilelist : dir . files"*.csv"
foreach file of local myfilelist {
drop _all
insheet using `file'
local outfile = subinstr("`file'",".csv","",.)
save "`outfile'", replace
}
Comment