Bookmark and Share

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]

Re: st: AW: Reorganization of pael data


From   [email protected]
To   [email protected]
Subject   Re: st: AW: Reorganization of pael data
Date   Wed, 14 Apr 2010 12:58:32 -0400


Hello Martin,

I now downloaded the ado-file to be able to use the command "collapse (firstname)". In its description it says that one has to tsset the data before being able to use the new operator. But whenever I try to do so (by giving the command: tsset year), stata comes up with an error criticiszing that there are repeated time values in the data. And this is the problem I'm trying to get rid of ....

-----Original Message-----


rom: Martin Weiss <[email protected]>
To: [email protected]
Sent: Wed, Apr 14, 2010 6:48 pm
Subject: RE: st: AW: Reorganization of pael data



<>


" Maybe you could you collapse with if and by?"




I think there was enough -by()- to go around in my line

*******
collapse (firstnm) var1 var2, by(country year)
*******

What do you want to add to that? What kind of -if- qualifier do you have in
mind?


HTH
Martin

-----Original Message-----
From: [email protected] [mailto:[email protected]]
On Behalf Of Abhimanyu Arora
Sent: Mittwoch, 14. April 2010 18:27
To: [email protected]
Subject: RE: st: AW: Reorganization of pael data

Maybe you could you collapse with if and by?
Abhimanyu

-----Original Message-----
From: [email protected] [mailto:[email protected]]
On Behalf Of [email protected]
Sent: woensdag 14 april 2010 18:06
To: [email protected]
Subject: 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/


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


© Copyright 1996–2018 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index