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]

From |
Nick Cox <njcoxstata@gmail.com> |

To |
statalist@hsphsun2.harvard.edu |

Subject |
Re: st: Changing part of variable names |

Date |
Tue, 24 May 2011 14:34:46 +0100 |

Thanks for the mention. Note that -renvars- is a joint production by Jeroen Weesie and myself. However, in this case I don't see that you need anything other than -rename-. Let's suppose that the files are called -file1- to -file11-. forval i = 1/11 { use file`i' rename income?? income save, replace } For a more complicated set of filenames, use e.g. -fs- (SSC) followed by foreach f in `r(files)' { use "`f'" ... } Nick On Tue, May 24, 2011 at 2:16 PM, Maarten Buis <maartenlbuis@gmail.com> wrote: > On Tue, May 24, 2011 at 2:27 PM, <live@gmx.net> wrote: >> I have the following problem: I have 11 separate Stata-files, each containing a cross-section for one specific year. The variables in each corss-section are the same, except for the names, which carry a year tag in the variable name, so there's e.g. income07 in the cross-section for 2007, and income08 in the one for 2008. Now, I want to transform these 11 files into one panel data set. Therefore, I need to rename the variables in each cross section (several hundreds per cross-section) such that they have the same name, i.e. income07 and income08 need to become incomeXX -otherwise "append" wouldn't work. How do I do this with a loop? Further complication: the year tag can be anywhere in the variable name, things like in07come, income07 or inco07me are possible. > > The easiest solution is probably to use Nick Cox's -renvars-. You can > find it by typing in Stata -findit renvars-. > * * 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: Changing part of variable names***From:*live@gmx.net

**References**:**st: Changing part of variable names***From:*live@gmx.net

**Re: st: Changing part of variable names***From:*Maarten Buis <maartenlbuis@gmail.com>

- Prev by Date:
**Re: st: Changing part of variable names** - Next by Date:
**st: foreach for interaction term** - Previous by thread:
**Re: st: Changing part of variable names** - Next by thread:
**Re: st: Changing part of variable names** - Index(es):