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]

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/

**Follow-Ups**:**Re: st: renaming variables from first observation***From:*Nick Cox <njcoxstata@gmail.com>

**References**:**st: renaming variables from first observation***From:*Abhimanyu Arora <abhimanyu.arora1987@gmail.com>

**Re: st: renaming variables from first observation***From:*Abhimanyu Arora <abhimanyu.arora1987@gmail.com>

**Re: st: renaming variables from first observation***From:*Nick Cox <njcoxstata@gmail.com>

- Prev by Date:
**Re: st: renaming variables from first observation** - Next by Date:
**Re: st: Merging files based on name and year** - Previous by thread:
**Re: st: renaming variables from first observation** - Next by thread:
**Re: st: renaming variables from first observation** - Index(es):