Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: RE: Combining duplicate observations rather than deleting them


From   "Nick Cox" <n.j.cox@durham.ac.uk>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: RE: Combining duplicate observations rather than deleting them
Date   Mon, 21 Feb 2005 19:45:52 -0000

-collapse- 

alternatively, 

bysort read race : replace write = sum(write) 
by read race : keep if _n == _N 

Nick 
n.j.cox@durham.ac.uk 

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/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index