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, statalist.org is already up and running.


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

Re: st: renaming variables from first observation


From   Abhimanyu Arora <abhimanyu.arora1987@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: renaming variables from first observation
Date   Thu, 25 Aug 2011 10:50:22 +0200

Yes Nick, precisely, my values in the first observation were not
legal. What I meant by storing values in a macro was something like a
horizontal -levelsof- command. Once I obtain the values in a single
macro I thought of simply using your and Jeroen Weesie's -renvars-.

But the map option seems not that easy to understand, perhaps because
I find `quotes' confusing sometimes. One needs to have a string
expression in the parentheses while using the map option but I see
that the expression in your example is in `quotes', normally used for
macros. Would be really great if you could clarify this fundamental
issue.

Many thanks
Abhimanyu


. list in 1

     +--------------------------------------------------------------------------------------------------------------------+
  1. |        var1 |        var2 |         var3 |         var4 | var5
| var6 | var7 | var8 | var9 | var10 | var11 | var12 |
     | Series Code | Series Name | Country Code | Country Name | 2000
| 2001 | 2002 | 2003 | 2004 |  2005 |  2006 |  2007 |
     |---------------------------------------------------------+----------------------------------------------------------|
     |                          var13                          |
                   var14                           |
     |                           2008                          |
                    2009                           |
     +--------------------------------------------------------------------------------------------------------------------+

On Thu, Aug 25, 2011 at 10:35 AM, Nick Cox <njcoxstata@gmail.com> wrote:
> Already answered, but not correctly. You could e.g. use the first word
> of the first value. This works:
>
> . l
>
>     +------------------------------+
>     | var1   var2             var3 |
>     |------------------------------|
>  1. | Frog   Toad   Venomous snake |
>  2. |    1      2                3 |
>     +------------------------------+
>
> . renvars , map(`=word("@", 1)')
>
> . l
>
>     +------------------------------+
>     | Frog   Toad         Venomous |
>     |------------------------------|
>  1. | Frog   Toad   Venomous snake |
>  2. |    1      2                3 |
>     +------------------------------+
>
> Nick
>
> On Thu, Aug 25, 2011 at 9:25 AM, Abhimanyu Arora
> <abhimanyu.arora1987@gmail.com> wrote:
>> I caught the mistake, thanks to -set trace on-. 'Code' is the second
>> word of my observation of the first variable and of course a variable
>> name has to be single worded. But my question on possibility of using
>> Nick's -renvars- remains.
>> Best regards
>> Abhimanyu
>>
>>
>> On Thu, Aug 25, 2011 at 10:07 AM, Abhimanyu Arora
>> <abhimanyu.arora1987@gmail.com> wrote:
>>> Good morning statalist
>>> I would like to rename my variables var1-var14 to the corresponding
>>> values from the first observation.
>>> I followed the post on
>>> http://www.stata.com/statalist/archive/2004-07/msg00009.html and
>>> modified it for my purpose.
>>>
>>> but I got this error
>>>
>>> . forvalues k = 1/14  {
>>>  2.   local newname  = var`k'[1]
>>>  3.   ren var`k'  `newname'
>>>  4. }
>>>
>>> Code not allowed
>>>
>>> Also is it posible to store the values of an observation in a macro?
>>> Perhaps I could then use Nick Cox's -renvars-?
>>>
>>> Cheers
>>> Abhimanyu
>
> *
> *   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/


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