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/
