Hi, I have an problem merge in stata,i have a file 1 have 3 visit, file 2 have 2 t_visit, when i merge using id the merging file have t_visit 1 is repeated why is that. I want a missing in that place how can i solve this problem FileFile 1 +----------------------------------+ | id visit date | |----------------------------------| 1. | ABRC46082913 2 01 Dec 05 | 2. | ABRC46082913 1 10 Aug 05 | 3. | ABRC46082913 3 . | Fil File 2 +------------------------------------+ | id t_visit trus_date | |------------------------------------| 1. | ABRC46082913 2 30 Nov 05 | 2. | ABRC46082913 1 10 Aug 05 | After merge file 1 and file 2 +--------------------------------------------------------+ | id visit date t_visit trus_date | |--------------------------------------------------------| 1. | ABRC46082913 3 . 2 30 Nov 05 | 2. | ABRC46082913 1 10 Aug 05 1 10 Aug 05 | 3. | ABRC46082913 2 01 Dec 05 1 10 Aug 05 -------------- |(why this date repeated) here should be missing