topic Re: finding the closest date in a long dataset in New SAS User

finding the closest date in a long dataset

lmyers2 — Sat, 20 Feb 2021 01:42:14 GMT

Hello

I'm trying to keep a row that has a date closest to but after a test result date, Below is sample data. Is it possible to do this while the data is in long form?

Have:

Patient ComorbidityScore Test Result

Patient 1 Date 1 Date X

Date 2 Date X

Date 3 Date X

Patient 2 Date 1 Date Y

Date 2 Date Y

Want:

Patient ComorbidityScore Test Result

Patient 1 Date 3 Date X

Patient 2 Date 1 Date Y

Re: finding the closest date in a long dataset

Shmuel — Sat, 20 Feb 2021 07:34:28 GMT

You are looking for:

where ComorbidityScore > test_result and min(ComorbidityScore - test_result)

group by patient

to be used within sql.

Re: finding the closest date in a long dataset

Kurt_Bremser — Sat, 20 Feb 2021 09:02:07 GMT

Sort by patient and the date, then do

data want;
set have;
by patient;
retain flag;
if first.patient then flag = 1;
if flag and comorbidityscore > testresult
then do;
  output;
  flag = 0;
end;
drop flag;
run;