Extracting the last observation

[altijani]

Greetings Community

I have the following dataset:

ID	Date_of_Vaccination	Address_Date	address Street	Address City	Address ZIP	Address State
123458A	11FEB2015	02JUN2011	123 Montana St	Blue Whale	25321	MT
123458A	17JUN2017	31JUL2015	345 North Carolina Rd	White Whale	72152	NC
587987Z	27MAR2018	01MAR2017	980 Lee Hwy	Black Whale	98754	TX
587987Z	10JAN2018	05JAN2001	1780 Middle St	Red Whale	12345	NV

And I need the latest row from each ID as following:

ID	Date_of_Vaccination	Address_Date	address Street	Address City	Address ZIP	Address State
123458A	17JUN2017	31JUL2015	345 North Carolina Rd	White Whale	72152	NC
587987Z	10JAN2018	05JAN2001	1780 Middle St	Red Whale	12345	NV

Many thanks.

[Reeza · Accepted solution]

Sort data set by ID and date, as needed, then use LAST. to filter out the last record.

data want;
set have;
by id;
if last.id;

run;