Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
st: AW: Reorganization of pael data
From
"Martin Weiss" <[email protected]>
To
<[email protected]>
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: [email protected]
[mailto:[email protected]] Im Auftrag von Mareike
Gesendet: Mittwoch, 14. April 2010 11:36
An: [email protected]
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/