I want to merge all the files into one by VDS_ID and SUR_MON_YR.
i have used the xls2dta command. it is converting the excel files into data but not merging the files.
files contain variables like
----------------------- copy starting from the next line -----------------------
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input str10 VDS_ID str5 SUR_MON_YR str18 ITEM_TYPE str32 ITEM_NAME str6 ITEM_UNIT str8(QTY_HOME_PROD QTY_PUR QTY_OT) str1 OT_CODE str8 PRICE_UNIT double TOT_VAL str40 REMARKS "IKN14A0001" "07/14" "Cereals " "PDS Rice " "Kg " " " "27" " " " " "1" 27 " " "IKN14A0001" "07/14" "Cereals " "PDS Wheat " "Kg " " " "3" " " " " "1" 3 " " "IKN14A0001" "07/14" "Cereals " "Finger millet " "Kg " " " "10" " " " " "18" 180 " " "IKN14A0001" "07/14" "Pulses " "Pigeonpea dal (Tur) " "Kg " " " "1" " " " " "50" 50 " " "IKN14A0001" "07/14" "Pulses " "Matki/Cowpea " "Kg " " " "1" " " " " "40" 40 " " "IKN14A0001" "07/14" "Pulses " "D.lab lab/Greenpea/Horsegram " "Kg " " " " " ".5" "1" "16" 8 " " "IKN14A0001" "07/14" "Oils " "Palm oil/Dalda " "Lt " " " "1" " " " " "70" 70 " " "IKN14A0001" "07/14" "Vegetables " "Potato " "Kg " " " "1" " " " " "20" 20 " " "IKN14A0001" "07/14" "Vegetables " "Onion " "Kg " " " "2" " " " " "15" 30 " " "IKN14A0001" "07/14" "Vegetables " "Carrot " "Kg " " " ".5" " " " " "20" 10 " " "IKN14A0001" "07/14" "Vegetables " "Bottle gourd " "Kg " ".5" " " " " " " "15" 7.5 " " "IKN14A0001" "07/14" "Vegetables " "Tomato " "Kg " " " "2" " " " " "20" 40 " " "IKN14A0001" "07/14" "Vegetables " "Ladys finger " "Kg " " " " " "1" "1" "15" 15 " " "IKN14A0001" "07/14" "Vegetables " "Beans " "Kg " " " "1" " " " " "30" 30 " " "IKN14A0001" "07/14" "Vegetables " "Chillies " "Kg " " " ".5" " " " " "20" 10 " " "IKN14A0001" "07/14" "Vegetables " "Radish " "Kg " " " " " "1" "1" "15" 15 " " "IKN14A0001" "07/14" "Leafy vegetables " "Coriander leaves " "Kg " " " ".25" " " " " "40" 10 " " "IKN14A0001" "07/14" "Fruits " "Banana " "Kg " " " "1" " " " " "40" 40 " " "IKN14A0001" "07/14" "Fruits " "Papaya " "Kg " "1" " " " " " " "15" 15 " " "IKN14A0001" "07/14" "Milk & Milk Prod. " "Milk " "Lt " " " "4" " " " " "25" 100 " " "IKN14A0001" "07/14" "Other food Items " "Spices(chillies, salt, etc.) " "Rs " "20" "90" " " " " " " 110 " " "IKN14A0001" "07/14" "Other food Items " "Sugar & Gur " "Kg " " " "2" " " " " "35" 70 " " "IKN14A0001" "07/14" "Other food Items " "Tea/coffee powder " "Kg " " " ".1" " " " " "180" 18 " " "IKN14A0001" "07/14" "Other food Items " "Chicken " "Kg " " " "1" " " " " "140" 140 " " "IKN14A0001" "07/14" "Other food Items " "Eggs " "No " " " "4" " " " " "4.5" 18 " " "IKN14A0001" "07/14" "Other food Items " "Meal/tiffin/tea in hotel " "Rs " " " "250" " " " " " " 250 " " "IKN14A0001" "07/14" "Other food Items " "Others(bread, khara, etc.) " "Rs " " " "90" " " " " " " 90 " " "IKN14A0001" "07/14" "Other food Items " "Mid day meal " "Rs " " " " " "300" "1" " " 300 " " "IKN14A0001" "07/14" "Other food Items " "Soc. meal(Marriage, etc.)No.-2 " "Rs " " " " " "150" "1" " " 150 " " "IKN14A0001" "08/14" "Cereals " "PDS Rice " "Kg " " " "27" " " " " "1" 27 " " "IKN14A0001" "08/14" "Cereals " "PDS Wheat " "Kg " " " "3" " " " " "1" 3 " " "IKN14A0001" "08/14" "Cereals " "Finger millet " "Kg " " " "10" " " " " "18" 180 " " "IKN14A0001" "08/14" "Pulses " "Pigeonpea dal (Tur) " "Kg " " " ".5" " " " " "50" 25 " " "IKN14A0001" "08/14" "Pulses " "Chickpea dal(Chenna) " "Kg " " " ".5" " " " " "50" 25 " " "IKN14A0001" "08/14" "Pulses " "Matki/Cowpea " "Kg " " " "1" " " " " "40" 40 " " "IKN14A0001" "08/14" "Pulses " "D.lab lab/Greenpea/Horsegram " "Kg " " " "1" " " " " "16" 16 " " "IKN14A0001" "08/14" "Oils " "Palm oil/Dalda " "Lt " " " "2" " " " " "70" 140 " " "IKN14A0001" "08/14" "Vegetables " "Potato " "Kg " " " "1" " " " " "25" 25 " " "IKN14A0001" "08/14" "Vegetables " "Onion " "Kg " " " "3" " " " " "25" 75 " " "IKN14A0001" "08/14" "Vegetables " "Carrot " "Kg " " " "1" " " " " "20" 20 " " "IKN14A0001" "08/14" "Vegetables " "Bottle gourd " "Kg " "1" " " " " " " "15" 15 " " "IKN14A0001" "08/14" "Vegetables " "Tomato " "Kg " " " "2" " " " " "30" 60 " " "IKN14A0001" "08/14" "Vegetables " "Ladys finger " "Kg " " " " " "1" "1" "15" 15 " " "IKN14A0001" "08/14" "Vegetables " "Brinjal " "Kg " " " " " "1" "1" "20" 20 " " "IKN14A0001" "08/14" "Vegetables " "Chillies " "Kg " " " ".25" " " " " "40" 10 " " "IKN14A0001" "08/14" "Vegetables " "Radish " "Kg " " " " " "1" "1" "10" 10 " " "IKN14A0001" "08/14" "Leafy vegetables " "Coriander leaves " "Kg " " " ".2" " " " " "40" 8 " " "IKN14A0001" "08/14" "Leafy vegetables " "Amaranth " "Kg " " " " " "1" "1" "15" 15 " " "IKN14A0001" "08/14" "Fruits " "Banana " "Kg " " " "1" " " " " "35" 35 " " "IKN14A0001" "08/14" "Milk & Milk Prod. " "Milk " "Lt " " " "2" " " " " "25" 50 " " "IKN14A0001" "08/14" "Other food Items " "Spices(chillies, salt, etc.) " "Rs " "20" "100" " " " " " " 120 " " "IKN14A0001" "08/14" "Other food Items " "Sugar & Gur " "Kg " " " "1" " " " " "34" 34 " " "IKN14A0001" "08/14" "Other food Items " "Tea/coffee powder " "Kg " " " ".1" " " " " "180" 18 " " "IKN14A0001" "08/14" "Other food Items " "Chicken " "Kg " " " "1" " " " " "140" 140 " " "IKN14A0001" "08/14" "Other food Items " "Meal/tiffin/tea in hotel " "Rs " " " "200" " " " " " " 200 " " "IKN14A0001" "08/14" "Other food Items " "Others(bread, khara, etc.) " "Rs " " " "40" "20" "1" " " 60 " " "IKN14A0001" "08/14" "Other food Items " "Mid day meal " "Rs " " " " " "300" "1" " " 300 " " "IKN14A0001" "08/14" "Other food Items " "Soc. meal(Marriage, etc.)No.-3 " "Rs " " " " " "200" "1" " " 200 " " "IKN14A0001" "08/14" "Other food Items " "Beverages(Cool drinks) " "Rs " " " "15" " " " " " " 15 " " "IKN14A0001" "09/14" "Cereals " "PDS Rice " "Kg " " " "27" " " " " "1" 27 " " "IKN14A0001" "09/14" "Cereals " "PDS Wheat " "Kg " " " "3" " " " " "1" 3 " " "IKN14A0001" "09/14" "Cereals " "Finger millet " "Kg " " " "10" " " " " "18" 180 " " "IKN14A0001" "09/14" "Pulses " "Pigeonpea dal (Tur) " "Kg " " " "1" " " " " "50" 50 " " "IKN14A0001" "09/14" "Pulses " "Chickpea dal(Chenna) " "Kg " " " ".25" " " " " "60" 15 " " "IKN14A0001" "09/14" "Pulses " "Matki/Cowpea " "Kg " " " "1" " " " " "40" 40 " " "IKN14A0001" "09/14" "Pulses " "D.lab lab/Greenpea/Horsegram " "Kg " " " "1" " " " " "20" 20 " " "IKN14A0001" "09/14" "Oils " "Palm oil/Dalda " "Lt " " " "2" " " " " "70" 140 " " "IKN14A0001" "09/14" "Vegetables " "Potato " "Kg " " " "1" " " " " "20" 20 " " "IKN14A0001" "09/14" "Vegetables " "Onion " "Kg " " " "3" " " " " "25" 75 " " "IKN14A0001" "09/14" "Vegetables " "Carrot " "Kg " " " "1" " " " " "20" 20 " " "IKN14A0001" "09/14" "Vegetables " "Tomato " "Kg " " " "4" " " " " "5" 20 " " "IKN14A0001" "09/14" "Vegetables " "Ladys finger " "Kg " " " " " "1" "1" "15" 15 " " "IKN14A0001" "09/14" "Vegetables " "Beans " "Kg " " " "1" " " " " "40" 40 " " "IKN14A0001" "09/14" "Vegetables " "Chillies " "Kg " " " ".5" " " " " "40" 20 " " "IKN14A0001" "09/14" "Vegetables " "Brinjal " "Kg " " " "1" " " " " "10" 10 " " "IKN14A0001" "09/14" "Leafy vegetables " "Amaranth " "Kg " " " "1" " " " " "15" 15 " " "IKN14A0001" "09/14" "Leafy vegetables " "Coriander leaves " "Kg " " " ".25" " " " " "40" 10 " " "IKN14A0001" "09/14" "Fruits " "Banana " "Kg " " " "1" " " " " "25" 25 " " "IKN14A0001" "09/14" "Milk & Milk Prod. " "Milk " "Lt " " " "2" " " " " "25" 50 " " "IKN14A0001" "09/14" "Other food Items " "Spices(chillies, salt, etc.) " "Rs " "20" "100" " " " " " " 120 " " "IKN14A0001" "09/14" "Other food Items " "Sugar & Gur " "Kg " " " "1" " " " " "34" 34 " " "IKN14A0001" "09/14" "Other food Items " "Tea/coffee powder " "Kg " " " ".1" " " " " "180" 18 " " "IKN14A0001" "09/14" "Other food Items " "Chicken " "Kg " " " "1" " " " " "140" 140 " " "IKN14A0001" "09/14" "Other food Items " "Meal/tiffin/tea in hotel " "Rs " " " "200" " " " " " " 200 " " "IKN14A0001" "09/14" "Other food Items " "Others(bread, khara, etc.) " "Rs " " " "40" "20" "1" " " 60 " " "IKN14A0001" "09/14" "Other food Items " "Mid day meal " "Rs " " " " " "300" "1" " " 300 " " "IKN14A0001" "09/14" "Other food Items " "Soc. meal(Marriage, etc.)No.-3 " "Rs " " " " " "400" "1" " " 400 " " "IKN14A0001" "09/14" "Other food Items " "Beverages(Cool drinks) " "Rs " " " "50" " " " " " " 50 " " "IKN14A0001" "10/14" "Cereals " "PDS Rice " "Kg " " " "27" " " " " "1" 27 " " "IKN14A0001" "10/14" "Cereals " "PDS Wheat " "Kg " " " "3" " " " " "1" 3 " " "IKN14A0001" "10/14" "Cereals " "Finger millet " "Kg " " " "10" " " " " "18" 180 " " "IKN14A0001" "10/14" "Pulses " "Pigeonpea dal (Tur) " "Kg " " " "1" " " " " "50" 50 " " "IKN14A0001" "10/14" "Pulses " "Chickpea dal(Chenna) " "Kg " " " ".25" " " " " "60" 15 " " "IKN14A0001" "10/14" "Pulses " "Matki/Cowpea " "Kg " " " "1" " " " " "40" 40 " " "IKN14A0001" "10/14" "Pulses " "D.lab lab/Greenpea/Horsegram " "Kg " " " " " "1" "1" "18" 18 " " "IKN14A0001" "10/14" "Oils " "Palm oil/Dalda " "Lt " " " "2" " " " " "70" 140 " " "IKN14A0001" "10/14" "Vegetables " "Potato " "Kg " " " "1" " " " " "20" 20 " " "IKN14A0001" "10/14" "Vegetables " "Onion " "Kg " " " "3" " " " " "10" 30 " " "IKN14A0001" "10/14" "Vegetables " "Carrot " "Kg " " " "1" " " " " "25" 25 " " "IKN14A0001" "10/14" "Vegetables " "Bottle gourd " "Kg " "1" " " " " " " "10" 10 " " end
Listed 100 out of 63326 observations
Use the count() option to list more
please help me to find solution.
Array
0 Response to merging multiple excel file from a folder using key variable household id and month
Post a Comment