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

RE: st: merging datasets with duplicates


From   "Nick Cox" <[email protected]>
To   <[email protected]>
Subject   RE: st: merging datasets with duplicates
Date   Tue, 14 Jan 2003 17:07:39 -0000

Rodrigo Brice�o

> 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?

Richard Goldstein

> a search on duplicates find several items; the one that
> you probably want is -dups-

Please also note for future reference that
Stata 8 includes a new official command,
-duplicates-.

Nick
[email protected]

*
*   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–2024 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index