Thanks a lot! It worked after a bit of tinkering needed to ensure that specifically the observations from a fuller dataset are kept,
warm regards,
Ekaterina
In message <000001ca3491$b05652b0$1102f810$@[email protected]> [email protected] writes:
>
> <>
>
> " I cannot use duplicates I think because the two datasets do not have
> exactly the same variables"
>
>
>
> The -duplicates- suite of commands allows you to specify a -varlist- (which
> should contain the variables common to both datasets), so give it a try...
>
>
> HTH
> Martin
>
> -----Ursprüngliche Nachricht-----
> Von: [email protected]
> [mailto:[email protected]] Im Auftrag von Ekaterina
> Hertog
> Gesendet: Sonntag, 13. September 2009 18:37
> An: [email protected]
> Betreff: st: How to get rid of duplicate individuals in a dataset?
>
> Dear all,
>
> I had two datasets of partially overlapping individuals (and their
> characteristics) which I merged into 1 file using append. At the moment
> cannot think of how to get rid of the individuals which appear twice in the
> resulting dataset because of the overlap in the initial datasets. I cannot
> use duplicates I think because the two datasets do not have exactly the same
> variables. To be precise variables of dataset1 are a subset of variables of
> dataset2. As a result when I merged them into 1 dataset the entries for the
> same customer coming from dataset1 is not exactly identical to the entry
> coming from dataset2. I need to remove all the entries for those individuals
> from dataset1 which also appear in dataset2 and keep all the non-overlapping
> individuals.
>
> I will be very grateful for any advice,
> Warm regards,
> Ekaterina
>
> *
> * For searches and help try:
> * http://www.stata.com/help.cgi?search
> * http://www.stata.com/support/statalist/faq
> * http://www.ats.ucla.edu/stat/stata/
>
>
> *
> * For searches and help try:
> * http://www.stata.com/help.cgi?search
> * http://www.stata.com/support/statalist/faq
> * http://www.ats.ucla.edu/stat/stata/
--
Ekaterina Hertog (nee Korobtseva)
Nissan Institute of Japanese Studies
27 Winchester Road, Oxford
OX2 6NA
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
