Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: RE: collapse panel data for each year


From   Thomas Trikalinos (.Mac) <ttrikalin@mac.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: RE: collapse panel data for each year
Date   Fri, 28 May 2004 19:21:33 +0300

Would this be better?

. egen tralala = group(country, year)
. collapse x y , by(tralala)


On May 28, 2004, at 19:14, sarah smith wrote:

Hi Nick,
If I use collapse as below:

collapse x y, by(country)

It is not useful for me since I need to run collapse for the data portions in each of the 20 years.
Best,
Sarah




From: "Nick Cox" <n.j.cox@durham.ac.uk>
Reply-To: statalist@hsphsun2.harvard.edu
To: <statalist@hsphsun2.harvard.edu>
Subject: st: RE: collapse panel data for each year
Date: Fri, 28 May 2004 16:53:46 +0100

Once you've -collapse-d the data once, you
have a new dataset, so I can't see that
you'd want to do this in a loop.

At first glance you just need to include
the variable for country in the -by()- option.

Nick
n.j.cox@durham.ac.uk

sarah smith
>
> I have panel data for several industries in 40 countries for
> 20 years. For
> each year, I am trying to collapse the data by country. I
> tried to use
> foreach and forvalues commands, but could not work it out. I would
> appreciate if you can help me.

*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/
_________________________________________________________________
FREE pop-up blocking with the new MSN Toolbar – get it now! http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/

*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/


*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index