i have two dataset
----------------------- copy starting from the next line -----------------------
Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input str10 VDS_ID str3 PRE_MEM_ID str4 OLD_MEM_ID str5 SUR_MON_YR str1 WORK_TYPE str2 CO_NF_WORK str25 CO_NF_WORK_OT str1 WORK_PLACE
"IAP11A0035" "3"   "3"    "12/11" "0" "  " "                        "  " "
"IAP11A0035" "5"   "5"    "08/11" "1" "  " "                        "  "1"
"IAP11A0035" "3"   "3"    "04/12" "2" "12" "                        "  "1"
"IAP11A0035" "3"   "3"    "02/12" "2" "12" "                        "  "1"
"IAP11A0035" "5"   "5"    "01/12" "1" "  " "                        "  "1"
"IAP11A0035" "3"   "3"    "01/12" "2" "12" "                        "  "1"
"IAP11A0035" "3"   "3"    "05/12" "2" "12" "                        "  "1"
"IAP11A0035" "3"   "3"    "10/11" "0" "  " "                        "  " "
"IAP11A0035" "5"   "5"    "06/12" "2" "12" "                        "  "1"
"IAP11A0035" "5"   "5"    "07/11" "2" "12" "                        "  "1"
"IAP11A0035" "5"   "5"    "07/11" "1" "  " "                        "  "1"
"IAP11A0035" "3"   "3"    "07/11" "2" "12" "                        "  "1"
"IAP11A0035" "3"   "3"    "09/11" "2" "12" "                        "  "1"
"IAP11A0035" "5"   "5"    "01/12" "2" "12" "                        "  "1"
"IAP11A0035" "3"   "3"    "11/11" "0" "  " "                        "  " "
"IAP11A0035" "5"   "5"    "09/11" "1" "  " "                        "  "1"
"IAP11A0035" "3"   "3"    "03/12" "2" "12" "                        "  "1"
"IAP11A0035" "5"   "5"    "04/12" "2" "12" "                        "  "1"
"IAP11A0035" "5"   "5"    "11/11" "1" "  " "                        "  "1"
"IAP11A0035" "3"   "3"    "06/12" "2" "12" "                        "  "1"
"IAP11A0035" "5"   "5"    "03/12" "2" "12" "                        "  "1"
"IAP11A0035" "3"   "3"    "08/11" "2" "12" "                        "  "1"
"IAP11A0035" "5"   "5"    "10/11" "1" "  " "                        "  "1"
"IAP11A0035" "5"   "5"    "02/12" "2" "12" "                        "  "1"
"IAP11A0035" "5"   "5"    "12/11" "1" "  " "                        "  "1"
"IAP11A0035" "5"   "5"    "05/12" "2" "12" "                        "  "1"
"IAP11A0036" "4"   "4"    "01/12" "1" "  " "                        "  "1"
"IAP11A0036" "4"   "4"    "06/12" "0" "  " "                        "  " "
"IAP11A0036" "4"   "4"    "03/12" "0" "  " "                        "  " "
"IAP11A0036" "4"   "4"    "09/11" "0" "  " "                        "  " "
"IAP11A0036" "4"   "4"    "02/12" "0" "  " "                        "  " "
"IAP11A0036" "4"   "4"    "08/11" "1" "  " "                        "  "1"
"IAP11A0036" "4"   "4"    "07/11" "1" "  " "                        "  "1"
"IAP11A0036" "4"   "4"    "12/11" "1" "  " "                        "  "1"
"IAP11A0036" "4"   "4"    "11/11" "1" "  " "                        "  "1"
"IAP11A0036" "4"   "4"    "05/12" "0" "  " "                        "  " "
"IAP11A0036" "4"   "4"    "10/11" "0" "  " "                        "  " "
"IAP11A0036" "4"   "4"    "04/12" "0" "  " "                        "  " "
"IAP11A0038" "1"   "1"    "09/11" "2" "3"  "                        "  "1"
"IAP11A0038" "2"   "2"    "04/12" "0" "  " "                        "  " "
"IAP11A0038" "5"   "5"    "03/12" "2" "1"  "                        "  "5"
"IAP11A0038" "1"   "1"    "05/12" "2" "3"  "                        "  "1"
"IAP11A0038" "5"   "5"    "09/11" "2" "1"  "                        "  "5"
"IAP11A0038" "201" "    " "10/11" "2" "1"  "                        "  "5"
"IAP11A0038" "1"   "1"    "12/11" "2" "3"  "                        "  "1"
"IAP11A0038" "1"   "1"    "06/12" "2" "3"  "                        "  "1"
"IAP11A0038" "2"   "2"    "11/11" "1" "  " "                        "  "1"
"IAP11A0038" "2"   "2"    "02/12" "0" "  " "                        "  " "
"IAP11A0038" "201" "    " "08/11" "2" "1"  "                        "  "5"
"IAP11A0038" "2"   "2"    "08/11" "1" "  " "                        "  "1"
"IAP11A0038" "2"   "2"    "01/12" "0" "  " "                        "  " "
"IAP11A0038" "201" "    " "06/12" "2" "1"  "                        "  "5"
"IAP11A0038" "201" "    " "03/12" "2" "1"  "                        "  "5"
"IAP11A0038" "1"   "1"    "03/12" "2" "3"  "                        "  "1"
"IAP11A0038" "2"   "2"    "09/11" "0" "  " "                        "  " "
"IAP11A0038" "5"   "5"    "06/12" "2" "1"  "                        "  "5"
"IAP11A0038" "5"   "5"    "11/11" "2" "1"  "                        "  "5"
"IAP11A0038" "5"   "5"    "05/12" "2" "1"  "                        "  "5"
"IAP11A0038" "201" "    " "01/12" "2" "1"  "                        "  "5"
"IAP11A0038" "1"   "1"    "11/11" "2" "3"  "                        "  "1"
"IAP11A0038" "201" "    " "04/12" "2" "1"  "                        "  "5"
"IAP11A0038" "2"   "2"    "06/12" "0" "  " "                        "  " "
"IAP11A0038" "201" "    " "07/11" "2" "1"  "                        "  "5"
"IAP11A0038" "5"   "5"    "10/11" "2" "1"  "                        "  "5"
"IAP11A0038" "201" "    " "11/11" "2" "1"  "                        "  "5"
"IAP11A0038" "201" "    " "12/11" "2" "1"  "                        "  "5"
"IAP11A0038" "2"   "2"    "05/12" "0" "  " "                        "  " "
"IAP11A0038" "1"   "1"    "08/11" "2" "3"  "                        "  "1"
"IAP11A0038" "1"   "1"    "10/11" "2" "3"  "                        "  "1"
"IAP11A0038" "5"   "5"    "08/11" "2" "1"  "                        "  "5"
"IAP11A0038" "1"   "1"    "01/12" "2" "3"  "                        "  "1"
"IAP11A0038" "2"   "2"    "03/12" "0" "  " "                        "  " "
"IAP11A0038" "2"   "2"    "10/11" "0" "  " "                        "  " "
"IAP11A0038" "5"   "5"    "07/11" "2" "1"  "                        "  "5"
"IAP11A0038" "5"   "5"    "04/12" "2" "1"  "                        "  "5"
"IAP11A0038" "201" "    " "09/11" "2" "1"  "                        "  "5"
"IAP11A0038" "5"   "5"    "12/11" "2" "1"  "                        "  "5"
"IAP11A0038" "1"   "1"    "04/12" "2" "3"  "                        "  "1"
"IAP11A0038" "2"   "2"    "12/11" "0" "  " "                        "  " "
"IAP11A0038" "1"   "1"    "02/12" "2" "3"  "                        "  "1"
"IAP11A0038" "5"   "5"    "02/12" "2" "1"  "                        "  "5"
"IAP11A0038" "5"   "5"    "01/12" "2" "1"  "                        "  "5"
"IAP11A0038" "2"   "2"    "07/11" "0" "  " "                        "  " "
"IAP11A0038" "201" "    " "02/12" "2" "1"  "                        "  "5"
"IAP11A0038" "1"   "1"    "07/11" "2" "3"  "                        "  "1"
"IAP11A0038" "201" "    " "05/12" "2" "1"  "                        "  "5"
"IAP11A0039" "201" "    " "07/11" "1" "  " "                        "  "1"
"IAP11A0039" "1"   "1"    "08/11" "0" "  " "                        "  " "
"IAP11A0039" "201" "    " "01/12" "2" "25" "MGNREGS                  " "1"
"IAP11A0039" "1"   "1"    "01/12" "0" "  " "                        "  " "
"IAP11A0039" "1"   "1"    "03/12" "0" "  " "                        "  " "
"IAP11A0039" "201" "    " "04/12" "2" "25" "MGNREGS                  " "1"
"IAP11A0039" "1"   "1"    "06/12" "0" "  " "                        "  " "
"IAP11A0039" "1"   "1"    "05/12" "0" "  " "                        "  " "
"IAP11A0039" "1"   "1"    "09/11" "0" "  " "                        "  " "
"IAP11A0039" "1"   "1"    "10/11" "0" "  " "                        "  " "
"IAP11A0039" "201" "    " "03/12" "1" "  " "                        "  "1"
"IAP11A0039" "201" "    " "10/11" "1" "  " "                        "  "1"
"IAP11A0039" "1"   "1"    "04/12" "0" "  " "                        "  " "
"IAP11A0039" "201" "    " "01/12" "1" "  " "                        "  "1"
end
------------------ copy up to and including the previous line ------------------

Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input str10 VDS_ID str2 LIVESTOCK_BIG str3 LIVESTOCK_SMALL str2 LIVESTOCK_VERY_SMALL str1 LIVESTOCK_YOUNG_STOCK
"IAP10A0035" ""  "1"   ""   "" 
"IAP10A0043" "2" ""    ""   "1"
"IAP10A0044" "2" "2"   ""   "1"
"IAP10A0046" "3" "20"  ""   "1"
"IAP10A0053" "5" "3"   ""   "1"
"IAP10A0055" "3" "2"   ""   "1"
"IAP10A0082" "4" "2"   "18" "1"
"IAP10A0202" "2" "1"   "12" "" 
"IAP10A0203" "2" ""    "2"  "1"
"IAP10A0208" "2" ""    ""   "" 
"IAP10A0209" "2" ""    ""   "" 
"IAP10A0210" ""  "2"   "14" "" 
"IAP10A0216" "2" "7"   ""   "2"
"IAP10A0217" "5" "1"   ""   "2"
"IAP10A0220" ""  "8"   ""   "" 
"IAP10A0224" "2" ""    "5"  "" 
"IAP10A0225" "1" ""    ""   "" 
"IAP10A0227" "2" ""    ""   "" 
"IAP10A0228" ""  ""    "8"  "" 
"IAP10A0229" ""  "4"   ""   "" 
"IAP10A0231" "3" ""    "15" "" 
"IAP10A0232" "3" "2"   "12" "2"
"IAP10A0233" ""  ""    "11" "" 
"IAP10A0236" ""  "42"  ""   "" 
"IAP10A0237" "2" ""    "4"  "" 
"IAP10A0238" "3" "8"   ""   "" 
"IAP10A0239" "3" "4"   "9"  "1"
"IAP10A0240" ""  ""    "2"  "" 
"IAP10A0241" "6" "1"   "11" "1"
"IAP10A0242" ""  ""    "8"  "" 
"IAP10A0297" "2" ""    "1"  "" 
"IAP10A0299" ""  "2"   ""   "" 
"IAP10A0301" ""  "5"   ""   "" 
"IAP10A0303" ""  ""    "2"  "" 
"IAP10A0304" "4" ""    ""   "1"
"IAP10A0305" "3" "3"   "4"  "3"
"IAP10A0306" "6" "6"   ""   "2"
"IAP10A0308" "4" ""    ""   "4"
"IAP10A0309" "2" "89"  "8"  "" 
"IAP10A0315" "1" "89"  ""   "" 
"IAP10A0316" "1" ""    ""   "" 
"IAP10A0317" ""  ""    "1"  "" 
"IAP10A0325" ""  "2"   "8"  "" 
"IAP10A0330" "1" "2"   ""   "" 
"IAP10A1124" ""  "4"   ""   "" 
"IAP10B0032" "2" ""    ""   "" 
"IAP10B0041" "7" ""    ""   "3"
"IAP10B0043" "3" ""    ""   "4"
"IAP10B0044" "2" ""    ""   "" 
"IAP10B0052" "3" ""    "7"  "2"
"IAP10B0053" "2" ""    "3"  "" 
"IAP10B0055" ""  ""    "6"  "" 
"IAP10B0057" "9" ""    ""   "7"
"IAP10B0058" "5" ""    "8"  "7"
"IAP10B0200" ""  "153" ""   "" 
"IAP10B0275" ""  "150" ""   "" 
"IAP10B0284" ""  "203" ""   "" 
"IAP10B0288" "6" ""    ""   "5"
"IAP10B0289" "3" ""    "5"  "1"
"IAP10B0290" "6" ""    "9"  "3"
"IAP10B0291" "5" ""    ""   "4"
"IAP10B0296" ""  "124" ""   "" 
"IAP10B0297" ""  "100" ""   "" 
"IAP10B0298" ""  "70"  ""   "" 
"IAP10B0299" "2" "80"  ""   "" 
"IAP10B1079" ""  ""    "13" "" 
"IAP10C0003" ""  "13"  ""   "" 
"IAP10C0005" "1" ""    ""   "" 
"IAP10C0007" "1" ""    ""   "" 
"IAP10C0034" "1" ""    ""   "" 
"IAP10C0035" "1" ""    ""   "1"
"IAP10C0039" "1" ""    ""   "" 
"IAP10C0042" ""  "60"  ""   "" 
"IAP10C0043" "1" ""    ""   "" 
"IAP10C0045" "1" ""    ""   "" 
"IAP10C0046" "1" ""    ""   "" 
"IAP10C0047" "1" ""    ""   "" 
"IAP10C0048" "2" ""    ""   "" 
"IAP10C0051" "1" ""    ""   "" 
"IAP10C0052" "1" ""    ""   "" 
"IAP10C0055" "1" ""    ""   "" 
"IAP10C0058" "3" ""    ""   "" 
"IAP10D0001" "4" ""    ""   "3"
"IAP10D0004" ""  "95"  "3"  "" 
"IAP10D0006" "1" ""    ""   "1"
"IAP10D0007" ""  "63"  ""   "" 
"IAP10D0030" "2" ""    "7"  "2"
"IAP10D0031" "1" ""    ""   "1"
"IAP10D0033" "1" ""    ""   "" 
"IAP10D0035" "2" ""    "3"  "3"
"IAP10D0036" ""  ""    "7"  "" 
"IAP10D0040" "1" ""    ""   "1"
"IAP10D0042" "3" ""    ""   "1"
"IAP10D0047" "4" ""    ""   "" 
"IAP10D0049" "1" ""    ""   "2"
"IAP10D0051" "2" ""    ""   "3"
"IAP10D0054" "3" ""    ""   "3"
"IAP10D0056" "1" ""    ""   "1"
"IAP10D0057" "2" ""    ""   "1"
"IAP10D0059" "1" ""    "3"  "1"
end
------------------ copy up to and including the previous line ------------------
i have used this code

merge m:1 VDS_ID using "C:\Users\Rahul\Desktop\phd\project\labor\2011\liv estock_2011.dta"

and getting result

[/CODE]

Result # of obs.
-----------------------------------------
not matched 43,239
from master 42,672 (_merge==1)
from using 567 (_merge==2)

matched 0 (_merge==3)
--------------------------
[/CODE]

which is incorrect. so can you please help me out what is the problem with it.