Good morning
My problem is the following.
I would like to rename my variables using a loop.
My initial situation is this:
I have a set of variables with this name v1 v2 v3 .... v235
I would like to rename these variables for groups, but assigning each group of variables the same dates, from 2013 to 2019.
So as a final result I would like this:
REVENUES 2013
REVENUES 2014
REVENUES 2015
REVENUES 2016
REVENUES 2017
REVENUES 2018
REVENUES 2019
EBITDA 2013
EBITDA 2014
EBITDA2015
EBITDA 2016
EBITDA 2017
EBITDA2018
EBITDA2019
........
as code I had thought of using this:
local y = 2013
foreach v of var * {
rename (v1-v7) REVENUES`y '
rename (v8-v14) EBITDA`y '
.....
......
local ++ y
}
But unfortunately it doesn't work (I'm a newbie in Stata).
Thank you for any answers and help!
Related Posts with Rename Variables using a loop
Error calculating margins after melogit (could not calculate numerical derivatives -- discontinuous region with missing values encountered)Hello all, I am having trouble calculating margins after running a melogit with 3 levels. The comma…
Graphing problemI collapsed my data for it to include count, mean and a dummy variable for the category they belong …
Difference-in-Difference analysis after PSMDear statist, I need your help. I am doing work that involves assessing the impact of issuing a spec…
Code for including confidence intervals on both curvesHi all, I am trying to compare a linear vs quadratic predictive margins in one graph. However, I am…
Combining duplicate names into oneHello everyone, I have a dataset containing data about Board Members and it is formatted like this:…
Subscribe to:
Post Comments (Atom)
0 Response to Rename Variables using a loop
Post a Comment