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

st: RE: rename a lot of variables


From   "Nick Cox" <n.j.cox@durham.ac.uk>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: RE: rename a lot of variables
Date   Fri, 5 Nov 2004 10:08:43 -0000

In the case of p1 

foreach v of var *p1* { 
	local new : subinstr local v "p1" "" 
	rename `v' `new'p1 
} 

Minimalists might prefer 

foreach v of var *p1* { 
	rename `v' `: subinstr local v "p1" ""'p1 
} 

(neither tested)

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

> -----Original Message-----
> From: owner-statalist@hsphsun2.harvard.edu
> [mailto:owner-statalist@hsphsun2.harvard.edu]On Behalf Of Guanghui Li
> Sent: 05 November 2004 00:45
> To: statalist@hsphsun2.harvard.edu
> Subject: st: rename a lot of variables
> 
> 
> Dear all,
> I have personnel data from 6 companies and the maximum number 
> of employees
> in those companies is 18. There are 27 variables for each 
> employee. The data
> is shaped in the wide form, therefore, I have 18*27=486 
> variables in total.
> 
> I would like to reshape the data to a long form. However, the 
> way these
> variables are named is hard for me to do the reshape command.
> c1p1a1     c1p1a2     .....
> 
> c2p1
> 
> c3p1
> 
> c4p1e1     c4p1e2    .....
> 
> c5yp1
> 
> c05mp1
> 
> .....
> The p1 in each of those variable names represent employee 1.  
> Sometimes p1
> is at the end of the variable names, but most of the times it 
> is in the
> middle of the variable names (342 in total) . I would like to 
> move p1 to the
> end of the variable name so that I could define 1-18 to be 
> the "j" in the
> reshape command.
> 
> I have checked the commands "rename" "renvars" "renpfix" 
> "rensfix", but none
> of them seems to be able to do this in a quick and easy way. 
> Please give me
> some suggestions.
> 
> Thank you in advance.
> 
> Guanghui Li
> 
> 
> 
> 
> *
> *   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/
> 

*
*   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