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]
AW: st: AW: Reorganization of pael data
From
"Martin Weiss" <[email protected]>
To
<[email protected]>
Subject
AW: st: AW: Reorganization of pael data
Date
Wed, 14 Apr 2010 18:21:13 +0200
<>
Your desired outcome is what I get from:
*************
drop _all
inp byte(country:mylabel year:mylabel2 /*
*/ var1 var2 var3), auto
A x 1 . .
A y 2 . .
A x . 3 .
A y . 4 .
A x . . 5
A y . . 6
end
collapse (firstnm) var*, /*
*/ by(country year)
list, noo
*************
HTH
Martin
-----Ursprüngliche Nachricht-----
Von: [email protected] [mailto:[email protected]] Im Auftrag von [email protected]
Gesendet: Mittwoch, 14. April 2010 18:06
An: [email protected]
Betreff: Re: st: AW: Reorganization of pael data
Thanks to your help, Martin, I got rid of my initial probelm, but
unfortunately I'm still not totally happy with the result.
Now my dataset looks like follows:
country year var1 var2 var3
A x 1 . .
A y 2 . .
A x . 3 .
A y . 4 .
A x . . 5
A y . . 6
But I would like to have all the observations for the different
variables of the same country and year to appear in the same row, like
A x 1 3 5
A y 2 4 6
Thanks in advance
Mareike
-----Original Message-----
From: Martin Weiss <[email protected]>
To: [email protected]
Sent: Wed, Apr 14, 2010 11:59 am
Subject: 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: [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/
*
* 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/