Code:
* Example generated by -dataex-. To install: ssc install dataex clear input str10 VDS_ID str5 SUR_MON_YR str26 LOAN_INSTITUTIONAL long(LOAN_REPAID LOAN_REC) str24 LOAN_PURPOSE double LOAN_INT "IAP10A0008" "07/10" "Finance companies" 2400 . "" . "IAP10A0008" "08/10" "Finance companies" 2900 10000 "LOAN REPAYMENT" . "IAP10A0008" "09/10" "Finance companies" 3300 . "" . "IAP10A0008" "10/10" "Finance companies" 1600 . "" . "IAP10A0010" "09/10" "Self help group(SHG)" . 6000 "LOAN REPAYMENT" 12 "IAP10A0034" "02/11" "Self help group(SHG)" . 10000 "LOAN REPAYMENTS" 3 "IAP10A0034" "09/10" "Finance companies" . 10000 "LOAN REPAYMENT" 18 "IAP10A0034" "10/10" "Finance companies" 900 . "" . "IAP10A0034" "11/10" "Finance companies" 225 . "" . "IAP10A0043" "07/10" "Self help group(SHG)" . 10000 "AGRICULTURE" 12 "IAP10A0043" "08/10" "Self help group(SHG)" . 6000 "AGRICULTURE" 12 "IAP10A0043" "09/10" "Self help group(SHG)" . 6000 "DOMESTIC" 12 "IAP10A0044" "01/11" "Finance companies" 3760 . "" . "IAP10A0044" "02/11" "Finance companies" 3760 . "" . "IAP10A0044" "03/11" "Finance companies" 4700 . "" . "IAP10A0044" "04/11" "Finance companies" 4700 . "" . "IAP10A0044" "05/11" "Finance companies" 4700 . "" . "IAP10A0044" "06/11" "Finance companies" 4700 . "DOMESTIC" . "IAP10A0044" "07/10" "Finance companies" . 40000 "LOAN REPAYMENT" 18 "IAP10A0044" "07/10" "Self help group(SHG)" . 10000 "LIVESTOCK" 12 "IAP10A0044" "08/10" "Finance companies" 3740 . "" . "IAP10A0044" "09/10" "Finance companies" 3740 . "" . "IAP10A0044" "09/10" "Self help group(SHG)" . 12000 "AGRICULTURE" 12 "IAP10A0044" "10/10" "Finance companies" 1870 . "" . "IAP10A0044" "11/10" "Finance companies" 3760 . "" . "IAP10A0044" "12/10" "Finance companies" 3760 . "" . "IAP10A0046" "03/11" "Self help group(SHG)" . 5000 "AGRICULTURE" 24 "IAP10A0053" "05/11" "Grameena Banks" 33000 25000 "AGRICULTURE" 12 "IAP10A0053" "06/11" "Grameena Banks" 62000 60000 "AGRICULTURE" 12 "IAP10A0055" "07/10" "Grameena Banks" 35500 50000 "AGRICULTURE" 12 "IAP10A0081" "06/11" "Self help group(SHG)" . 12000 "AGRICULTURE" 12 "IAP10A0082" "06/11" "Self help group(SHG)" . 13000 "AGRICULTURE" 12 "IAP10A0202" "02/11" "Self help group(SHG)" . 10000 "MARRIAGE" 3 "IAP10A0202" "07/10" "Finance companies" 2160 . "" . "IAP10A0202" "08/10" "Finance companies" 2920 8000 "AGRICULTURE" 18 "IAP10A0202" "09/10" "Finance companies" 2920 . "" . "IAP10A0202" "10/10" "Finance companies" 1460 . "" . "IAP10A0203" "07/10" "Finance companies" 800 . "" . "IAP10A0203" "08/10" "Finance companies" 1500 10000 "LOAN REPAYMENT" 18 "IAP10A0203" "09/10" "Finance companies" 2240 . "" . "IAP10A0203" "10/10" "Finance companies" 1250 . "" . "IAP10A0208" "08/10" "Self help group(SHG)" . 15000 "AGRICULTURE" 12 "IAP10A0209" "06/11" "Cooperatives" 1900 . "DOMESTIC" . "IAP10A0209" "07/10" "Cooperatives" 31200 30000 "AGRICULTURE" 12 "IAP10A0210" "04/11" "Self help group(SHG)" . 7000 "CONSUMPTION" 3 "IAP10A0210" "07/10" "Grameena Banks" 20500 20000 "AGRICULTURE" 12 "IAP10A0216" "05/11" "Cooperatives" 6000 60000 "LIVESTOCK" 12 "IAP10A0217" "05/11" "Finance companies" . 210000 "TRACTOR PURCHASED" 24 "IAP10A0217" "09/10" "Commercial Banks" . 22000 "AGRICULTURE" 12 "IAP10A0220" "07/10" "Finance companies" 1800 . "" . "IAP10A0220" "08/10" "Self help group(SHG)" . 3000 "DOMESTIC" 12 "IAP10A0220" "08/10" "Finance companies" 1800 . "" . "IAP10A0220" "09/10" "Finance companies" 1800 . "" . "IAP10A0220" "10/10" "Finance companies" 900 . "" . "IAP10A0224" "07/10" "Self help group(SHG)" . 10000 "AGRICULTURE" 12 "IAP10A0224" "07/10" "Grameena Banks" 48500 51000 "AGRICULTURE" 12 "IAP10A0224" "08/10" "Self help group(SHG)" . 10000 "AGRICULTURE" 12 "IAP10A0226" "04/11" "LIC" . 40000 "LOAN REPAYMENT" 10 "IAP10A0226" "09/10" "Grameena Banks" 54400 50000 "AGRICULTURE" 12 "IAP10A0226" "11/10" "Grameena Banks" 36000 . "" . "IAP10A0227" "01/11" "Grameena Banks" 28000 25000 "AGRICULTURE LOAN" 12 "IAP10A0227" "06/11" "Self help group(SHG)" 10000 12000 "AGRICULTURE" 12 "IAP10A0228" "01/11" "Finance companies" 6300 . "" . "IAP10A0228" "02/11" "Finance companies" 6300 . "" . "IAP10A0228" "03/11" "Finance companies" 6300 . "" . "IAP10A0228" "03/11" "Self help group(SHG)" . 6600 "CONSUMPTION" 12 "IAP10A0228" "04/11" "Finance companies" 6600 . "" . "IAP10A0228" "05/11" "Finance companies" 7800 . "" . "IAP10A0228" "06/11" "Finance companies" 7800 . "" . "IAP10A0228" "07/10" "Finance companies" 7660 . "" . "IAP10A0228" "08/10" "Finance companies" 8860 10000 "DOMESTIC" 18 "IAP10A0228" "09/10" "Finance companies" 8860 . "" . "IAP10A0228" "10/10" "Finance companies" 4240 . "" . "IAP10A0228" "11/10" "Finance companies" 6330 . "" . "IAP10A0228" "12/10" "Finance companies" 6300 . "" . "IAP10A0229" "07/10" "Self help group(SHG)" . 13000 "LIVESTOCK" 12 "IAP10A0231" "08/10" "Self help group(SHG)" . 7700 "PETROL PUMP PURCHASED" 12 "IAP10A0234" "07/10" "Finance companies" 900 . "" . "IAP10A0234" "08/10" "Finance companies" 1500 10000 "" 18 "IAP10A0234" "09/10" "Finance companies" 1840 . "" . "IAP10A0234" "10/10" "Finance companies" 920 . "" . "IAP10A0234" "12/10" "Finance companies" 500 . "" . "IAP10A0236" "06/11" "Self help group(SHG)" . 4000 "DOMESTIC" 24 "IAP10A0236" "07/10" "Self help group(SHG)" . 10000 "LOAN REPAYMENT" 12 "IAP10A0236" "10/10" "Self help group(SHG)" . 6000 "FESTIVALS" 24 "IAP10A0239" "08/10" "Finance companies" . 10000 "AGRICULTURE" 18 "IAP10A0239" "09/10" "Finance companies" 900 . "" . "IAP10A0239" "10/10" "Finance companies" 450 . "" . "IAP10A0240" "06/11" "Self help group(SHG)" . 6000 "AGRICULTURE" 12 "IAP10A0240" "09/10" "Self help group(SHG)" . 10000 "MEDICINES" 12 "IAP10A0241" "04/11" "Grameena Banks" 19000 18000 "AGRICULTURE" 12 "IAP10A0241" "04/11" "Commercial Banks" 55000 5000 "AGRICULTURE" 3 "IAP10A0242" "06/11" "Commercial Banks" . 32000 "AGRICULTURE" 12 "IAP10A0242" "07/10" "Commercial Banks" . 31000 "AGRICULTURE" 12 "IAP10A0297" "03/11" "Self help group(SHG)" . 6600 "AGRICULTURE" 12 "IAP10A0297" "07/10" "Finance companies" 2650 . "" . "IAP10A0297" "08/10" "Finance companies" 2650 . "" . "IAP10A0297" "09/10" "Finance companies" 2650 . "" . "IAP10A0297" "10/10" "Finance companies" 1650 . "" . "IAP10A0300" "07/10" "Self help group(SHG)" . 14000 "HOUSE CONSTRUCTION" 12 end
Code:
"IAP10A0044" "07/10" "Finance companies" . 40000 "LOAN REPAYMENT" 18 "IAP10A0044" "07/10" "Self help group(SHG)" . 10000 "LIVESTOCK" 12 end
hence a result like below:
Code:
"IAP10A0044" "07/10" "Finance companies+Self help group(SHG)" . 40000+10000 "LOAN REPAYMENT+LIVESTOCK" 18+12 end
0 Response to replacing data of two row in only one row.
Post a Comment