I encountered a problem in the process of data merging. I put 5 control variables into 5 sheets of an excel table. After converting the panel data, I want to put the corresponding variable name in each sheet.After changing it, although the variable name has been changed, the dta name has also been changed, and the dta data generated all have become the data in the last sheet. Please help me and answer it, thank you very much! ! ! ! (below is the stata code I wrote)
local x cpi house profits population rgdp
forvalues i = 1/5{
foreach m of local x{
import excel using control.xlsx,sheet(Sheet`i') first clear
reshape long M, i(province) j(year)
rename M `m'
save `m'.dta,replace
}
}
Related Posts with Problems corresponding to variable names in stata double-layer loops
Impute a variable to perform multiple regressionHi, I would like to perform the following multiple regression, w "loglprice" as the dependent varia…
mvreg - post estimationI am using the mvreg command as I have a multivariate regression (3 independent variables regressed …
event studyHi to everyone! I am writing an article with use of event study. Unfortunately I am new to Stata an…
Alternative-Specific Mixed Logit ModelHello, I want to specify a mixed logit model for the decision that migrants take to migrate from t…
Request for helpIs there anyone who can help me create a loop from this: set more off clear all foreach x of numlis…
Subscribe to:
Post Comments (Atom)
0 Response to Problems corresponding to variable names in stata double-layer loops
Post a Comment