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
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
0 Response to merging data files to create a large panel data by VDS_Id and SUR_MON_YR
Post a Comment