Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
From | "Martin Weiss" <martin.weiss1@gmx.de> |
To | <statalist@hsphsun2.harvard.edu> |
Subject | st: AW: Reorganization of pael data |
Date | Wed, 14 Apr 2010 11:59:03 +0200 |
<> 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/