Should work once you take the comma out of -group()-.
But the intermediate step of creating
an extra variable, while it does no harm, is
unnecessary.
Nick
[email protected]
> -----Original Message-----
> From: [email protected]
> [mailto:[email protected]]On Behalf Of Thomas
> Trikalinos (.Mac)
> Sent: 28 May 2004 17:22
> To: [email protected]
> Subject: Re: st: RE: collapse panel data for each year
>
>
> 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" <[email protected]>
> >> Reply-To: [email protected]
> >> To: <[email protected]>
> >> 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
> >> [email protected]
> >>
> >> 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/
>
*
* 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/
