Wow, thanks Scott, that did it!! I love Stata!
Quoting Scott Merryman <[email protected]>:
> > -----Original Message-----
> > From: [email protected] [mailto:owner-
> > [email protected]] On Behalf Of Patricia Sourdin
> > Sent: Tuesday, October 26, 2004 7:27 PM
> > To: '[email protected]'
> > Subject: st: speeding up program
> >
> <snip>
> >
> > In other words, I have monthly salary data on each individual (memid) in
> > each
> > household(hhid). My data set has about 60,000 observations.
> > I have written the following command to sum salary across month for each
> > individual
> >
> > by hhid memid,sort: egen quart_inc=sum(salary)
> >
> > which works fine except then I have to get rid of all the duplicate totals
> > created for each individual.
> <snip>
>
> Patricia,
>
> How about -collapse (sum) salary, by(hhid memid)-
>
> Hope this helps,
> Scott
>
>
>
> *
> * 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/
