topic Re: Removing duplicate dates in SAS Procedures

Removing duplicate dates

sks521 — Fri, 14 Jun 2019 14:29:08 GMT

Hi,

I got a complicated question;

The data I am handling is strangely formatted. Example below;

ID status EventDate Readcode

1 Intervention group 16/02/2016 XaF8d

1 Intervention group 16/02/2016 X78uk

1 Intervention group 16/02/2016 XaLIe

1 Intervention group 14/04/2016 XaFqt

1 Intervention group 14/04/2016 XaF8d

1 Intervention group 14/04/2016 X78uk

1 Intervention group 14/04/2016 4662

1 Intervention group 14/04/2016 4672

2 Control 14/04/2016 4662

2 Control 14/04/2016 4672

2 Control 05/05/2017 X77Wi

2 Control 05/05/2017 XaK8y

Where EventDate represent a visit to primary healthcare and each code represent some sort of investigation carried out on that date for respective ID. I want to create a data set with discrete visit per date for each id as below;

1 Intervention group 16/02/2016 XaF8d

1 Intervention group 14/04/2016 XaFqt

2 Control 14/04/2016 4662

2 Control 05/05/2017 X77Wi

The problem comes where multiple ids have similar EventDate where the system considers all similar dates as duplicates and deletes other ids with similar EventDate. I have tried Proc summary but it discards for example id 2 with similar dates as id 1 (14/04/2016 in this case) which is not what I want.

Can someone help please?

Thanks

Re: Removing duplicate dates

novinosrin — Fri, 14 Jun 2019 14:34:44 GMT

are you after this?


data have;
input ID status & $30. EventDate :ddmmyy10. Readcode $;
format eventdate ddmmyy10.;
cards;
1   Intervention group     16/02/2016   XaF8d
1   Intervention group     16/02/2016   X78uk
1   Intervention group     16/02/2016   XaLIe
1   Intervention group     14/04/2016   XaFqt
1   Intervention group     14/04/2016   XaF8d
1   Intervention group     14/04/2016   X78uk
1   Intervention group     14/04/2016   4662
1   Intervention group     14/04/2016   4672
2   Control                      14/04/2016   4662
2   Control                      14/04/2016   4672
2   Control                       05/05/2017  X77Wi
2   Control                       05/05/2017  XaK8y
;

proc sort data=have out=want nodupkey;
by id eventdate;
run;

Re: Removing duplicate dates

PaigeMiller — Fri, 14 Jun 2019 14:36:17 GMT

proc sort data=have out=want nodupkey;
    by id status eventdate;
run;

Re: Removing duplicate dates

sks521 — Fri, 14 Jun 2019 14:38:15 GMT

Fabulous! it worked absolutely fine.

Really appreciate!