I am trying to merge two dataset- one dta file consist of 8576 unique observation and another dta file consist of 1187 unique id and 1220 observations. Now as i merge using merge 1:m command, the result is 1189 matched and 7415 from master and 31 from using file are not matched. What i make out is 1189 and 21 makes 1220 observation remaining observation should be 8576 - 1220 = 7356. But unmatched from master is 7415 which is 59 more. How to read it & it makes my observation more than the actual no. of cases surveyed. Please guide. After merging the dataex file attached here with
-------------------- copy starting from the next line -----------------------
Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input double id long u_id float umpce_class byte(sector district) float(gender age_group est_pop blk_id age weight) byte(blk6_q4 blk6_q5 blk6_q6) long(blk7_q11 blk7_q14) float(eblk7_q11 eblk7_q14) byte blk7_q16 float ail_cat byte(x _merge)
57100110101 571001101 1 2 3 1 4 15.225 .  .      .  . . .    .    .        .       . .  . . 1
57100110102 571001101 1 2 3 2 3 15.225 1 27 15.225 87 1 1 1070 1500 16290.75 22837.5 1 12 1 3
57100110103 571001101 1 2 3 1 1 15.225 .  .      .  . . .    .    .        .       . .  . . 1
57100110104 571001101 1 2 3 2 1 15.225 .  .      .  . . .    .    .        .       . .  . . 1
57100110201 571001102 1 2 3 1 3 15.225 .  .      .  . . .    .    .        .       . .  . . 1
end
label values _merge _merge
label def _merge 1 "master only (1)", modify
label def _merge 3 "matched (3)", modify
------------------ copy up to and including the previous line ------------------