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
Mediation Analysis in stata with non continuous mediator- Test statistics?Dear all, I need to run two mediation analysis for a research project and after having studied the …
Issue with calculating rolling betas for 36 months periodHi, hope this question and description is easy to comprehend I have gathered data for monthly retur…
Loop stops at the second value of listI'm working on a loop to unzip many zipfiles which have in common title two values: 603 and 634. Hen…
[Help] Appending Using LoopingHello Stata wizards I am trying to append around ~35 excel files into 1 dta files. Luckily all the …
Event study using princeton event study tool : event happening on weekend droppedDear Statalist, I am using Stata 12 and you can find an example of my dataset at the end of the mes…
Subscribe to:
Post Comments (Atom)
0 Response to Rename Variables using a loop
Post a Comment