using foreeach loop for doing repeating work

i want to save observations in different files on the basis of values of variable order. i have lots of files in which i have to do same task so i want to use loop for this. i have given example data and code used below. please help me

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" "Milk" "Lt"  .    5    . . 40    200 "" 1
"IAPA0008" "02/12" "Milk" "Lt"  .  4.5    . . 40    180 "" 1
"IAPA0008" "03/12" "Milk" "Lt"  .    3    . . 40    120 "" 1
"IAPA0008" "04/12" "Milk" "Lt"  .    4    . . 40    160 "" 1
"IAPA0008" "05/12" "Milk" "Lt"  .  4.5    . . 40    180 "" 1
"IAPA0008" "06/12" "Milk" "Lt"  .    4    . . 40    160 "" 1
"IAPA0008" "07/11" "Milk" "Lt"  .    5    . . 28    140 "" 1
"IAPA0008" "08/11" "Milk" "Lt"  .    8    . . 32    256 "" 1
"IAPA0008" "09/11" "Milk" "Lt"  .  7.5    . . 32    240 "" 1
"IAPA0008" "10/11" "Milk" "Lt"  .    4    . . 32    128 "" 1
"IAPA0008" "11/11" "Milk" "Lt"  .    2    . . 40     80 "" 1
"IAPA0008" "12/11" "Milk" "Lt"  .  7.5    . . 40    300 "" 1
"IAPA0010" "01/12" "Milk" "Lt"  .    5    . . 40    200 "" 1
"IAPA0010" "02/12" "Milk" "Lt"  .  4.5    . . 40    180 "" 1
"IAPA0010" "03/12" "Milk" "Lt"  .    4    . . 40    160 "" 1
"IAPA0010" "04/12" "Milk" "Lt"  .  7.5    . . 40    300 "" 1
"IAPA0010" "05/12" "Milk" "Lt"  . 7.75    . . 40    310 "" 1
"IAPA0010" "06/12" "Milk" "Lt"  .  7.5    . . 40    300 "" 1
"IAPA0010" "07/11" "Milk" "Lt"  .    5    . . 32    160 "" 1
"IAPA0010" "08/11" "Milk" "Lt"  .  5.5    . . 32    176 "" 1
"IAPA0010" "09/11" "Milk" "Lt"  .    5    . . 40    200 "" 1
"IAPA0010" "10/11" "Milk" "Lt"  .  5.5    . . 40    220 "" 1
"IAPA0010" "11/11" "Milk" "Lt"  .    5    . . 40    200 "" 1
"IAPA0010" "12/11" "Milk" "Lt"  .  5.5    . . 40    220 "" 1
"IAPA0030" "01/12" "Milk" "Lt"  .    .    8 1 20    160 "" 1
"IAPA0030" "02/12" "Milk" "Lt"  .    .    7 1 20    140 "" 1
"IAPA0030" "03/12" "Milk" "Lt"  .    . 7.75 1 24    186 "" 1
"IAPA0030" "04/12" "Milk" "Lt"  .    .  7.5 1 20    150 "" 1
"IAPA0030" "05/12" "Milk" "Lt"  .    . 7.75 1 20    155 "" 1
"IAPA0030" "06/12" "Milk" "Lt"  .    .  7.5 1 20    150 "" 1
"IAPA0030" "07/11" "Milk" "Lt"  .    . 7.75 1 28    217 "" 1
"IAPA0030" "08/11" "Milk" "Lt"  .    . 7.75 1 24    186 "" 1
"IAPA0030" "09/11" "Milk" "Lt"  .    .    8 1 20    160 "" 1
"IAPA0030" "10/11" "Milk" "Lt"  .    .    7 1 20    140 "" 1
"IAPA0030" "11/11" "Milk" "Lt"  .    .    8 1 20    160 "" 1
"IAPA0030" "12/11" "Milk" "Lt"  .    .    8 1 20    160 "" 1
"IAPA0034" "01/12" "Milk" "Lt"  . 7.75    . . 32    248 "" 1
"IAPA0034" "02/12" "Milk" "Lt"  .    7    . . 32    224 "" 1
"IAPA0034" "03/12" "Milk" "Lt"  .  4.5    . . 32    144 "" 1
"IAPA0034" "07/11" "Milk" "Lt"  .    4    . . 32    128 "" 1
"IAPA0034" "08/11" "Milk" "Lt"  .   15    . . 32    480 "" 1
"IAPA0034" "09/11" "Milk" "Lt"  .  7.5    . . 32    240 "" 1
"IAPA0034" "10/11" "Milk" "Lt"  . 7.75    . . 32    248 "" 1
"IAPA0034" "11/11" "Milk" "Lt"  .  7.5    . . 32    240 "" 1
"IAPA0034" "12/11" "Milk" "Lt"  . 7.75    . . 32    248 "" 1
"IAPA0035" "01/12" "Milk" "Lt"  .    . 7.75 1 32    248 "" 1
"IAPA0035" "02/12" "Milk" "Lt"  .    .    7 1 32    224 "" 1
"IAPA0035" "03/12" "Milk" "Lt"  .    . 7.75 1 29 224.75 "" 1
"IAPA0035" "04/12" "Milk" "Lt"  .  7.5    . . 32    240 "" 1
"IAPA0035" "05/12" "Milk" "Lt"  .  7.5    . . 32    240 "" 1
"IAPA0035" "07/11" "Milk" "Lt"  . 7.75    . . 28    217 "" 1
"IAPA0035" "08/11" "Milk" "Lt"  .  7.5    . . 28    210 "" 1
"IAPA0035" "09/11" "Milk" "Lt"  .  7.5    . . 32    240 "" 1
"IAPA0035" "10/11" "Milk" "Lt"  .  7.5    . . 32    240 "" 1
"IAPA0035" "11/11" "Milk" "Lt"  .    .  7.5 1 32    240 "" 1
"IAPA0035" "12/11" "Milk" "Lt"  .    . 7.75 1 32    248 "" 1
"IAPA0036" "01/12" "Milk" "Lt"  .    .    5 1 20    100 "" 1
"IAPA0036" "04/12" "Milk" "Lt"  .    .    4 1 28    112 "" 1
"IAPA0036" "05/12" "Milk" "Lt"  .    .    4 1 28    112 "" 1
"IAPA0036" "06/12" "Milk" "Lt"  .    .    5 1 28    140 "" 1
"IAPA0036" "07/11" "Milk" "Lt"  .    .    5 1 24    120 "" 1
"IAPA0036" "08/11" "Milk" "Lt"  .    .    5 1 24    120 "" 1
"IAPA0036" "09/11" "Milk" "Lt"  .    .    4 1 24     96 "" 1
"IAPA0036" "10/11" "Milk" "Lt"  .    .    5 1 24    120 "" 1
"IAPA0036" "11/11" "Milk" "Lt"  .    .    5 1 24    120 "" 1
"IAPA0036" "12/11" "Milk" "Lt"  .    .    5 1 20    100 "" 1
"IAPA0038" "01/12" "Milk" "Lt"  . 7.75    . . 32    248 "" 1
"IAPA0038" "02/12" "Milk" "Lt"  .    7    . . 32    224 "" 1
"IAPA0038" "03/12" "Milk" "Lt"  . 7.75    . . 32    248 "" 1
"IAPA0038" "04/12" "Milk" "Lt"  .  4.5    . . 40    180 "" 1
"IAPA0038" "05/12" "Milk" "Lt"  .  4.5    . . 40    180 "" 1
"IAPA0038" "06/12" "Milk" "Lt"  .  4.5    . . 40    180 "" 1
"IAPA0038" "07/11" "Milk" "Lt"  .  7.5    . . 28    210 "" 1
"IAPA0038" "08/11" "Milk" "Lt"  .    8    . . 32    256 "" 1
"IAPA0038" "09/11" "Milk" "Lt"  .  7.5    . . 32    240 "" 1
"IAPA0038" "10/11" "Milk" "Lt"  .   11    . . 32    352 "" 1
"IAPA0038" "11/11" "Milk" "Lt"  .  7.5    . . 40    300 "" 1
"IAPA0038" "12/11" "Milk" "Lt"  . 7.75    . . 32    248 "" 1
"IAPA0039" "01/12" "Milk" "Lt"  .    5    . . 40    200 "" 1
"IAPA0039" "02/12" "Milk" "Lt"  .  4.5    . . 32    144 "" 1
"IAPA0039" "03/12" "Milk" "Lt"  .    4    . . 32    128 "" 1
"IAPA0039" "05/12" "Milk" "Lt"  .  4.5    . . 40    180 "" 1
"IAPA0039" "06/12" "Milk" "Lt"  . 4.75    . . 40    190 "" 1
"IAPA0039" "07/11" "Milk" "Lt"  .    5    . . 32    160 "" 1
"IAPA0039" "08/11" "Milk" "Lt"  .  4.5    . . 32    144 "" 1
"IAPA0039" "09/11" "Milk" "Lt"  .    5    . . 32    160 "" 1
"IAPA0039" "10/11" "Milk" "Lt"  .  5.5    . . 32    176 "" 1
"IAPA0039" "11/11" "Milk" "Lt"  .    5    . . 40    200 "" 1
"IAPA0039" "12/11" "Milk" "Lt"  .    5    . . 24    120 "" 1
"IAPA0043" "01/12" "Milk" "Lt"  . 15.5    . . 20    310 "" 1
"IAPA0043" "02/12" "Milk" "Lt"  .    7    . . 32    224 "" 1
"IAPA0043" "03/12" "Milk" "Lt"  . 7.75    . . 32    248 "" 1
"IAPA0043" "04/12" "Milk" "Lt"  .  7.5    . . 32    240 "" 1
"IAPA0043" "05/12" "Milk" "Lt"  . 15.5    . . 40    620 "" 1
"IAPA0043" "06/12" "Milk" "Lt"  .   15    . . 40    600 "" 1
"IAPA0043" "07/11" "Milk" "Lt" 15    .    . . 30    450 "" 1
"IAPA0043" "08/11" "Milk" "Lt"  . 7.75    . . 32    248 "" 1
"IAPA0043" "09/11" "Milk" "Lt"  .  7.5    . . 32    240 "" 1
"IAPA0043" "10/11" "Milk" "Lt"  . 7.75    . . 40    310 "" 1
"IAPA0043" "11/11" "Milk" "Lt"  .    5    . . 40    200 "" 1
end

Code:

clear
use "C:\Users\Rahul\Desktop\phd\project\sat2011\transaction\food\milk.dta"
order HH_ID, before(SUR_MON_YR)
bys HH_ID- SUR_MON_YR (ITEM_NAME ): gen order=_n
foreach  x of order {
        savesome if order == x using milk_x.dta
        drop order
        clear
        }

After running this code i got result :
invalid syntax
r(198);

Share on FacebookPlus on Google+