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
generating new variable that incorporates population weightsHi, I have panel data with country-year unit of analysis for 100 countries and 100 years. I have thr…
How to add star to show the statistical significance of coefficient in regression matrix outputHi, Statalists, I have got a question on adding star after coefficient in the matrix output of a re…
Integrated Calibration Index (ICI)Dear colleagues, I there a way to calculate the "Integrated Calibration Index (ICI)" in STATA after…
error in copying table from stata to excelArray ----------------------- copy starting from the next line ----------------------- Code: * Exam…
time-dummy increases R-squaredHi, I am currently working with a pseudo-panel and to counter autocorrelation i am using a year-dum…
Subscribe to:
Post Comments (Atom)
0 Response to Mistake in loop for renaming variables of several datafiles
Post a Comment