st: Reshape question

["Mike Kim" <kalisperos@gmail.com>]

Dear listers,

My data looks like the following and I want to reshape it from wide to long.
There are many more similar variables with the same pattern. Is there any
easy way to reshape?

id a_gg b_gg c_gg d_gg e_gg  a_hh b_hh c_hh d_hh e_hh  a_ii b_ii c_ii d_ii
e_ii   ..
1     1        5        3        1      2        4        1        1
5         1        3      1      1     4      1  
2    4        1        1        2       1        1        1        2
1         1         1      1      5     1      1  
3    2        1        2        1       1        1        5        1
1         3         1      1      1     3      1  
..

The data format I want is:

id country gg  hh  ii  ..
1     a       
1     b
1     c
1     d
1     e
2     a       
2     b
2     c
2     d
2     e
3     a       
3     b
3     c
3     d
3     e
......

Thank you in advance.
Mike.


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