topic Re: How to find difference between datetime in a single column in SAS Programming

How to find difference between datetime in a single column

Siva_Harish — Wed, 07 Jul 2021 16:59:28 GMT

Hi ,

How to get same id presented same topic_id within within (less than) 45 days.

Can anyone help me on this?

ID	EVENT_START_DATE	TOPIC_ID
4	18Sep2019 14:30:00	427EP1905697-01
4	18Dec2019 15:15:00	427EP1905697-01
4	21Feb2020 18:30:00	427EP1905697-01
4	18Sep2019 14:30:00	427ES18PR07337-01
4	18Dec2019 15:15:00	427ES18PR07337-01
4	21Feb2020 18:30:00	427ES18PR07337-01
4	18Sep2019 14:30:00	IMSES18PR03522-01
4	18Dec2019 15:15:00	IMSES18PR03522-01
4	21Feb2020 18:30:00	IMSES18PR03522-01
6	12Sep2019 17:30:00	427EP1905697-01
6	18Sep2019 14:30:00	427EP1905697-01
6	18Dec2019 15:15:00	427EP1905697-01
6	12Sep2019 17:30:00	427ES18PR07337-01
6	18Sep2019 14:30:00	427ES18PR07337-01
6	18Dec2019 15:15:00	427ES18PR07337-01
6	12Sep2019 17:30:00	IMSES18PR03522-01
6	18Sep2019 14:30:00	IMSES18PR03522-01
6	18Dec2019 15:15:00	IMSES18PR03522-01

Re: How to find difference between datetime in a single column

Kurt_Bremser — Wed, 07 Jul 2021 17:17:15 GMT

Apply the same basic technique I showed you here.

Re: How to find difference between datetime in a single column

PaigeMiller — Wed, 07 Jul 2021 20:20:13 GMT

Assuming your EVENT_START_DATE is truly numeric date/time values in SAS, and assuming your data is properly sorted by ID and TOPIC_ID, you can use the DIF Function.

data want;
    set have;
    by id topic_id;
    delta=dif(event_start_date);
    if not first.topic_id and delta<45*86400 then flag='Less than 45 days';
    drop delta;
run;

Re: How to find difference between datetime in a single column

Reeza — Wed, 07 Jul 2021 19:49:33 GMT

Self join - you can join a table with itself.