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

st: Combining duplicate observations rather than deleting them


From   Jake Herb <jake10002002@yahoo.com>
To   statalist@hsphsun2.harvard.edu
Subject   st: Combining duplicate observations rather than deleting them
Date   Mon, 21 Feb 2005 11:40:18 -0800 (PST)

Dear Users,
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

Any thoughts/suggestions would be greatly appreciated!
Thanks,
Jake



		
__________________________________ 
Do you Yahoo!? 
Take Yahoo! Mail with you! Get it on your mobile phone. 
http://mobile.yahoo.com/maildemo 
*
*   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