Nearest Date and the next Nearest Date

Smitha9 — Mon, 29 Aug 2022 21:20:15 GMT

Hi,

I have a dataset A:

ID Car_part DateA Check_Date

1 mirror 01/02/2010 04/16/2020

1 Brake 01/03/2010 04/16/2020

1 mirror 01/23/2014 04/16/2020

2 mirror 12/13/2008 04/15/2018

2 mirror 12/18/2012 04/15/2018

3 mirror 07/07/2010 08/09/2015

3 Car 07/07/2010 08/09/2015

3 mirror 07/29/2010 09/08/2016

I want how many days are in between DateA and CheckDate.

Also I want to select 2 dates which are earliest near Check_Date.

If there duplicates then delete. But if there are duplicates and Car_Part is different. Then I want earliest and second earliest the same with different Car_Part.

Want Dataset:

ID Car_part DateA Check_Date Difference_Days

1 mirror 01/23/2014 04/16/2020

1 Brake 01/03/2010 04/16/2020

2 mirror 12/18/2012 04/15/2018

2 mirror 12/13/2008 04/15/2018

3 mirror 07/07/2010 08/09/2015 same but car_part is mirror

3 Car 07/07/2010 08/09/2015 same but care_part is car

Re: Nearest Date and the next Nearest Date

PaigeMiller — Mon, 29 Aug 2022 21:26:22 GMT

To determine the number of days between DateA and Check_Date, you just subtract these dates (assuming they are numeric).

Since you don't give an example of finding the nearest date and the next nearest date, I request that you change your example, and change your want data set, to illustrate this.

topic Nearest Date and the next Nearest Date in New SAS User

Nearest Date and the next Nearest Date

Re: Nearest Date and the next Nearest Date