Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

RE: st: rename variables UPPERCASE to lowercase


From   "Nick Cox" <n.j.cox@durham.ac.uk>
To   <statalist@hsphsun2.harvard.edu>
Subject   RE: st: rename variables UPPERCASE to lowercase
Date   Mon, 26 Apr 2004 15:46:25 +0100

The keyword -of- is essential. Try 

foreach var of varlist QUOTA-UALDWK2 {
	rename `var' `=lower("`var'")'
}

Nick 
n.j.cox@durham.ac.uk 

Ada Ma
> 
> Thanks for all the suggestions.  May be becoz I'm <expletive deleted> - I 
> tried both Nick 
> Winter's and Nick Cox's version and neither works.
> 
> When I used these commands:
> 
> 
> Stata returns says "Invalid Syntax" r(198).  I tried several 
> versions of it and 
> none of it work.
> 
> I think I'll stick to (and try to memorise) the "simpler" _renvars_!
> 
> Nick Cox wrote:
> 
> > Independently, Nick Winter has suggested what
> > I suggested as a solution using only official 
> > commands. However, his version is correct 
> > in remembering the " " in 
> > 
> >   . rename `v' `=lower("`v'")'
> > 
> > and mine is incorrect. 
> > 
> > Nick 
> > n.j.cox@durham.ac.uk 
> > 
> > Nick Winter
> > 
> > 
> >>>I need to convert all variable names from UPPERCASE to 
> >>
> >>lowercase.  How can 
> >>
> >>>I do that?
> >>
> >>         . foreach var of varlist * {
> >>         . rename `v' `=lower("`v'")'
> >>         . }
> >>
> >>
> >>This will cycle through every variable in the dataset, 
> >>renaming each to its 
> >>equivalent, all-lower-case self.
> >>
> >>Or I'm sure there are canned solutions out there, but this is 
> >>a case, for 
> >>me at least, where knowing a bit about -foreach- and local 
> >>macros is far 
> >>easier than remembering which canned solution does this 
> little job...

*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   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   |   What's new   |   Site index