topic pulling the latest record based on date in SAS Data Management https://communities.sas.com/t5/SAS-Data-Management/pulling-the-latest-record-based-on-date/m-p/154525#M2668 <HTML><HEAD></HEAD><BODY><P>I have a table which has the below contents</P><P></P><P> email_addr&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; date_enrolled</P><P><SPAN> </SPAN><A class="jive-link-email-small" href="mailto:x@gmail.com">x@gmail.com</A><SPAN>&nbsp;&nbsp;&nbsp;&nbsp; 05/10/2008</SPAN><BR /> <A href="mailto:x@gmail.com">x@gmail.com</A>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01/01/2014</P><P> x<A href="mailto:x@gmail.com">@gmail.com</A>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 05/05/2014</P><P></P><P> I need the latest record of 05/05/2014 by leaving the other records.&nbsp; Can i use first function ? Is there any easy way?</P><P></P><P></P><P></P><P>Thanks,</P></BODY></HTML> Mon, 12 May 2014 14:18:24 GMT archana 2014-05-12T14:18:24Z pulling the latest record based on date https://communities.sas.com/t5/SAS-Data-Management/pulling-the-latest-record-based-on-date/m-p/154525#M2668 <HTML><HEAD></HEAD><BODY><P>I have a table which has the below contents</P><P></P><P> email_addr&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; date_enrolled</P><P><SPAN> </SPAN><A class="jive-link-email-small" href="mailto:x@gmail.com">x@gmail.com</A><SPAN>&nbsp;&nbsp;&nbsp;&nbsp; 05/10/2008</SPAN><BR /> <A href="mailto:x@gmail.com">x@gmail.com</A>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01/01/2014</P><P> x<A href="mailto:x@gmail.com">@gmail.com</A>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 05/05/2014</P><P></P><P> I need the latest record of 05/05/2014 by leaving the other records.&nbsp; Can i use first function ? Is there any easy way?</P><P></P><P></P><P></P><P>Thanks,</P></BODY></HTML> Mon, 12 May 2014 14:18:24 GMT https://communities.sas.com/t5/SAS-Data-Management/pulling-the-latest-record-based-on-date/m-p/154525#M2668 archana 2014-05-12T14:18:24Z Re: pulling the latest record based on date https://communities.sas.com/t5/SAS-Data-Management/pulling-the-latest-record-based-on-date/m-p/154526#M2669 <HTML><HEAD></HEAD><BODY><P>Double post, please see other response.</P></BODY></HTML> Mon, 12 May 2014 14:23:13 GMT https://communities.sas.com/t5/SAS-Data-Management/pulling-the-latest-record-based-on-date/m-p/154526#M2669 RW9 2014-05-12T14:23:13Z Re: pulling the latest record based on date https://communities.sas.com/t5/SAS-Data-Management/pulling-the-latest-record-based-on-date/m-p/154527#M2670 <HTML><HEAD></HEAD><BODY><P>Thanks RW9. Here is the other post with replies for reference on this community:</P><P></P><H1><A _jive_internal="true" href="https://communities.sas.com/message/210911#210911">pulling the latest record based on date</A></H1><P></P><P>Anna</P></BODY></HTML> Mon, 12 May 2014 16:49:25 GMT https://communities.sas.com/t5/SAS-Data-Management/pulling-the-latest-record-based-on-date/m-p/154527#M2670 AnnaBrown 2014-05-12T16:49:25Z