Re: st: Renaming variables using foreach

[Steve Nakoneshny <scnakone@ucalgary.ca>]

Suryadipta,

Your loop fails as you are asking for each variable in your varlist to be renamed var1. Assuming you're using Stata 12, you don't need a loop to solve this issue. You can achieve your desired result (or some reasonable facsimile) using -rename-:

rename (Agricultural_raw_materials_expor - Value_lost_due_to_electrical_ou) var#, addnumber

See -help rename- for more details.

Steve


On 2012-06-26, at 3:20 PM, Suryadipta Roy wrote:

> Dear Statalisters,
> 
> I am currently learning looping in Stata and is stuck with the
> following problem: I have about 150 variables that I want to rename as
> var1 var2, etc.. upto var 150. I tried the following:
> 
> local i = `i' + 1
> foreach x of varlist  Agricultural_raw_materials_expor -
> Value_lost_due_to_electrical_out  {
> 2. rename `x' var`i'
> 3. }
> 
> I am getting the following error message:
> var1 already defined
> r(110);
> 
> I find that only the first variable is renamed as "var1" and then the
> loop stopped running. Any help is greatly appreciated.
> 
> Sincerely,
> Suryadipta.
> *
> *   For searches and help try:
> *   http://www.stata.com/help.cgi?search
> *   http://www.stata.com/support/statalist/faq
> *   http://www.ats.ucla.edu/stat/stata/


*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/