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
ERM model for Endogenous treatment effect with nointeract optionI am trying estimate treatment effect models using ERM command in Stata 15. However, it has been sho…
Regressor not found in a loop with existing variable.Hello, I am trying to run this loop to generate F* variables. When I run the loop it stops because i…
Randomly generating new list of room mates and room numbers from an existing listHello, I have a data set with 3 columns that has pairs of roommates with their current room number.…
Problem with rename in a loopHello I am trying to rename some variables within a loop, but it returns me error. I have some varia…
Joint correspondence analysisWhat do the dimensions in joint correspondence analysis indicate? …
Subscribe to:
Post Comments (Atom)
0 Response to Rename Variables using a loop
Post a Comment