Removing duplicates

robertrao — Fri, 16 Aug 2013 19:22:11 GMT

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 IN 02MAy12:45

101 IN 06MAy12:42

WANT

ID TYPE DATETIME

101 IN 02MAY12:45

101 OUT 02MAY16:05

101 IN 06MAy12:42

Re: Removing duplicates

Linlin — Fri, 16 Aug 2013 19:31:11 GMT

proc sort data=have;

by id datetime;

data want;

set have;

by id datetime;

if first.datetime;

run;