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
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
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
Perfect, Ballardw. Thank you very much
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.