Dear Yumin and Dev,
> World Development Indicators has about 200 variables
> for each country. Sometime many words are contained in
> one variable name such as "Export share in GDP, %."
> Can I still use "reshape" under such circumstances?
>
I think Yumin can prepare a variable list at first,
namely a dataset with (variable number) x 3 construction
containing
1."exact expression in the original database"
(here i want to name "origname"),
2. identification number, and
3. name you use practically.
In the previous three countries and three variables example,
variables were lined horizontally by "vid" number.
reshape wide v, i(cyid) j(vid)
I think you can apply "vid" to the many variables
with "_merge origname" beforehand.
Toyoto
*
* 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/