Hello.
I need to reshape a World Development Indicators dataset. Currently, it is organized as follows.
country var year2000 year2001 year2002
Angola GDP 100 102 104
Angola Export 20 21 20
Algeria GDP 200 202 204
Algeria Export 10 11 10
country and var are string variables.
The dataset has 26500 rows and 43 columns (53 countries, 37 years, 500 variables per country). I could reduce this if the size is a problem.
I would need the dataset to be organized as follows
country year GDP Export
Angola 2000 100 20
Angola 2001 102 21
Angola 2002 104 20
Algeria 2000 200 10
Algeria 2001 202 11
Algeria 2002 204 10
This dataset would have 502 columns (country, year and 500 variables), and 1961 rows (53 countries times 37 years).
I tried the usual reshape commands but had no success. I am sure I am missing something.
Your help would be most appreciated. Thanks in advance.
Marco
____________________________________________________________________________________
You rock. That's why Blockbuster's offering you one month of Blockbuster Total Access, No Cost.
http://tc.deals.yahoo.com/tc/blockbuster/text5.com
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
