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
General Lasso ConfusionI ran a lasso regression on my data and it does not reach the r^2 that a regression of my own design…
Storing Bootstrapped P-valuesHi everyone, I'm trying to obtain bootstrapped p-values for a regression, and store the p-values for…
matching equal observations spread across two different variablesHi all, I wish to match the observations of assignment with equal observations from serial. For exa…
Deleting a categoryHi I have 5 categories of a variable (education). I want to delete one category 'don't know'. Can an…
How to change the color on the x, y axes labelsHow is the health of friends. One question please: How to change the color on the x, y axes I want w…
Subscribe to:
Post Comments (Atom)
0 Response to Rename Variables using a loop
Post a Comment