topic how to find this output in SAS Programming

how to find this output

Chiranjeevi — Thu, 27 Apr 2017 18:55:52 GMT

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

Re: how to find this output

PaigeMiller — Thu, 27 Apr 2017 19:00:02 GMT

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.

Re: how to find this output

thomp7050 — Thu, 27 Apr 2017 19:08:09 GMT

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;

Re: how to find this output

Ksharp — Fri, 28 Apr 2017 13:01:53 GMT


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;

Re: how to find this output

Kurt_Bremser — Wed, 05 Jul 2017 12:29:18 GMT

Search, and you will find.