Bookmark and Share

Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: data transformation or probably reshape

From   Prakash Singh <>
To   statalist <>
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

*   For searches and help try:

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