[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]
Re: st: RE: speeding up program
Wow, thanks Scott, that did it!! I love Stata!
Quoting Scott Merryman <firstname.lastname@example.org>:
> > -----Original Message-----
> > From: email@example.com [mailto:owner-
> > firstname.lastname@example.org] On Behalf Of Patricia Sourdin
> > Sent: Tuesday, October 26, 2004 7:27 PM
> > To: 'email@example.com'
> > Subject: st: speeding up program
> > 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.
> How about -collapse (sum) salary, by(hhid memid)-
> Hope this helps,
> * 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: