topic Identifying duplicates using a date time variable in New SAS User

Identifying duplicates using a date time variable

Ihsan-Mahdi — Tue, 15 Mar 2022 19:34:04 GMT

Hello,

I have a data set with individuals identified with a unique ID number. There are multiple records for the same individual with different date/time values. I'm trying to identify duplicate records by setting a 12 hour difference as the cutoff between non-duplicate records. Not sure how to calculate the difference between the values related to a single unique ID!

Any suggestions?

Thank you

Re: Identifying duplicates using a date time variable

PaigeMiller — Tue, 15 Mar 2022 19:46:31 GMT

Show us a portion of the data, where you provide the data as SAS data step code which you can type in yourself, or by following these instructions. Show us the desired output from this data.

Re: Identifying duplicates using a date time variable

Ihsan-Mahdi — Tue, 15 Mar 2022 20:03:26 GMT

I'm sorry but my data contains PHIs and I can't share publicly

Re: Identifying duplicates using a date time variable

ballardw — Tue, 15 Mar 2022 20:50:54 GMT

@Ihsan-Mahdi wrote:
I'm sorry but my data contains PHIs and I can't share publicly

Anything for an identifier will do, ABC, PDQ, Moose and Squrrel. So make some up with some datetime values that will be similar to your data. The key bits will the datetime variable(s), the structure of the data and the desired output for a given example.

The INTCK function will return counts of intervals. Hours between two datetime values would be:

Hours = Intck('hour',datetime1, datetime2);

if the datetime2 is before datetime1 you get a negative number of hours.