Dear Statalists,
I have ten identically structured excel files which correspond to ten different years. All files include 18 variables which indentify an agegroup. For example the first agegroup variable is called "Underfiveyears", the second "Fivetonineyears" and the last "Overeightyyears". I want to use a loop which imports the excel files and renames these agegroup variables into age1, age2,...age18. Therefore, I used this loop:
forvalues i=1990/1999 {
import excel file`i', firstrow clear
foreach var of varlist Underfiveyears-Overeightyyears {
local x= `x'+1
rename `var' age`x'
save file_`i',replace
}
}
The problem is, that the command works for the first file but the numbering of the variables just continues for the following files instead of beginning with age1,...,. For example, the last agegroup variable in the first file is renamed age18 but the first agegroup variable in the second file is renamed age19 instead of age1.
Can someone help me to find a solution?
Thank you in advance!
Related Posts with Mistake in loop for renaming variables of several datafiles
Comparing xtpedroni and xtcointtest pedroniEach of these implementations of the Pedroni testing procedure produce vastly different results. The…
Replacing the nth word of a stringHi All, I am trying to replace the nth word of a string and i am struggling to find an efficient wa…
Position in ranking as dependent variableWhat model and Stata code could help see if a categorical independente variable could help me predic…
What does xtset do exactly?Hi Statalisters If I set a dataset to a panel dataset using xtset, what exactly is STATA doing? For…
Running multinomial probit regressions with multiple dependent variable optionsHi, This might be more of an advanced econometrics question rather than a Stata question. I have 13…
Subscribe to:
Post Comments (Atom)
0 Response to Mistake in loop for renaming variables of several datafiles
Post a Comment