Bookmark and Share

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]

st: data transformation or probably reshape


From   Prakash Singh <prakashbhu@gmail.com>
To   statalist <statalist@hsphsun2.harvard.edu>
Subject   st: data transformation or probably reshape
Date   Fri, 11 May 2012 20:07:35 +0530

Hello all
I have world Bank time series data downloaded in a format given below

Country country-code Variable variable-code year1 year2 year3...... year10
 where below year we have the value for particular variable for that year.

but I am interested to have my data in the following form


Country country-code Variable1 variable2
                                       year1        year1
                                       year 2       year2
                                      year3        year3
                                        ......         ......
                                      year10     year10
i.e. for a variable value should stack below each other according to
increasing value of year panel format.

I thought of reshape command but I am not clear how to do this in this case

I have access to stata10


Please suggest me something


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


© Copyright 1996–2018 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index