I want to save this data in different files on the basis of the values of variable order. for example, all the observations in which variable order has value 1 should be saved in one file and the name of the file should be file_1 and similarly, all the observations in which variable order has value 2 should be saved in another file and name of the file should be file_2. and so on
please help me to solve this problem.......thanks in advance
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input str8 HH_ID str5 SUR_MON_YR str28 ITEM_NAME str2 ITEM_UNIT double(QTY_HOME_PROD QTY_PUR QTY_OT) byte OT_CODE double(PRICE_UNIT TOT_VAL) str40 REMARKS float order "IAPA0008" "01/12" "Mid day meal" "Rs" . . 160 1 . 160 "" 1 "IAPA0008" "01/12" "Others(bread, khara, etc.)" "Rs" . 60 . . . 60 "" 2 "IAPA0008" "01/12" "Spices(chillies, salt, etc.)" "Rs" . 330 . . . 330 "" 3 "IAPA0008" "01/12" "Sugar & Gur" "Kg" . 3 . . 31 93 "" 4 "IAPA0008" "01/12" "Tea/coffee powder" "Rs" . 55 . . . 55 "" 5 "IAPA0008" "02/12" "Mid day meal" "Rs" . . 170 1 . 170 "" 1 "IAPA0008" "02/12" "Others(bread, khara, etc.)" "Rs" . 40 . . . 40 "" 2 "IAPA0008" "02/12" "Spices(chillies, salt, etc.)" "Rs" . 280 . . . 280 "" 3 "IAPA0008" "02/12" "Sugar & Gur" "Kg" . 2.5 . . 32 80 "" 4 "IAPA0008" "02/12" "Tea/coffee powder" "Rs" . 50 . . . 50 "" 5 "IAPA0008" "03/12" "Mid day meal" "Rs" . . 160 1 . 160 "" 1 "IAPA0008" "03/12" "Others(bread, khara, etc.)" "Rs" . 60 . . . 60 "" 2 "IAPA0008" "03/12" "Spices(chillies, salt, etc.)" "Rs" . 300 . . . 300 "" 3 "IAPA0008" "03/12" "Sugar & Gur" "Kg" . 3 . . 32 96 "" 4 "IAPA0008" "03/12" "Tea/coffee powder" "Rs" . 45 . . . 45 "" 5 "IAPA0008" "04/12" "Mid day meal" "Rs" . . 110 1 . 110 "" 1 "IAPA0008" "04/12" "Others(bread, khara, etc.)" "Rs" . 40 . . . 40 "" 2 "IAPA0008" "04/12" "Spices(chillies, salt, etc.)" "Rs" . 310 . . . 310 "" 3 "IAPA0008" "04/12" "Sugar & Gur" "Kg" . 4 . . 30 120 "" 4 "IAPA0008" "04/12" "Tea/coffee powder" "Rs" . 60 . . . 60 "" 5 "IAPA0008" "05/12" "Others(bread, khara, etc.)" "Rs" . 30 . . . 30 "" 1 "IAPA0008" "05/12" "Spices(chillies, salt, etc.)" "Rs" . 300 . . . 300 "" 2 "IAPA0008" "05/12" "Sugar & Gur" "Kg" . 4 . . 34 136 "" 3 "IAPA0008" "05/12" "Tea/coffee powder" "Rs" . 70 . . . 70 "" 4 "IAPA0008" "06/12" "Mid day meal" "Rs" . . 120 1 . 120 "" 1 "IAPA0008" "06/12" "Others(bread, khara, etc.)" "Rs" . 75 . . . 75 "" 2 "IAPA0008" "06/12" "Spices(chillies, salt, etc.)" "Rs" . 310 . . . 310 "" 3 "IAPA0008" "06/12" "Sugar & Gur" "Kg" . 4 . . 30 120 "" 4 "IAPA0008" "06/12" "Tea/coffee powder" "Rs" . 80 . . . 80 "" 5 "IAPA0008" "07/11" "Mid day meal" "Rs" . . 150 1 . 150 "" 1 "IAPA0008" "07/11" "Others(bread, khara, etc.)" "Rs" . 60 . . . 60 "" 2 "IAPA0008" "07/11" "Spices(chillies, salt, etc.)" "Rs" . 325 . . . 325 "" 3 "IAPA0008" "07/11" "Sugar & Gur" "Kg" . 2 . . 30 60 "" 4 "IAPA0008" "07/11" "Tea/coffee powder" "Rs" . 50 . . . 50 "" 5 "IAPA0008" "08/11" "Mid day meal" "Rs" . . 160 1 . 160 "" 1 "IAPA0008" "08/11" "Others(bread, khara, etc.)" "Rs" . 50 . . . 50 "" 2 "IAPA0008" "08/11" "Spices(chillies, salt, etc.)" "Rs" . 360 . . . 360 "" 3 "IAPA0008" "08/11" "Sugar & Gur" "Kg" . 2.5 . . 31 77.5 "" 4 "IAPA0008" "08/11" "Tea/coffee powder" "Rs" . 55 . . . 55 "" 5 "IAPA0008" "09/11" "Mid day meal" "Rs" . . 100 1 . 100 "" 1 "IAPA0008" "09/11" "Others(bread, khara, etc.)" "Rs" . 60 . . . 60 "" 2 "IAPA0008" "09/11" "Spices(chillies, salt, etc.)" "Rs" . 340 . . . 340 "" 3 "IAPA0008" "09/11" "Sugar & Gur" "Kg" . 3 . . 28 84 "" 4 "IAPA0008" "09/11" "Tea/coffee powder" "Rs" . 60 . . . 60 "" 5 "IAPA0008" "10/11" "Mid day meal" "Rs" . . 110 1 . 110 "" 1 "IAPA0008" "10/11" "Others(bread, khara, etc.)" "Rs" . 50 . . . 50 "" 2 "IAPA0008" "10/11" "Spices(chillies, salt, etc.)" "Rs" . 420 . . . 420 "" 3 "IAPA0008" "10/11" "Sugar & Gur" "Kg" . 3 . . 29 87 "" 4 "IAPA0008" "10/11" "Tea/coffee powder" "Rs" . 65 . . . 65 "" 5 "IAPA0008" "11/11" "Mid day meal" "Rs" . . 180 1 . 180 "" 1 "IAPA0008" "11/11" "Others(bread, khara, etc.)" "Rs" . 60 . . . 60 "" 2 "IAPA0008" "11/11" "Spices(chillies, salt, etc.)" "Rs" . 340 . . . 340 "" 3 "IAPA0008" "11/11" "Sugar & Gur" "Kg" . 2 . . 28 56 "" 4 "IAPA0008" "11/11" "Tea/coffee powder" "Rs" . 50 . . . 50 "" 5 "IAPA0008" "12/11" "Mid day meal" "Rs" . . 185 1 . 185 "" 1 "IAPA0008" "12/11" "Others(bread, khara, etc.)" "Rs" . 80 . . . 80 "" 2 "IAPA0008" "12/11" "Spices(chillies, salt, etc.)" "Rs" . 390 . . . 390 "" 3 "IAPA0008" "12/11" "Sugar & Gur" "Kg" . 2.5 . . 29 72.5 "" 4 "IAPA0008" "12/11" "Tea/coffee powder" "Rs" . 55 . . . 55 "" 5 "IAPA0009" "01/12" "Meal/tiffin/tea in hotel" "Rs" . 90 . . . 90 "" 1 "IAPA0009" "01/12" "Others(bread, khara, etc.)" "Rs" . 20 . . . 20 "" 2 "IAPA0009" "01/12" "Spices(chillies, salt, etc.)" "Rs" . 120 . . . 120 "" 3 "IAPA0009" "01/12" "Sugar & Gur" "Kg" . .5 . . 14 7 "" 4 "IAPA0009" "02/12" "Meal/tiffin/tea in hotel" "Rs" . 90 . . . 90 "" 1 "IAPA0009" "02/12" "Others(bread, khara, etc.)" "Rs" . 30 . . . 30 "" 2 "IAPA0009" "02/12" "Spices(chillies, salt, etc.)" "Rs" . 105 . . . 105 "" 3 "IAPA0009" "03/12" "Meal/tiffin/tea in hotel" "Rs" . 96 . . . 96 "" 1 "IAPA0009" "03/12" "Others(bread, khara, etc.)" "Rs" . 40 . . . 40 "" 2 "IAPA0009" "03/12" "Spices(chillies, salt, etc.)" "Rs" . 110 . . . 110 "" 3 "IAPA0009" "03/12" "Sugar & Gur" "Kg" . .5 . . 15 7.5 "" 4 "IAPA0009" "04/12" "Meal/tiffin/tea in hotel" "Rs" . 60 . . . 60 "" 1 "IAPA0009" "04/12" "Others(bread, khara, etc.)" "Rs" . 30 . . . 30 "" 2 "IAPA0009" "04/12" "Spices(chillies, salt, etc.)" "Rs" . 100 . . . 100 "" 3 "IAPA0009" "04/12" "Sugar & Gur" "Kg" . .5 . . 14 7 "PDS" 4 "IAPA0009" "05/12" "Meal/tiffin/tea in hotel" "Rs" . 70 . . . 70 "" 1 "IAPA0009" "05/12" "Others(bread, khara, etc.)" "Rs" . 40 . . . 40 "" 2 "IAPA0009" "05/12" "Spices(chillies, salt, etc.)" "Rs" . 95 . . . 95 "" 3 "IAPA0009" "06/12" "Meal/tiffin/tea in hotel" "Rs" . 90 . . . 90 "" 1 "IAPA0009" "06/12" "Others(bread, khara, etc.)" "Rs" . 20 . . . 20 "" 2 "IAPA0009" "06/12" "Spices(chillies, salt, etc.)" "Rs" . 100 . . . 100 "" 3 "IAPA0009" "06/12" "Sugar & Gur" "Kg" . 1 . . 15 15 "PDS" 4 "IAPA0009" "07/11" "Meal/tiffin/tea in hotel" "Rs" . 90 . . . 90 "" 1 "IAPA0009" "07/11" "Others(bread, khara, etc.)" "Rs" . 10 . . . 10 "" 2 "IAPA0009" "07/11" "Spices(chillies, salt, etc.)" "Rs" . 80 . . . 80 "" 3 "IAPA0009" "07/11" "Sugar & Gur" "Kg" . .5 . . 14 7 "" 4 "IAPA0009" "08/11" "Meal/tiffin/tea in hotel" "Rs" . 90 . . . 90 "" 1 "IAPA0009" "08/11" "Others(bread, khara, etc.)" "Rs" . 30 . . . 30 "" 2 "IAPA0009" "08/11" "Spices(chillies, salt, etc.)" "Rs" . 90 . . . 90 "" 3 "IAPA0009" "09/11" "Meal/tiffin/tea in hotel" "Rs" . 100 . . . 100 "" 1 "IAPA0009" "09/11" "Others(bread, khara, etc.)" "Rs" . 20 . . . 20 "" 2 "IAPA0009" "09/11" "Spices(chillies, salt, etc.)" "Rs" . 100 . . . 100 "" 3 "IAPA0009" "09/11" "Sugar & Gur" "Kg" . 1 . . 15 15 "" 4 "IAPA0009" "10/11" "Meal/tiffin/tea in hotel" "Rs" . 90 . . . 90 "" 1 "IAPA0009" "10/11" "Others(bread, khara, etc.)" "Rs" . 30 . . . 30 "" 2 "IAPA0009" "10/11" "Spices(chillies, salt, etc.)" "Rs" . 125 . . . 125 "" 3 "IAPA0009" "10/11" "Sugar & Gur" "Kg" . .5 . . 14 7 "" 4 "IAPA0009" "11/11" "Meal/tiffin/tea in hotel" "Rs" . 90 . . . 90 "" 1 "IAPA0009" "11/11" "Others(bread, khara, etc.)" "Rs" . 20 . . . 20 "" 2 "IAPA0009" "11/11" "Spices(chillies, salt, etc.)" "Rs" . 125 . . . 125 "" 3 "IAPA0009" "11/11" "Sugar & Gur" "Kg" . .5 . . 14 7 "" 4 end
0 Response to save data in different file on the basis of variable values
Post a Comment