Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down on April 23, and its replacement, is already up and running.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: st: Renaming variables using foreach

From   Nick Cox <>
Subject   Re: st: Renaming variables using foreach
Date   Tue, 26 Jun 2012 23:32:07 +0100

On the first para, I think I see what you mean: they are too long to
be practical.


On Tue, Jun 26, 2012 at 11:22 PM, Nick Cox <> wrote:
> This is contradictory. If the variable names in some other software
> are too long to be handled in Stata, how can they renamed in Stata?
> You can't even import them. Conversely, names imported in Stata, while
> possibly truncated, do not need to renamed.
> The FAQ spells out
> The current version of Stata is 12.1. Please specify if you are using
> an earlier version; otherwise, the answer to your question is likely
> to refer to commands or features unavailable to you.
> See also
> for reminders of what else you should know.
> Nick
> On Tue, Jun 26, 2012 at 11:08 PM, Suryadipta Roy <> wrote:
>> Dear Nick and Steve,
>> Thank you very much the help! Actually, I forgot to mention that I am
>> using Stata 11.2, and what I really wanted to do was to "label" the
>> variables with the existing variable names (since the current variable
>> names from the World Develepment Indicators are too long). The idea
>> was thus to change the long names to var1, var2, etc, and then use
>> -label- . I would now check if I can somehow manage to get the
>> variables labelled by their variable names (obviously I can do that
>> manually as well) in Stata 11.
>> And, Nick's solution works and will read into it very carefully.
>> Thanks again!
>> Suryadipta.
>> On Tue, Jun 26, 2012 at 5:47 PM, Steve Nakoneshny <> wrote:
>>> 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.

*   For searches and help try:

© Copyright 1996–2016 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index