how to find this output

[Chiranjeevi]

id       month   sale   flag

101    m1       230    0

101    m2       240    1

101    m3       230    0

102    m1       450    0

102   m2        430    1

102   m3        480     1

102   m4       450      0

[PaigeMiller]

As with your earlier question, you need to provide a lot more details.

As stated, this is not a SAS question at all. In fact, it's not a question at all.

[thomp7050]

data have;  
input id month $ sale flag  ; 
cards;  
101 m1 230 0
101 m2 240 1
101 m3 230 0
102 m1 450 0
102 m2 430 1
102 m3 480 1
102 m4 450 0
;
run;

[Ksharp]

What is your logic?


data have;  
input id month $ sale   ; 
cards;  
101 m1 230 0
101 m2 240 1
101 m3 230 0
102 m1 450 0
102 m2 430 1
102 m3 480 1
102 m4 450 0
;
run;
data want;
 set have;
 by id;
 if first.id or last.id then flag=0;
  else flag=1;
run;

[Kurt_Bremser]

Search, and you will find.