Foreach Loop to Rename Variable

[Craig Yang]

Dear all,

I was trying to use foreach loop to rename variables, I wanted to names of the variables to be like Capacity1, Capacity2, Capacity3...How ever I got a error message as shown below:

Will appreciate if I could get any help on this!

Thank you so much,
Craig

[daniel klein]

If you are referring to a variable list (i.e., you want Stata expand/unabbreviate a list of variable names), you want

foreach var of varlist varname-varname {

}

However, you do not need a loop here. You want

rename (varname-varname) (Capacity#) , addnumber

For future posts, please use CODE delimiters (as I have done) not screenshots to present Stata code and output.

Best
Daniel

[Nick Cox]

One good thing about your variable names is that they are evocative. I recommend using that detail in variable labels if you are not doing so already.

[Craig Yang]

Hi Daniel,

Thank you for your help, I appreciate it! It worked perfectly. And will change to the CODE next time, didn't know this rule before.

Thank you,
Craig

[Craig Yang]

Hi Nick, thank you for your suggestion. That is what I did. :-)