https://communities.sas.com/t5/SAS-Programming/Extracting-the-last-observation/m-p/549684#M152555 <P>Greetings Community</P><P>&nbsp;</P><P>I have the following dataset:</P><TABLE><TBODY><TR><TD>ID</TD><TD>Date_of_Vaccination</TD><TD>Address_Date</TD><TD>address Street</TD><TD>Address City</TD><TD>Address ZIP</TD><TD>Address State</TD></TR><TR><TD>123458A</TD><TD>11FEB2015</TD><TD>02JUN2011</TD><TD>123 Montana St</TD><TD>Blue Whale</TD><TD>25321</TD><TD>MT</TD></TR><TR><TD>123458A</TD><TD>17JUN2017</TD><TD>31JUL2015</TD><TD>345 North Carolina Rd</TD><TD>White Whale</TD><TD>72152</TD><TD>NC</TD></TR><TR><TD>587987Z</TD><TD>27MAR2018</TD><TD>01MAR2017</TD><TD>980 Lee Hwy</TD><TD>Black Whale</TD><TD>98754</TD><TD>TX</TD></TR><TR><TD>587987Z</TD><TD>10JAN2018</TD><TD>05JAN2001</TD><TD>1780 Middle St</TD><TD>Red Whale</TD><TD>12345</TD><TD>NV</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>And I need the latest row from each ID as following:</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>ID</TD><TD>Date_of_Vaccination</TD><TD>Address_Date</TD><TD>address Street</TD><TD>Address City</TD><TD>Address ZIP</TD><TD>Address State</TD></TR><TR><TD>123458A</TD><TD>17JUN2017</TD><TD>31JUL2015</TD><TD>345 North Carolina Rd</TD><TD>White Whale</TD><TD>72152</TD><TD>NC</TD></TR><TR><TD>587987Z</TD><TD>10JAN2018</TD><TD>05JAN2001</TD><TD>1780 Middle St</TD><TD>Red Whale</TD><TD>12345</TD><TD>NV</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Many thanks.</P> Tue, 09 Apr 2019 16:22:42 GMT altijani 2019-04-09T16:22:42Z https://communities.sas.com/t5/SAS-Programming/Extracting-the-last-observation/m-p/549684#M152555 <P>Greetings Community</P><P>&nbsp;</P><P>I have the following dataset:</P><TABLE><TBODY><TR><TD>ID</TD><TD>Date_of_Vaccination</TD><TD>Address_Date</TD><TD>address Street</TD><TD>Address City</TD><TD>Address ZIP</TD><TD>Address State</TD></TR><TR><TD>123458A</TD><TD>11FEB2015</TD><TD>02JUN2011</TD><TD>123 Montana St</TD><TD>Blue Whale</TD><TD>25321</TD><TD>MT</TD></TR><TR><TD>123458A</TD><TD>17JUN2017</TD><TD>31JUL2015</TD><TD>345 North Carolina Rd</TD><TD>White Whale</TD><TD>72152</TD><TD>NC</TD></TR><TR><TD>587987Z</TD><TD>27MAR2018</TD><TD>01MAR2017</TD><TD>980 Lee Hwy</TD><TD>Black Whale</TD><TD>98754</TD><TD>TX</TD></TR><TR><TD>587987Z</TD><TD>10JAN2018</TD><TD>05JAN2001</TD><TD>1780 Middle St</TD><TD>Red Whale</TD><TD>12345</TD><TD>NV</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>And I need the latest row from each ID as following:</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>ID</TD><TD>Date_of_Vaccination</TD><TD>Address_Date</TD><TD>address Street</TD><TD>Address City</TD><TD>Address ZIP</TD><TD>Address State</TD></TR><TR><TD>123458A</TD><TD>17JUN2017</TD><TD>31JUL2015</TD><TD>345 North Carolina Rd</TD><TD>White Whale</TD><TD>72152</TD><TD>NC</TD></TR><TR><TD>587987Z</TD><TD>10JAN2018</TD><TD>05JAN2001</TD><TD>1780 Middle St</TD><TD>Red Whale</TD><TD>12345</TD><TD>NV</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Many thanks.</P> Tue, 09 Apr 2019 16:22:42 GMT https://communities.sas.com/t5/SAS-Programming/Extracting-the-last-observation/m-p/549684#M152555 altijani 2019-04-09T16:22:42Z https://communities.sas.com/t5/SAS-Programming/Extracting-the-last-observation/m-p/549688#M152557 Sort data set by ID and date, as needed, then use LAST. to filter out the last record.<BR /><BR />data want;<BR />set have;<BR />by id;<BR />if last.id;<BR /><BR />run; Tue, 09 Apr 2019 16:26:52 GMT https://communities.sas.com/t5/SAS-Programming/Extracting-the-last-observation/m-p/549688#M152557 Reeza 2019-04-09T16:26:52Z