a search on duplicates find several items; the one that
you probably want is -dups-
Rich Goldstein
"Rodrigo Brice�o" wrote:
>
> Dear friends. I really advanced a lot understanding the logical of merge and
> the logical of my databases. I found that the solution that I need is to
> merge using my four variables that identify each database. I read the FAQ
> like Buzz Burhans recommended to me and I wish to have some insight to do
> one more thing with my bases. If in my 4 databases there are duplicates, is
> there a procedure to combine all the duplicates in one unique observation.
> For example if the variable is income, there appears several observations
> depending of the source of income (salary, transfers, etc.), so how can I
> add all the observations for household 1 in one unique observation? and how
> can I execute the procedure for all the remain duplicates?
> Thanks for reading!
>
> Rodrigo
*
* 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/