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

st: Extract variable name in order to change it, iteratively


From   Jeppe Warberg Larsen <jeppewl@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   st: Extract variable name in order to change it, iteratively
Date   Tue, 2 Aug 2005 14:14:46 +0200

I have a wide data structure. Each observation consists of a unique
identifier (say, id) and some series of annual variables with a
two-digit suffix (running in different intervals). Like this:

id var1_88 var1_89 ... var1_02 var2_92 var2_93 ... var2_02
var3_...................................

Now I want to reshape it to long, but stata fails to read the
two-digit values after the turn of century (00 01 02), so I need to
rename all varibles to a four-digit year.

foreach var of varlist var1_88-var100_02{
	//save name of variable in a local string
	//do nessecary string manipulation (I can do that)
	//rename var 
}

My problem seems to be:
1) extracting the name of the current variable
2) rename

Do you understand what I'm asking?
I'd be glad if someone can help, and please don't tell me that it
would be easier to do this manually, because I will need to do this
operation many times...

Jeppe W. Larsen

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