DATA Step, Macro, Functions and more

Loop Question

Reply
Occasional Contributor
Posts: 12

Loop Question

if my data looks like this 

 

cust_id        flag

101               N

101               Y

101               N

101               N

102               N   

102               Y

102               N

 

i need my output as below

 

cust_id        flag

101               N

101               Y

101               Y

101               Y

102               N   

102               Y

102               Y

 

Please help me on this asap.

 

Thanks in advance.

 

Trusted Advisor
Posts: 1,400

Re: Loop Question

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;

Ask a Question
Discussion stats
  • 1 reply
  • 171 views
  • 0 likes
  • 2 in conversation