input str10 VDS_ID str5 SUR_MON_YR str42 PROG_NAME long AMT_BEN str10 WHO_BEN str1 WHO_SPENT
"IAP10A0008" "06/11" "Public dist. system(rice,wheat, etc.) " 170 " " "B"
"IAP10A0008" "06/11" "Mid day meal " 90 "14,205 " "B"
"IAP10A0008" "05/11" "Public dist. system(rice,wheat, etc.) " 170 " " "B"
"IAP10A0008" "04/11" "Public dist. system(rice,wheat, etc.) " 170 "4,12 " "B"
"IAP10A0008" "04/11" "Mid day meal " 100 "14,205 " "B"
"IAP10A0008" "03/11" "Public dist. system(rice,wheat, etc.) " 170 "4 " "B"
"IAP10A0008" "03/11" "Mid day meal " 150 "14,205 " "B"
"IAP10A0008" "02/11" "Public dist. system(rice,wheat, etc.) " 170 "4 " "B"
"IAP10A0008" "02/11" "Mid day meal " 160 "14,205 " "B"
"IAP10A0008" "01/11" "Public dist. system(rice,wheat, etc.) " 175 "4 " "B"
"IAP10A0008" "01/11" "Mid day meal " 140 "14,205 " "B"
"IAP10A0008" "12/10" "Public dist. system(rice,wheat, etc.) " 175 "4 " "B"
"IAP10A0008" "12/10" "Mid day meal " 170 "14,205 " "B"
"IAP10A0008" "11/10" "Public dist. system(rice,wheat, etc.) " 175 "4 " "B"
"IAP10A0008" "11/10" "Mid day meal " 160 "14,205 " "B"
"IAP10A0008" "10/10" "Public dist. system(rice,wheat, etc.) " 185 "4 " "B"
"IAP10A0008" "10/10" "Mid day meal " 120 "14,205 " "B"
"IAP10A0008" "09/10" "Public dist. system(rice,wheat, etc.) " 175 "4 " "B"
"IAP10A0008" "09/10" "Mid day meal " 140 "14,205 " "B"
"IAP10A0008" "08/10" "Public dist. system(rice,wheat, etc.) " 170 "4,12 " "B"
"IAP10A0008" "08/10" "Mid day meal " 150 "14,205 " "B"
"IAP10A0008" "07/10" "Public dist. system(rice,wheat, etc.) " 170 "4 " "B"
"IAP10A0008" "07/10" "Mid day meal " 140 "14,205 " "B"
"IAP10A0009" "06/11" "Public dist. system(rice,wheat, etc.) " 320 "2 " "F"
"IAP10A0009" "06/11" "Pensions (old age, widow, etc. " 200 "2 " "F"
"IAP10A0009" "05/11" "Public dist. system(rice,wheat, etc.) " 320 "2 " "F"
"IAP10A0009" "05/11" "Pensions (old age, widow, etc. " 200 "2 " "F"
"IAP10A0009" "04/11" "Public dist. system(rice,wheat, etc.) " 320 "2 " "F"
"IAP10A0009" "04/11" "Pensions (old age, widow, etc. " 200 "2 " "F"
"IAP10A0009" "03/11" "Public dist. system(rice,wheat, etc.) " 320 "2 " "F"
"IAP10A0009" "03/11" "Pensions (old age, widow, etc. " 200 "2 " "F"
"IAP10A0009" "02/11" "Public dist. system(rice,wheat, etc.) " 320 "2 " "F"
"IAP10A0009" "02/11" "Pensions (old age, widow, etc. " 200 "2 " "F"
"IAP10A0009" "01/11" "Public dist. system(rice,wheat, etc.) " 320 "2 " "F"
"IAP10A0009" "01/11" "Pensions (old age, widow, etc. " 200 "2 " "F"
"IAP10A0009" "12/10" "Public dist. system(rice,wheat, etc.) " 320 "2 " "F"
"IAP10A0009" "12/10" "Pensions (old age, widow, etc. " 200 "2 " "F"
"IAP10A0009" "11/10" "Public dist. system(rice,wheat, etc.) " 310 "2 " "F"
"IAP10A0009" "11/10" "Pensions (old age, widow, etc. " 200 "2 " "F"
"IAP10A0009" "10/10" "Public dist. system(rice,wheat, etc.) " 325 "2 " "F"
"IAP10A0009" "10/10" "Pensions (old age, widow, etc. " 200 "2 " "F"
"IAP10A0009" "09/10" "Public dist. system(rice,wheat, etc.) " 320 "2 " "F"
"IAP10A0009" "09/10" "Pensions (old age, widow, etc. " 200 "2 " "F"
"IAP10A0009" "08/10" "Public dist. system(rice,wheat, etc.) " 320 "2 " "F"
"IAP10A0009" "08/10" "Pensions (old age, widow, etc. " 200 "2 " "F"
"IAP10A0009" "07/10" "Public dist. system(rice,wheat, etc.) " 320 "2 " "B"
"IAP10A0009" "07/10" "Pensions (old age, widow, etc. " 200 "2 " "B"
"IAP10A0010" "06/11" "Public dist. system(rice,wheat, etc.) " 120 " " "B"
"IAP10A0010" "06/11" "Pensions (old age, widow, etc. " 200 "3 " "B"
"IAP10A0010" "05/11" "Public dist. system(rice,wheat, etc.) " 120 " " "B"
"IAP10A0010" "05/11" "Pensions (old age, widow, etc. " 200 "3 " "B"
"IAP10A0010" "04/11" "Public dist. system(rice,wheat, etc.) " 120 "3,4 " "B"
"IAP10A0010" "03/11" "Public dist. system(rice,wheat, etc.) " 120 "3 " "B"
"IAP10A0010" "02/11" "Public dist. system(rice,wheat, etc.) " 120 "3 " "B"
"IAP10A0010" "01/11" "Public dist. system(rice,wheat, etc.) " 110 "3,4 " "B"
"IAP10A0010" "12/10" "Public dist. system(rice,wheat, etc.) " 110 "3 " "B"
"IAP10A0010" "11/10" "Public dist. system(rice,wheat, etc.) " 110 "3,4 " "B"
"IAP10A0010" "10/10" "Public dist. system(rice,wheat, etc.) " 115 "3 " "B"
"IAP10A0010" "09/10" "Public dist. system(rice,wheat, etc.) " 104 "3 " "B"
"IAP10A0010" "09/10" "Crop insurance, drought or flood relief " 1800 "3 " "B"
"IAP10A0010" "08/10" "Public dist. system(rice,wheat, etc.) " 104 "3,4 " "B"
"IAP10A0010" "07/10" "Public dist. system(rice,wheat, etc.) " 104 "3 " "B"
"IAP10A0030" "06/11" "Public dist. system(rice,wheat, etc.) " 120 " " "B"
"IAP10A0030" "05/11" "Public dist. system(rice,wheat, etc.) " 120 " " "B"
"IAP10A0030" "04/11" "Public dist. system(rice,wheat, etc.) " 120 "1,2 " "B"
"IAP10A0030" "03/11" "Public dist. system(rice,wheat, etc.) " 120 "1 " "B"
"IAP10A0030" "02/11" "Public dist. system(rice,wheat, etc.) " 110 "1 " "B"
"IAP10A0030" "01/11" "Public dist. system(rice,wheat, etc.) " 110 "1,2 " "B"
"IAP10A0030" "12/10" "Public dist. system(rice,wheat, etc.) " 110 "1 " "B"
"IAP10A0030" "11/10" "Public dist. system(rice,wheat, etc.) " 105 "1,2 " "B"
"IAP10A0030" "10/10" "Public dist. system(rice,wheat, etc.) " 110 "1 " "B"
"IAP10A0030" "09/10" "Public dist. system(rice,wheat, etc.) " 100 "1 " "B"
"IAP10A0030" "08/10" "Public dist. system(rice,wheat, etc.) " 100 "1,2 " "B"
"IAP10A0030" "07/10" "Public dist. system(rice,wheat, etc.) " 104 "1 " "B"
"IAP10A0034" "06/11" "Public dist. system(rice,wheat, etc.) " 320 " " "B"
"IAP10A0034" "06/11" "Mid day meal " 30 "13 " "F"
"IAP10A0034" "06/11" "Others (ABAYAHASTHAM) " 500 "2 " "B"
"IAP10A0034" "05/11" "Public dist. system(rice,wheat, etc.) " 320 " " "B"
"IAP10A0034" "05/11" "Others (ABAYAHASTAM) " 500 "2 " "B"
"IAP10A0034" "04/11" "Public dist. system(rice,wheat, etc.) " 320 "3 " "B"
"IAP10A0034" "04/11" "Mid day meal " 50 "13 " "F"
"IAP10A0034" "04/11" "Others (ABAYAHASHAM) " 500 "2 " "B"
"IAP10A0034" "03/11" "Public dist. system(rice,wheat, etc.) " 320 "3 " "B"
"IAP10A0034" "03/11" "Mid day meal " 80 "13 " "F"
"IAP10A0034" "03/11" "Others (ABAYAHASHAM) " 500 "2 " "B"
"IAP10A0034" "02/11" "Public dist. system(rice,wheat, etc.) " 320 "3 " "B"
"IAP10A0034" "02/11" "Mid day meal " 85 "13 " "F"
"IAP10A0034" "02/11" "Others (ABAYAHASHAM PENTION) " 500 "2 " "B"
"IAP10A0034" "01/11" "Public dist. system(rice,wheat, etc.) " 340 "3 " "B"
"IAP10A0034" "01/11" "Mid day meal " 70 "13 " "F"
"IAP10A0034" "01/11" "Others-ABAYAHASTHAM " 500 "2 " "B"
"IAP10A0034" "12/10" "Public dist. system(rice,wheat, etc.) " 320 "3 " "B"
"IAP10A0034" "12/10" "Mid day meal " 95 "13 " "F"
"IAP10A0034" "12/10" "Others (ABAYAHASHAM PENSION) " 500 "2 " "B"
"IAP10A0034" "11/10" "Public dist. system(rice,wheat, etc.) " 320 "3 " "B"
"IAP10A0034" "11/10" "Mid day meal " 90 "13 " "F"
"IAP10A0034" "11/10" "ABAYAHASHAM PENSION " 500 "2 " "B"
"IAP10A0034" "10/10" "Public dist. system(rice,wheat, etc.) " 335 "3 " "B"
"IAP10A0034" "10/10" "Mid day meal " 60 "13 " "F"
"IAP10A0034" "10/10" "Others (ABAYAHASTHAM PENSION) " 500 "2 " "B"
end
[/CODE]
from the original data file, I have separated observations which are related to education in variable PROG_NAME in the separate file and which are related to mid-day meal in the separated file such as:
for education_related
* Example generated by -dataex-. To install: ssc install dataex
clear
input str10 VDS_ID str5 SUR_MON_YR str42 PROG_NAME long AMT_BEN str10 WHO_BEN str1 WHO_SPENT
"IAP10D0008" "03/11" "PROVIDING FREE EDUCATION&HOSTEL " 5000 "50,51,52 " "B"
"IAP10D0008" "02/11" "Others (PROVIDING FREE EDUCATION HOSTEL) " 5000 "50,51,52 " "B"
"IAP10D0008" "01/11" "Others (FREE EDUCATION FROM GOVERNMENT) " 5000 "50,51,52 " "F"
"IAP10D0008" "12/10" "Others (FREE EDUCATION FROM GOVT.) " 5000 "50,51,52 " "F"
"IAP10D0008" "11/10" "FREE EDU.FROM GOVT RES.HOSTELS & SCHOOLS " 5000 "50,51,52 " "B"
"IAP10D0008" "10/10" "Others-FREE EDU.FOR 3DAUGHTERS GOVT SCHOOL" 5000 "50,51,52 " "F"
"IAP10D0008" "09/10" "Others(GOVT PROVID. HOSTEL,FOOD&FREE EDU. " 2000 "50,51 " "B"
"IAP10D0008" "08/10" "Others (PROVIDING FREE EDUCATION AND FOOD)" 2000 "50,51 " "B"
"IAP10D0033" "01/11" "Others (SCHOLARSHIP)INTER " 3600 "4 " "M"
"IAP10D0036" "07/10" "Others (GOVT.BOOKS(FREE)) " 400 "3 " "M"
"IAP10D0046" "04/11" "Others(FEES REIMBURSEMENT 2010-11) " 32000 "50 " "B"
"IAP10D0046" "03/11" "FEES REIMBURSEMENT FOR 2010-2011 " 30000 "50 " "B"
"IAP10D0046" "11/10" "FEES REIMBERSEMENT-(2009-10)THIS MONTH REC" 32000 "50 " "M"
"IAP10D0048" "01/11" "Others (FEES REIMBURSEMENT) " 32000 "51 " "B"
"IAP10D0054" "01/11" "Others (FEES REIMBURSEMENT BY GOVT.) " 30000 "51 " "M"
"IAP10D0055" "06/11" "Others-FEES REIMBURSEMENT " 32000 "5 " "M"
"IAP10D0055" "04/11" "Others(PROVIDING FREE EDUCATION) " 2000 "5 " "M"
"IAP10D0055" "03/11" "Others (PROVIDING FREE EDUCATION FOR GOVT)" 2000 "5 " "B"
"IAP10D0055" "02/11" "PROVIDING FREE EDUCATION " 2000 "5 " "M"
"IAP10D0055" "01/11" "Others (PROVIDING FREE EDUCATION BY GOVT.)" 2000 "5 " "M"
"IAP10D0055" "11/10" "GOVT PROVIDING HOSTEL FACILITY " 2000 "5 " "M"
"IAP10D0055" "10/10" "Others-GOVT PROVIDING HOSTEL FACILITY " 2000 "5 " "M"
"IAP10D0055" "10/10" "FEES REIMBURSEMENT(2009-10) " 30000 "51 " "B"
"IAP10D0055" "09/10" "(GOVT PRO.HOSTEL&FOOD FACILITY FOR EDU.) " 2000 "5 " "M"
"IAP10D0055" "08/10" "Others(GOVT.PROVIDING HOSTEL&FOOF) " 2000 "5 " "M"
"IKN10A0006" "06/11" "BOOKS & DRESS IN SCHOOL " 540 "4 " "M"
"IKN10A0032" "06/11" "BOOKS & DRESS IN SCHOOL " 290 "5 " "M"
"IKN10A0033" "06/11" "BOOKS & 2 PAIR DRESS " 520 "5,6 " "F"
"IKN10A0036" "06/11" "BOOKS & 3 PAIR DRESS IN SCHOOL " 750 "4,5,6 " "F"
"IKN10A0041" "06/11" "BOOKS & DRESS " 300 "3 " "M"
"IKN10A0044" "02/11" "Others (SCHOLARSHIP) " 100 "4 " "M"
"IKN10A0046" "06/11" "BOOKS & 2 PAIR DRESS " 560 "4,3 " "F"
"IKN10A0047" "06/11" "BOOKS & DRESS " 180 "3 " "M"
"IKN10A0048" "06/11" "BOOKS & 4 PAIR DRESS " 980 "4,5,6,7 " "B"
"IKN10A0052" "06/11" "BOOKS & SCHOOL DRESS " 210 "4 " "F"
"IKN10A0054" "06/11" "BOOKS & 3 PAIR DRESS " 750 "3,4,5 " "B"
"IKN10A0057" "06/11" "BOOKS & 1 DRESS " 270 "5 " "F"
"IKN10A0060" "06/11" "BOOKS & PAIR DRESS " 420 "3,4 " "M"
"IKN10B0003" "08/10" "Others-ICRISAT(FREE EDDUCATION TRIP) " 2000 "4 " "M"
"IKN10B0004" "08/10" "Others-ICRISAT(FREE EDUCATION TRIP) " 2000 "5 " "M"
"IKN10B0005" "08/10" "Others-ICRISAT(FREE EDCATION TRIP) " 2000 "2 " "M"
"IKN10B0006" "08/10" "Others-ICRISAT(FREE EDUCATION TRIP) " 2000 "1 " "M"
"IKN10B0008" "08/10" "Others-ICRISAT(FREE EDUCATION TRIP) " 2000 "3 " "M"
"IKN10B0009" "08/10" "Others-ICRISAT(FREE EDUCATION TRIP) " 2000 "1 " "F"
"IKN10B0010" "08/10" "Others-ICRISAT(FREE EDUCATION TRIP) " 2000 "3 " "M"
"IKN10B0030" "08/10" "Others-ICRISAT(FREE EDUCATION TRIP) " 2000 "1 " "M"
"IKN10B0032" "03/11" "Others-SCHOOL SCHOLARSHIP " 360 "3,4 " "B"
"IKN10B0032" "08/10" "Others-ICRISAT(FREE EDUCATION TRIP) " 2000 "1 " "M"
"IKN10B0033" "08/10" "Others-ICRISAT(FREE EDUCATION TRIP) " 2000 "1 " "M"
"IKN10B0034" "08/10" "Others-ICRISAT(FREE EDUCATION TRIP) " 2000 "3 " "M"
"IKN10B0035" "08/10" "Others-ICRISAT(FREE EDUCATION TRIP) " 2000 "1 " "M"
"IKN10B0036" "08/10" "Others-ICRISAT(FREE EDUCATION TRIP) " 2000 "1 " "M"
"IKN10B0037" "08/10" "Others-ICRISAT(FREE EDUCATION TRIP) " 2000 "1 " "M"
"IKN10B0038" "08/10" "Others-ICRISAT(FREE EDUCATION TRIP) " 2000 "1 " "M"
"IKN10B0040" "08/10" "Others-ICRISAT(FREE EDUCATION TRIP) " 2000 "1 " "M"
"IKN10B0041" "08/10" "Others-ICRISAT(FREE EDUCATION TRIP) " 2000 "1 " "M"
"IKN10B0042" "08/10" "Others-ICRISAT(FREE EDUCATION TRIP) " 2000 "1 " "M"
"IKN10B0043" "08/10" "Others-ICRISAT(FREE EDUCATION TRIP) " 2000 "201 " "B"
"IKN10B0044" "08/10" "Others-ICRISAT(FREE EDUCATION TRIP) " 2000 "1 " "M"
"IKN10B0045" "08/10" "Others-ICRISAT(FREE EDUCATION TRIP) " 2000 "1 " "M"
"IKN10B0046" "08/10" "Others-ICRISAT(FREE EDUCATION TRIP) " 2000 "4 " "M"
"IKN10B0047" "08/10" "Others-ICRISAT(FREE EDUCATION TRIP) " 2000 "1 " "M"
"IKN10B0048" "08/10" "Others-ICRISAT(FREE EDUCATION TRIP) " 2000 "1 " "M"
"IKN10B0049" "08/10" "Others-ICRISAT(FREE EDUCATION TRIP) " 2000 "2 " "F"
"IKN10B0050" "08/10" "Others-ICRISAT(FREE EDUCATION TRIP) " 3500 "1,2 " "B"
"IKN10B0051" "08/10" "Others-ICRISAT(FREE EDUCATION TRIP) " 2000 "1 " "M"
"IKN10B0052" "08/10" "Others-ICRISAT(FREE EDUCATION TRIP) " 2000 "2 " "F"
"IKN10B0053" "08/10" "Others-ICRISAT(FREE EDUCATION TRIP) " 2000 "11 " "M"
"IKN10B0054" "08/10" "Others-ICRISAT(FREE EDUCATION TRIP) " 2000 "1 " "M"
"IKN10B0057" "08/10" "Others-ICRISAT(FREE EDUCATION TRIP) " 2000 "1 " "M"
"IKN10B0058" "08/10" "Others-ICRISAT(FREE EDUCATION TRIP) " 2000 "1 " "M"
"IKN10B0059" "08/10" "Others-ICRISAT(FREE EDUCATION TRIP) " 2000 "1 " "M"
"IKN10D0006" "02/11" "Others (SCHOLARSHIP FROM SCHOOL) " 240 "3,4,5 " "B"
"IKN10D0009" "06/11" "UNIFORM & BOOKS IN SCHOOL " 1000 "3,4 " "B"
"IKN10D0009" "07/10" "Others(UNIFORM&BOOKS FROM GOVT.SCHOOL) " 250 "4 " "M"
"IKN10D0030" "06/11" "BOOKS " 400 "3,4 " "M"
"IKN10D0034" "06/11" "Others-UNIFORM&BOOKS " 1000 "3,80 " "M"
"IKN10D0036" "06/11" "Others-UNIFORM&BOOKS " 700 "3,4 " "B"
"IKN10D0036" "06/11" "CYCLE IN SCHOOL " 2000 "3 " "F"
"IKN10D0036" "02/11" "Others (SCHOOL SCHOLARSHIP) " 140 "3,4 " "B"
"IKN10D0037" "05/11" "BOOKS AND UNIFORM " 500 "5 " "F"
"IKN10D0038" "02/11" "Others (SCHOLARSHIP FROM SCHOOL) " 70 "80 " "M"
"IKN10D0045" "06/11" "BOOKS " 400 "3,4 " "B"
"IKN10D0049" "06/11" "Others-UNIFORM&BOOKS " 500 "81 " "F"
"IKN10D0049" "06/11" "BOOKS " 300 "80 " "F"
"IKN10D0051" "06/11" "Others-UNIFORM&BOOKS " 500 "4 " "M"
"IKN10D0051" "06/11" "TEXT BOOKS " 300 "3 " "M"
"IKN10D0054" "02/11" "Others (SCHOLARSHIP IN SCHOOL) " 100 "4 " "F"
"IKN10D0055" "06/11" "Others-UNIFORM&BOOKS " 1000 "5,6 " "M"
"IKN10D0056" "02/11" "Others (SCHOLARSHIP FROM GOVT.SCHOOL) " 70 "6 " "F"
"IKN10D0059" "06/11" "Others (UNIFORM,BOOKS&BAG) " 3000 "7,8,11,12 " "B"
"IMH10B0001" "03/11" "Others (SCHOLARSHIP) " 2100 "202 " "F"
"IMH10B0042" "07/10" "FREE NOTE BOOKS " 300 "15,16 " "F"
"IMH10B0045" "07/10" "FREE NOTE BOOKS " 400 "203,204 " "B"
"IMH10B0217" "07/10" "FREE NOTE BOOKS " 150 "202 " "M"
"IMH10B0233" "07/10" "FREE NOTE BOOKS " 200 "211 " "F"
"IMH10B0237" "07/10" "FREE NOTE BOOKS " 400 "23,24 " "B"
"IMH10C0001" "07/10" "Others (FREE NOTE BOOKS) " 200 "201,202 " "B"
"IMH10C0032" "07/10" "Others (FREE NOTE BOOKS) " 200 " " " "
"IMH10C0034" "08/10" "Others (FREE BOOKS FROM SCHOOL) " 200 " " "M"
end
[/CODE]
and for mid-day meal as:
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input str10 VDS_ID str5 SUR_MON_YR str42 PROG_NAME long AMT_BEN str10 WHO_BEN str1 WHO_SPENT "IAP10A0008" "06/11" "Mid day meal " 90 "14,205 " "B" "IAP10A0008" "04/11" "Mid day meal " 100 "14,205 " "B" "IAP10A0008" "03/11" "Mid day meal " 150 "14,205 " "B" "IAP10A0008" "02/11" "Mid day meal " 160 "14,205 " "B" "IAP10A0008" "01/11" "Mid day meal " 140 "14,205 " "B" "IAP10A0008" "12/10" "Mid day meal " 170 "14,205 " "B" "IAP10A0008" "11/10" "Mid day meal " 160 "14,205 " "B" "IAP10A0008" "10/10" "Mid day meal " 120 "14,205 " "B" "IAP10A0008" "09/10" "Mid day meal " 140 "14,205 " "B" "IAP10A0008" "08/10" "Mid day meal " 150 "14,205 " "B" "IAP10A0008" "07/10" "Mid day meal " 140 "14,205 " "B" "IAP10A0034" "06/11" "Mid day meal " 30 "13 " "F" "IAP10A0034" "04/11" "Mid day meal " 50 "13 " "F" "IAP10A0034" "03/11" "Mid day meal " 80 "13 " "F" "IAP10A0034" "02/11" "Mid day meal " 85 "13 " "F" "IAP10A0034" "01/11" "Mid day meal " 70 "13 " "F" "IAP10A0034" "12/10" "Mid day meal " 95 "13 " "F" "IAP10A0034" "11/10" "Mid day meal " 90 "13 " "F" "IAP10A0034" "10/10" "Mid day meal " 60 "13 " "F" "IAP10A0034" "09/10" "Mid day meal " 75 "13 " "F" "IAP10A0034" "08/10" "Mid day meal " 80 "13 " "F" "IAP10A0034" "07/10" "Mid day meal " 70 "13 " "F" "IAP10A0046" "06/11" "Mid day meal " 50 "13 " "F" "IAP10A0046" "04/11" "Mid day meal " 50 "13 " "F" "IAP10A0046" "03/11" "Mid day meal " 70 "13 " "F" "IAP10A0046" "02/11" "Mid day meal " 80 "13 " "F" "IAP10A0046" "01/11" "Mid day meal " 70 "13 " "F" "IAP10A0046" "12/10" "Mid day meal " 90 "13 " "F" "IAP10A0046" "11/10" "Mid day meal " 85 "13 " "F" "IAP10A0046" "10/10" "Mid day meal " 60 "13 " "F" "IAP10A0046" "09/10" "Mid day meal " 85 "13 " "F" "IAP10A0046" "08/10" "Mid day meal " 80 "13 " "F" "IAP10A0046" "07/10" "Mid day meal " 90 "13 " "F" "IAP10A0202" "06/11" "Mid day meal " 40 "202 " "M" "IAP10A0202" "04/11" "Mid day meal " 60 "202 " "M" "IAP10A0202" "03/11" "Mid day meal " 70 "202 " "M" "IAP10A0202" "02/11" "Mid day meal " 80 "202 " "M" "IAP10A0202" "01/11" "Mid day meal " 75 "202 " "M" "IAP10A0202" "12/10" "Mid day meal " 95 "202 " "M" "IAP10A0202" "11/10" "Mid day meal " 90 "202 " "M" "IAP10A0202" "10/10" "Mid day meal " 65 "202 " "M" "IAP10A0202" "09/10" "Mid day meal " 80 "202 " "M" "IAP10A0202" "08/10" "Mid day meal " 75 "202 " "M" "IAP10A0202" "07/10" "Mid day meal " 65 "202 " "M" "IAP10A0203" "06/11" "Mid day meal " 40 "203 " "M" "IAP10A0203" "04/11" "Mid day meal " 50 "203 " "M" "IAP10A0203" "03/11" "Mid day meal " 75 "203 " "M" "IAP10A0203" "02/11" "Mid day meal " 70 "203 " "M" "IAP10A0203" "01/11" "Mid day meal " 65 "203 " "M" "IAP10A0203" "12/10" "Mid day meal " 90 "203 " "M" "IAP10A0203" "11/10" "Mid day meal " 70 "203 " "M" "IAP10A0203" "10/10" "Mid day meal " 60 "203 " "M" "IAP10A0203" "09/10" "Mid day meal " 75 "203 " "M" "IAP10A0203" "08/10" "Mid day meal " 70 "203 " "M" "IAP10A0203" "07/10" "Mid day meal " 75 "203 " "M" "IAP10A0210" "06/11" "Mid day meal " 40 "12 " "F" "IAP10A0210" "04/11" "Mid day meal " 60 "12 " "F" "IAP10A0210" "03/11" "Mid day meal " 90 "12 " "F" "IAP10A0210" "02/11" "Mid day meal " 85 "12 " "F" "IAP10A0210" "01/11" "Mid day meal " 80 "12 " "F" "IAP10A0210" "12/10" "Mid day meal " 96 "12 " "F" "IAP10A0210" "11/10" "Mid day meal " 90 "12 " "F" "IAP10A0210" "10/10" "Mid day meal " 60 "12 " "F" "IAP10A0210" "09/10" "Mid day meal " 75 "12 " "F" "IAP10A0210" "08/10" "Mid day meal " 80 "12 " "F" "IAP10A0210" "07/10" "Mid day meal " 90 "12 " "F" "IAP10A0216" "06/11" "Mid day meal " 160 "12,13,14 " "B" "IAP10A0216" "04/11" "Mid day meal " 190 "12,13,14 " "B" "IAP10A0216" "03/11" "Mid day meal " 290 "12,13,14 " "B" "IAP10A0216" "02/11" "Mid day meal " 280 "12,13,14 " "B" "IAP10A0216" "01/11" "Mid day meal " 260 "12,13,14 " "B" "IAP10A0216" "12/10" "Mid day meal " 320 "12,13,14 " "B" "IAP10A0216" "11/10" "Mid day meal " 285 "12,13,14 " "B" "IAP10A0216" "10/10" "Mid day meal " 240 "12,13,14 " "B" "IAP10A0216" "09/10" "Mid day meal " 300 "12,13,14 " "B" "IAP10A0216" "08/10" "Mid day meal " 280 "12,13,14,2" "B" "IAP10A0216" "07/10" "Mid day meal " 300 "12,13,14 " "B" "IAP10A0231" "06/11" "Mid day meal " 50 "11 " "M" "IAP10A0231" "04/11" "Mid day meal " 50 "11 " "M" "IAP10A0231" "03/11" "Mid day meal " 80 "11 " "M" "IAP10A0231" "02/11" "Mid day meal " 85 "11 " "M" "IAP10A0231" "01/11" "Mid day meal " 70 "11 " "M" "IAP10A0231" "12/10" "Mid day meal " 90 "11 " "M" "IAP10A0231" "11/10" "Mid day meal " 85 "11 " "M" "IAP10A0231" "10/10" "Mid day meal " 60 "11 " "M" "IAP10A0231" "09/10" "Mid day meal " 80 "11 " "M" "IAP10A0231" "08/10" "Mid day meal " 70 "11 " "M" "IAP10A0231" "07/10" "Mid day meal " 80 "11 " "M" "IAP10A0232" "04/11" "Mid day meal " 50 "13 " "M" "IAP10A0232" "03/11" "Mid day meal " 75 "13 " "M" "IAP10A0232" "02/11" "Mid day meal " 80 "13 " "M" "IAP10A0232" "01/11" "Mid day meal " 80 "13 " "M" "IAP10A0232" "12/10" "Mid day meal " 95 "13 " "M" "IAP10A0232" "11/10" "Mid day meal " 90 "13 " "M" "IAP10A0232" "10/10" "Mid day meal " 70 "13 " "M" "IAP10A0232" "09/10" "Mid day meal " 90 "13 " "M" "IAP10A0232" "08/10" "Mid day meal " 90 "13 " "M" "IAP10A0232" "07/10" "Mid day meal " 80 "13 " "M" "IAP10A0234" "06/11" "Mid day meal " 80 "14,15 " "B" "IAP10A0234" "04/11" "Mid day meal " 120 "14,15 " "B" end
similarly, i have many files that have only VDS_ID and SUR_MON_YR are common but other variables are different.
i want to create a master panel data from these files which will have a format like given below:
VDS_ID SUR_MON_YR PDS PDS_AMT_BENIFT MID_DAY_MEAL MDM_AMT_BENIFT EDU_REL_SUBS ERS_AMT_BENIFT PENSION PENSION_AMT_BENIFT
HEALTH_PROG HP_AMT_BENIFT OTHERS OTHERS_AMT_BENIFT
now I want that for every VDS_ID and SUR_MON_YR I get a panel data set for all variables.
0 Response to merging data files to create a large panel data
Post a Comment