st: Reorganization of pael data

["Mareike" <MareikeHahr@aol.com>]

Dear Statalist,

I have a panel dataset that is structured the following way:

country variable year observation
  A        var1   x   obs_A_var1_x
  A        var1   y   obs_A_var1_y
  A        var2   x   obs_A_var2_x
  A        var2   y   obs_A_var2_y
  B        var1   x   obs_B_var1_x
   .
   .
   .

But I want it to be structured as followed:

country year var1 var2
    A    x
    A    y
    B    x
    B    y

Is there a command for transposing the data like that?

Thanks in advance

Mareike

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