Re: st: data transformation or probably reshape

[Christopher Baum <kit.baum@bc.edu>]

<>
On May 12, 2012, at 2:33 AM, Prakash wrote:

> 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

Stata Tip 45, "Getting those data into shape", Baum & Cox, speaks to that point:

http://ideas.repec.org/a/tsj/stataj/v7y2007i2p268-271.html

Kit


Kit Baum   |   Boston College Economics & DIW Berlin   |   http://ideas.repec.org/e/pba1.html
                             An Introduction to Stata Programming  |   http://www.stata-press.com/books/isp.html
  An Introduction to Modern Econometrics Using Stata  |   http://www.stata-press.com/books/imeus.html


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