Removing duplicates

[robertrao]

Hi Team,

For the same ID I dont want duplicate DATETIME values by the TYPE??

I tried and it was confusing

Thanks for the help

HAVE

ID      TYPE     DATETIME

101    IN         02MAY12:45

101   OUT     02MAY16:05

101   OUT    02MAY16:05

101  IN        02MAy12:45

101  IN       06MAy12:42

101  IN      06MAy12:42

WANT

ID      TYPE     DATETIME

101    IN         02MAY12:45

101   OUT     02MAY16:05

101  IN         06MAy12:42

[Linlin · Accepted solution]

proc sort data=have;

by id datetime;

data want;

set have;

by id datetime;

if first.datetime;

run;