Simple Loops

[JackZhang]

I stuck in a loop question.

For example

I have

SCHED_VOL          LEAD_BATCH    LAG_BATCH   IND

10000.00                 OSH                   MSB                1

10000.00                 MSB                   OSH                 1

20000.00                 OSH                   OSH                 0  

20000.00                 OSH                   MSB                 0

20000.00                 MSB                   OSH                 1

15000.00                 OSH                   OSH                 0

16000.00                 OSH                   MSB                  1

if lead-bath nq lagbatch, i indicate asa 1, otherwise 0.

Now I need run the loops, when it is 0, add cumulative vol,otherwise = sched_VOl

something like this for Cum_VOL

SCHED_VOL          LEAD_BATCH    LAG_BATCH   IND         Cum_VOL

10000.00                 OSH                   MSB                1             10000

10000.00                 MSB                   OSH                 1             10000

20000.00                 OSH                   OSH                 0             30000

20000.00                 OSH                   MSB                 0             50000

20000.00                 MSB                   OSH                 1             20000

15000.00                 OSH                   OSH                 0             35000

16000.00                 OSH                   MSB                  1            16000

I think it is not difficult, but I cannot get exact answer.

Thank you very much

[ballardw · Accepted solution]

Data want;

     set have;

     ind = (LEAD_BATCH ne LAG_BATCH);

     if ind then Cum_VOL=SCHED_VOL;

     else Cum_Col + SCHED_VOL;

run;

might work

[JackZhang]

Perfect, Ballardw. Thank you very much