Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: st: renaming variables from first observation
From
Abhimanyu Arora <[email protected]>
To
[email protected]
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 <[email protected]> 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
> <[email protected]> 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
>> <[email protected]> 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/