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   "Martin Weiss" <[email protected]>
To   <[email protected]>
Subject   RE: st: AW: Reorganization of pael data
Date   Wed, 14 Apr 2010 19:19:23 +0200

<>


You said the error was ""(fisrtnm) invalid statistic"" which led me to believe spelling could be an issue.

Note you should disclose any -version- <11.


HTH
Martin


-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of [email protected]
Sent: Mittwoch, 14. April 2010 19:15
To: [email protected]
Subject: Re: st: AW: Reorganization of pael data


No, double checked the spelling.  Maybe the reason is that I'm working 
wih an older version of Stata (version 9.2) which doesn't know "firstnm"

-----Original Message-----
From: Martin Weiss <[email protected]>
To: [email protected]
Sent: Wed, Apr 14, 2010 7:06 pm
Subject: RE: st: AW: Reorganization of pael data



<>

Probably b/c you misspelled it...


HTH
Martin


-----Original Message-----
 From: [email protected] 
[mailto:[email protected]]
On Behalf Of [email protected]
Sent: Mittwoch, 14. April 2010 19:05
To: [email protected]
Subject: Re: st: AW: Reorganization of pael data

collapse is , but not the operator firstnm. So I always got the error
"(fisrtnm) invalid statistic"



-----Original Message-----
From: Martin Weiss <[email protected]>
To: [email protected]
Sent: Wed, Apr 14, 2010 7:01 pm
Subject: RE: st: AW: Reorganization of pael data



<>

-collapse- is shipped with official Stata. What does -which collapse-
give you?


HTH
Martin


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


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/


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