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