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/