Comparing a row in a dataset with the next row

[Astounding]

SAS actually supplies simple but powerful tools that let you accomplish this.  Consider:

data want;

set have;

by Employee_ID notsorted;

length newvar $ 5;

if last.Employee_ID=1 then newvar='True';

else newvar='False';

run;

The BY statement in a DATA step is "must-have" knowledge.