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
|