st: R: How to index the variables' name as variable's value?

["Carlo Lazzaro" <carlo.lazzaro@tin.it>]

Dear Qian, the following code may do the trick:

----------------code begins---------------------
input year_1995 year_1996

 8       19
 15      20
 67      76
899     99999
999     288
end

stack  year_1995 year_1996, into(year) clear
rename  year values
rename _stack year
label define year_1995 1 "1995", modify
label define year_1995 2 "1996", modify
label values year year_1995
----------------code ends---------------------

Kind Regards,
Carlo
-----Messaggio originale-----
Da: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] Per conto di econqian
Inviato: giovedì 10 novembre 2011 8.26
A: statalist@hsphsun2.harvard.edu
Oggetto: st: How to index the variables' name as variable's value?

Hi, all 
    How to transform the following variables:

year1995	year1996
8	19
15	20
67	76
899	99999
999	288

into the format as this:
8	year1995
15	year1995
67	year1995
899	year1995
999	year1995
19	year1996
20	year1996
76	year1996
99999	year1996
288	year1996


Many thanks in advance,
Qian


--
View this message in context:
http://statalist.1588530.n2.nabble.com/How-to-index-the-variables-name-as-va
riable-s-value-tp6980776p6980776.html
Sent from the Statalist mailing list archive at Nabble.com.
*
*   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/