You can do it with a single data step like this: data return noreturn;
do until (last.name);
set test;
by name notsorted;
if first.name then
Start=Boarding;
end;
end=destination;
drop boarding destination;
rename start=boarding end=destination;
if start=end then
output return;
else
output noreturn;
run;
... View more