Hello, here is a data step solution: data want(drop=i j statusnew); set aa; by empid notsorted ; retain flag statusnew j; i+1; if statusnew ne status and flag ne 'Y' then flag='Y'; if first.empid then do; flag='N'; j=i; end; statusnew=status; if last.empid then do k=j to i; set aa point=k; output; end; run;
... View more