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: RE: data transformation or probably reshape


From   Nick Cox <[email protected]>
To   "'[email protected]'" <[email protected]>
Subject   st: RE: data transformation or probably reshape
Date   Fri, 11 May 2012 16:49:29 +0100

-reshape- is pertinent. This kind of problem, including World Bank format, is discussed in detail in 

SJ-7-2  dm0031  . . . . . . . . .  Stata tip 45: Getting those data into shape
        . . . . . . . . . . . . . . . . . . . . . . . C. F. Baum and N. J. Cox
        Q2/07   SJ 7(2):268--271                                 (no commands)
        tip on applications of reshape and solving data
        management problems

which as it is more than 3 years old is accessible to all as a .pdf at 

http://www.stata-journal.com/sjpdf.html?articlenum=dm0031

Nick 
[email protected] 

Prakash Singh

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


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