here is data below
Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input str10 VDS_ID str5 SUR_MON_YR str1 GIFT_REMITTANCES_SOURCE float(GIFT_AMT_GIV GIFT_AMT_REC) str26(LOAN_INSTITUTIONAL LOAN_NON_INSTITUETIONAL) double(LOAN_REPAID LOAN_REC) str24 LOAN_PURPOSE double LOAN_INT
"IAP10A0008" "05/11" "." . . ""                     "Friends/Relatives"     .     . ""                 .
"IAP10A0008" "07/10" "." . . "Finance companies"    "Shopkeeper"         2400     . ""                 .
"IAP10A0008" "08/10" "." . . "Finance companies"    "Friends/Relatives"  2900 10000 "LOAN REPAYMENT"   .
"IAP10A0008" "08/10" "." . . ""                     "Friends/Relatives"     .     . ""                 .
"IAP10A0008" "09/10" "." . . "Finance companies"    "Input dealer"       3300     . ""                 .
"IAP10A0008" "10/10" "." . . "Finance companies"    "Friends/Relatives"  1600     . ""                 .
"IAP10A0008" "12/10" "." . . ""                     "Friends/Relatives"     .     . ""                 .
"IAP10A0010" "07/10" "." . . ""                     "Friends/Relatives"     .     . ""                 .
"IAP10A0010" "09/10" "." . . "Self help group(SHG)" "Input dealer"          .  6000 "LOAN REPAYMENT"  12
"IAP10A0010" "09/10" "." . . ""                     "Money lender"          .     . ""                 .
"IAP10A0030" "08/10" "." . . ""                     "Friends/Relatives"     .     . ""                 .
"IAP10A0034" "01/11" "." . . ""                     "Friends/Relatives"     .     . ""                 .
"IAP10A0034" "02/11" "." . . "Self help group(SHG)" "Money lender"          . 10000 "LOAN REPAYMENTS"  3
"IAP10A0034" "02/11" "." . . ""                     "Friends/Relatives"     .     . ""                 .
"IAP10A0034" "05/11" "." . . ""                     "Friends/Relatives"     .     . ""                 .
"IAP10A0034" "06/11" "." . . ""                     "Friends/Relatives"     .     . ""                 .
"IAP10A0034" "09/10" "." . . ""                     "Money lender"          .     . ""                 .
"IAP10A0034" "09/10" "." . . "Finance companies"    "Outsiders"             . 10000 "LOAN REPAYMENT"  18
"IAP10A0034" "10/10" "." . . "Finance companies"    "Shopkeeper"          900     . ""                 .
"IAP10A0034" "10/10" "." . . ""                     "Money lender"          .     . ""                 .
"IAP10A0034" "11/10" "." . . ""                     "Friends/Relatives"     .     . ""                 .
"IAP10A0034" "11/10" "." . . "Finance companies"    "Outsiders"           225     . ""                 .
"IAP10A0038" "11/10" "." . . ""                     "Friends/Relatives"     .     . ""                 .
"IAP10A0043" "07/10" "." . . "Self help group(SHG)" "Friends/Relatives"     . 10000 "AGRICULTURE"     12
"IAP10A0043" "08/10" "." . . "Self help group(SHG)" "Input dealer"          .  6000 "AGRICULTURE"     12
"IAP10A0043" "09/10" "." . . "Self help group(SHG)" "Money lender"          .  6000 "DOMESTIC"        12
"IAP10A0043" "11/10" "." . . ""                     "Input dealer"          .     . ""                 .
"IAP10A0044" "01/11" "." . . "Finance companies"    "Friends/Relatives"  3760     . ""                 .
"IAP10A0044" "02/11" "." . . "Finance companies"    "Dairy"              3760     . ""                 .
"IAP10A0044" "03/11" "." . . "Finance companies"    "Friends/Relatives"  4700     . ""                 .
"IAP10A0044" "04/11" "." . . "Finance companies"    "Friends/Relatives"  4700     . ""                 .
"IAP10A0044" "05/11" "." . . "Finance companies"    "Shopkeeper"         4700     . ""                 .
"IAP10A0044" "05/11" "." . . ""                     "Friends/Relatives"     .     . ""                 .
"IAP10A0044" "06/11" "." . . "Finance companies"    "Shopkeeper"         4700     . "DOMESTIC"         .
"IAP10A0044" "07/10" "." . . "Self help group(SHG)" "Friends/Relatives"     . 10000 "LIVESTOCK"       12
"IAP10A0044" "07/10" "." . . "Finance companies"    "Outsiders"             . 40000 "LOAN REPAYMENT"  18
"IAP10A0044" "08/10" "." . . "Finance companies"    "Input dealer"       3740     . ""                 .
"IAP10A0044" "09/10" "." . . "Self help group(SHG)" "Friends/Relatives"     . 12000 "AGRICULTURE"     12
"IAP10A0044" "09/10" "." . . "Finance companies"    "Shopkeeper"         3740     . ""                 .
"IAP10A0044" "09/10" "." . . ""                     "Friends/Relatives"     .     . ""                 .
"IAP10A0044" "10/10" "." . . "Finance companies"    "Friends/Relatives"  1870     . ""                 .
"IAP10A0044" "11/10" "." . . "Finance companies"    "Friends/Relatives"  3760     . ""                 .
"IAP10A0044" "12/10" "." . . "Finance companies"    "Outsiders"          3760     . ""                 .
"IAP10A0046" "01/11" "." . . ""                     "Money lender"          .     . ""                 .
"IAP10A0046" "03/11" "." . . "Self help group(SHG)" "Outsiders"             .  5000 "AGRICULTURE"     24
"IAP10A0046" "06/11" "." . . ""                     "Friends/Relatives"     .     . ""                 .
"IAP10A0046" "07/10" "." . . ""                     "Friends/Relatives"     .     . ""                 .
"IAP10A0046" "09/10" "." . . ""                     "Friends/Relatives"     .     . ""                 .
"IAP10A0046" "10/10" "." . . ""                     "Friends/Relatives"     .     . ""                 .
"IAP10A0048" "01/11" "." . . ""                     "Money lender"          .     . ""                 .
"IAP10A0048" "02/11" "." . . ""                     "Friends/Relatives"     .     . ""                 .
"IAP10A0048" "07/10" "." . . ""                     "Friends/Relatives"     .     . ""                 .
"IAP10A0053" "03/11" "." . . ""                     "Money lender"          .     . ""                 .
"IAP10A0053" "03/11" "." . . ""                     "Friends/Relatives"     .     . ""                 .
"IAP10A0053" "05/11" "." . . "Grameena Banks"       "Friends/Relatives" 33000 25000 "AGRICULTURE"     12
"IAP10A0053" "06/11" "." . . ""                     "Friends/Relatives"     .     . ""                 .
"IAP10A0053" "06/11" "." . . "Grameena Banks"       "Friends/Relatives" 62000 60000 "AGRICULTURE"     12
"IAP10A0053" "08/10" "." . . ""                     "Friends/Relatives"     .     . ""                 .
"IAP10A0053" "09/10" "." . . ""                     "Friends/Relatives"     .     . ""                 .
"IAP10A0055" "04/11" "." . . ""                     "Friends/Relatives"     .     . ""                 .
"IAP10A0055" "07/10" "." . . ""                     "Input dealer"          .     . ""                 .
"IAP10A0055" "07/10" "." . . "Grameena Banks"       "Shopkeeper"        35500 50000 "AGRICULTURE"     12
"IAP10A0055" "08/10" "." . . ""                     "Input dealer"          .     . ""                 .
"IAP10A0081" "06/11" "." . . "Self help group(SHG)" "Dairy"                 . 12000 "AGRICULTURE"     12
"IAP10A0081" "10/10" "." . . ""                     "Input dealer"          .     . ""                 .
"IAP10A0082" "01/11" "." . . ""                     "Friends/Relatives"     .     . ""                 .
"IAP10A0082" "04/11" "." . . ""                     "Money lender"          .     . ""                 .
"IAP10A0082" "06/11" "." . . "Self help group(SHG)" "Friends/Relatives"     . 13000 "AGRICULTURE"     12
"IAP10A0082" "10/10" "." . . ""                     "Friends/Relatives"     .     . ""                 .
"IAP10A0082" "12/10" "." . . ""                     "Money lender"          .     . ""                 .
"IAP10A0202" "02/11" "." . . ""                     "Money lender"          .     . ""                 .
"IAP10A0202" "02/11" "." . . "Self help group(SHG)" "Friends/Relatives"     . 10000 "MARRIAGE"         3
"IAP10A0202" "02/11" "." . . ""                     "Friends/Relatives"     .     . ""                 .
"IAP10A0202" "05/11" "." . . ""                     "Friends/Relatives"     .     . ""                 .
"IAP10A0202" "07/10" "." . . "Finance companies"    "Friends/Relatives"  2160     . ""                 .
"IAP10A0202" "08/10" "." . . "Finance companies"    "Friends/Relatives"  2920  8000 "AGRICULTURE"     18
"IAP10A0202" "08/10" "." . . ""                     "Friends/Relatives"     .     . ""                 .
"IAP10A0202" "09/10" "." . . "Finance companies"    "Friends/Relatives"  2920     . ""                 .
"IAP10A0202" "09/10" "." . . ""                     "Friends/Relatives"     .     . ""                 .
"IAP10A0202" "10/10" "." . . "Finance companies"    "Friends/Relatives"  1460     . ""                 .
"IAP10A0202" "10/10" "." . . ""                     "Friends/Relatives"     .     . ""                 .
"IAP10A0202" "12/10" "." . . ""                     "Money lender"          .     . ""                 .
"IAP10A0203" "01/11" "." . . ""                     "Money lender"          .     . ""                 .
"IAP10A0203" "04/11" "." . . ""                     "Money lender"          .     . ""                 .
"IAP10A0203" "05/11" "." . . ""                     "Friends/Relatives"     .     . ""                 .
"IAP10A0203" "07/10" "." . . "Finance companies"    "Friends/Relatives"   800     . ""                 .
"IAP10A0203" "08/10" "." . . ""                     "Money lender"          .     . ""                 .
"IAP10A0203" "08/10" "." . . "Finance companies"    "Friends/Relatives"  1500 10000 "LOAN REPAYMENT"  18
"IAP10A0203" "09/10" "." . . ""                     "Input dealer"          .     . ""                 .
"IAP10A0203" "09/10" "." . . "Finance companies"    "Friends/Relatives"  2240     . ""                 .
"IAP10A0203" "10/10" "." . . ""                     "Friends/Relatives"     .     . ""                 .
"IAP10A0203" "10/10" "." . . "Finance companies"    "Friends/Relatives"  1250     . ""                 .
"IAP10A0208" "02/11" "." . . ""                     "Friends/Relatives"     .     . ""                 .
"IAP10A0208" "06/11" "." . . ""                     "Friends/Relatives"     .     . ""                 .
"IAP10A0208" "07/10" "." . . ""                     "Friends/Relatives"     .     . ""                 .
"IAP10A0208" "08/10" "." . . "Self help group(SHG)" "Friends/Relatives"     . 15000 "AGRICULTURE"     12
"IAP10A0209" "05/11" "." . . ""                     "Money lender"          .     . ""                 .
"IAP10A0209" "06/11" "." . . "Cooperatives"         "Shopkeeper"         1900     . "DOMESTIC"         .
"IAP10A0209" "07/10" "." . . "Cooperatives"         "Dairy"             31200 30000 "AGRICULTURE"     12
"IAP10A0209" "07/10" "." . . ""                     "Money lender"          .     . ""                 .
end
another file is...

Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input str10 VDS_ID str5 SUR_MON_YR str40 GIFT_REMITTANCES_SOURCE long(GIFT_AMT_GIV GIFT_AMT_REC)
"IAP10A0008" "02/11" "Friends/Relatives"                        50     .
"IAP10A0008" "04/11" "Friends/Relatives"                       200     .
"IAP10A0008" "05/11" "Friends/Relatives"                      2000     .
"IAP10A0008" "07/10" "Friends/Relatives"                       300     .
"IAP10A0008" "09/10" "Friends/Relatives"                       500     .
"IAP10A0008" "12/10" "Friends/Relatives"                     20000     .
"IAP10A0009" "01/11" "Institutions"                              .   600
"IAP10A0009" "02/11" "Friends/Relatives"                         .   400
"IAP10A0009" "03/11" "Friends/Relatives"                         .   600
"IAP10A0009" "04/11" "Friends/Relatives"                         .   700
"IAP10A0009" "05/11" "Friends/Relatives"                         .   800
"IAP10A0009" "06/11" "Friends/Relatives"                         .   400
"IAP10A0009" "12/10" "Friends/Relatives"                         .   800
"IAP10A0010" "01/11" "Friends/Relatives"                       400     .
"IAP10A0010" "02/11" "Friends/Relatives"                       320     .
"IAP10A0010" "03/11" "Friends/Relatives"                       320     .
"IAP10A0010" "04/11" "Friends/Relatives"                       330     .
"IAP10A0010" "05/11" "Friends/Relatives"                       500     .
"IAP10A0010" "06/11" "Friends/Relatives"                        50     .
"IAP10A0010" "07/10" "Friends/Relatives"                         .  2000
"IAP10A0010" "09/10" "Friends/Relatives"                       200     .
"IAP10A0010" "10/10" "Friends/Relatives"                       400     .
"IAP10A0010" "11/10" "Friends/Relatives"                       500     .
"IAP10A0030" "02/11" "Friends/Relatives"                       400     .
"IAP10A0030" "04/11" "Friends/Relatives"                       100     .
"IAP10A0030" "05/11" "Friends/Relatives"                       400     .
"IAP10A0030" "06/11" "Friends/Relatives"                     12500     .
"IAP10A0030" "10/10" "Friends/Relatives"                      1500     .
"IAP10A0030" "11/10" "Friends/Relatives"                       202     .
"IAP10A0034" "01/11" "Friends/Relatives"                      3000     .
"IAP10A0034" "02/11" "Friends/Relatives"                       350     .
"IAP10A0034" "05/11" "Friends/Relatives"                      4900     .
"IAP10A0034" "06/11" "Friends/Relatives-DAUGHTER OPERATION"  70000     .
"IAP10A0034" "09/10" "Friends/Relatives"                       150     .
"IAP10A0034" "11/10" "Friends/Relatives"                      1000     .
"IAP10A0035" "03/11" "Friends/Relatives"                      2000     .
"IAP10A0035" "04/11" "Friends/Relatives"                      3000     .
"IAP10A0035" "05/11" "Friends/Relatives"                      8000     .
"IAP10A0035" "07/10" "Friends/Relatives"                        50     .
"IAP10A0035" "08/10" "Friends/Relatives"                       300   800
"IAP10A0035" "11/10" "Friends/Relatives"                       800     .
"IAP10A0036" "09/10" "Friends/Relatives"                         .  2000
"IAP10A0038" "01/11" "Friends/Relatives"                         .   900
"IAP10A0038" "02/11" "Friends/Relatives"                       200  1000
"IAP10A0038" "03/11" "Friends/Relatives"                       100     .
"IAP10A0038" "04/11" "Friends/Relatives"                       100   500
"IAP10A0038" "05/11" "Friends/Relatives"                       415     .
"IAP10A0038" "06/11" "Friends/Relatives"                       100     .
"IAP10A0038" "07/10" "Friends/Relatives"                       200     .
"IAP10A0038" "08/10" "Friends/Relatives"                       100     .
"IAP10A0038" "11/10" "Friends/Relatives"                      1600     .
"IAP10A0039" "01/11" "Friends/Relatives"                       200     .
"IAP10A0039" "02/11" "Friends/Relatives"                       200     .
"IAP10A0039" "05/11" "Friends/Relatives"                      5000     .
"IAP10A0039" "07/10" "Friends/Relatives"                       200     .
"IAP10A0043" "02/11" "Dowry(Cash & kind)"                   411000     .
"IAP10A0043" "02/11" "Friends/Relatives"                         . 70000
"IAP10A0043" "03/11" "Friends/Relatives"                       100     .
"IAP10A0043" "04/11" "Friends/Relatives"                       300     .
"IAP10A0043" "05/11" "Friends/Relatives"                     15000     .
"IAP10A0043" "06/11" "Friends/Relatives"                       200     .
"IAP10A0043" "08/10" "Friends/Relatives"                      2100     .
"IAP10A0044" "02/11" "Friends/Relatives"                     14500     .
"IAP10A0044" "04/11" "Friends/Relatives"                       400     .
"IAP10A0044" "05/11" "Friends/Relatives"                      2600     .
"IAP10A0044" "07/10" "Friends/Relatives"                       500     .
"IAP10A0044" "08/10" "Friends/Relatives"                       100     .
"IAP10A0044" "09/10" "Institutions"                              .  1500
"IAP10A0046" "02/11" "Friends/Relatives"                       200     .
"IAP10A0046" "05/11" "Friends/Relatives"                       500     .
"IAP10A0046" "07/10" "Friends/Relatives"                       300     .
"IAP10A0048" "02/11" "Friends/Relatives"                      3900     .
"IAP10A0048" "04/11" "Friends/Relatives"                       116     .
"IAP10A0048" "05/11" "Friends/Relatives"                       102     .
"IAP10A0048" "06/11" "Friends/Relatives"                       500     .
"IAP10A0053" "01/11" "Friends/Relatives"                       300     .
"IAP10A0053" "02/11" "Friends/Relatives"                      1200     .
"IAP10A0053" "04/11" "Friends/Relatives"                      1000     .
"IAP10A0053" "05/11" "Friends/Relatives"                       500     .
"IAP10A0053" "06/11" "Friends/Relatives"                       200     .
"IAP10A0053" "08/10" "Friends/Relatives"                       500     .
"IAP10A0053" "09/10" "Friends/Relatives"                       200     .
"IAP10A0055" "02/11" "Friends/Relatives"                       200     .
"IAP10A0055" "03/11" "Friends/Relatives"                       300     .
"IAP10A0055" "04/11" "Friends/Relatives"                      2500     .
"IAP10A0055" "05/11" "Friends/Relatives"                      1500     .
"IAP10A0055" "06/11" "Friends/Relatives"                       400     .
"IAP10A0055" "07/10" "Friends/Relatives"                       300     .
"IAP10A0055" "08/10" "Friends/Relatives"                       200     .
"IAP10A0055" "10/10" "Friends/Relatives"                       200     .
"IAP10A0055" "11/10" "Friends/Relatives"                      2500     .
"IAP10A0058" "04/11" "Friends/Relatives"                       250     .
"IAP10A0058" "05/11" "Friends/Relatives"                       150     .
"IAP10A0058" "06/11" "Friends/Relatives"                       100     .
"IAP10A0058" "07/10" "Friends/Relatives"                      4000     .
"IAP10A0058" "08/10" "Friends/Relatives"                       400     .
"IAP10A0058" "12/10" "Friends/Relatives"                       300     .
"IAP10A0081" "01/11" "Friends/Relatives"                       100     .
"IAP10A0081" "04/11" "Friends/Relatives"                       500     .
"IAP10A0081" "05/11" "Friends/Relatives"                      1500     .
end

merge by VDS_ID and SUR_MON_YR