Loop Question

SBRVamsi — Fri, 14 Oct 2016 07:47:47 GMT

if my data looks like this

cust_id flag

101 N

101 Y

101 N

102 N

102 Y

102 N

i need my output as below

cust_id flag

101 N

101 Y

102 N

102 Y

Please help me on this asap.

Thanks in advance.

Re: Loop Question

Shmuel — Fri, 14 Oct 2016 15:53:27 GMT

data want;

set have;

by cust_id;

retain flag1; drop flag1;

if first.cust_id or flag = 'Y' then flag_1 = flag;

else flag = flag1;

run;