Simple Loops

JackZhang — Mon, 20 Apr 2015 17:47:33 GMT

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

Re: Simple Loops

ballardw — Mon, 20 Apr 2015 17:51:51 GMT

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 — Mon, 20 Apr 2015 18:03:30 GMT

Perfect, Ballardw. Thank you very much