-collapse-
alternatively,
bysort read race : replace write = sum(write)
by read race : keep if _n == _N
Nick
[email protected]
Jake Herb
> I have duplicate observations in my dataset but rather
> than deleting them using "dups" for example, I'd like
> to combine them and summarize a certain variable.
>
> For instance, I have:
>
> obs# read race write
> 1 40 1 30
> 2 40 1 70
>
> Which are duplicate based on the variables "read" and
> "race". I'd like to combine the two observations into
> one observation, which sums the "write" variable, so
> at the end of the day I have in the dataset:
>
> obs# read race write
> 1 40 1 100
>
*
* 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/
