st: AW: AW: Reorganization of pael data

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

It works!!

Thanks a lot for your help, Martin.

Mareike

-----Ursprüngliche Nachricht-----
Von: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von Martin Weiss
Gesendet: Mittwoch, 14. April 2010 11:59
An: statalist@hsphsun2.harvard.edu
Betreff: st: AW: Reorganization of pael data


<> 

You could also try:


*************

clear*

inp country:mylabel str4 variable int year obs, auto
  A var1   2000   3
  A var1   2001   4
  A var2   2000   7
  A var2   2001   11
  B var1   2000   13
  B var1   2001   32
  B var2   2000   23
  B var2   2001   34
end

compress
list, noo

gen var1=obs if variable=="var1"
gen var2=obs if variable=="var2"

collapse (firstnm) var1 var2, by(country year)
list, noo

*************



HTH
Martin


-----Ursprüngliche Nachricht-----
Von: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von Mareike
Gesendet: Mittwoch, 14. April 2010 11:36
An: statalist@hsphsun2.harvard.edu
Betreff: st: Reorganization of pael data

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/


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


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