topic Code to pick the latest emply record based on review date in SAS Programming https://communities.sas.com/t5/SAS-Programming/Code-to-pick-the-latest-emply-record-based-on-review-date/m-p/459522#M116727 <P>Hi Guys,</P><P>&nbsp;</P><P>I have attached belwo sample data with two secnarios..i need help in wiritng a sas code to pick the latest record by comparing the Review date that falls between EFFT_D(Joing date) and EXPY_D(end date).</P><P>&nbsp;</P><P>Any help is much appreciated.</P><P>n first scenario i should pick the belowrecord</P><TABLE><TBODY><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20029828</TD><TD>20012838</TD><TD>930051</TD><TD>CLI</TD><TD>013423</TD><TD>27Oct2016</TD><TD>31Dec2099</TD><TD>MAY2018</TD><TD>OCT2016</TD><TD><P>DEC2099</P><P>&nbsp;</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P><P>in second scenario the below lrecord</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20029828</TD><TD>20012838</TD><TD>930049</TD><TD>CLI</TD><TD>013423</TD><TD>02Mar2015</TD><TD>11Apr2018</TD><TD>MAY2018</TD><TD>MAR2015</TD><TD>APR2018</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;complete data below...</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Review_Date</TD><TD>Name</TD><TD>Reviewmonth</TD><TD>RO</TD><TD>EMPL_I</TD><TD>EMPL_M</TD><TD>EMPL_STUS_C</TD><TD>POSN_I</TD><TD>PARN_POSN_I</TD><TD>JOB_C</TD><TD>JOB_FUNC_C</TD><TD>DEPT_I</TD><TD>EFFT_D</TD><TD>EXPY_D</TD><TD>appmonth</TD><TD>Joinmthyy</TD><TD>Endmthyy</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20012841</TD><TD>20012872</TD><TD>900802</TD><TD>CSL</TD><TD>005513</TD><TD>31Jul2000</TD><TD>09Jun2003</TD><TD>MAY2018</TD><TD>JUL2000</TD><TD>JUN2003</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20012841</TD><TD>20012872</TD><TD>902312</TD><TD>LND</TD><TD>005513</TD><TD>10Jun2003</TD><TD>23Nov2003</TD><TD>MAY2018</TD><TD>JUN2003</TD><TD>NOV2003</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20012841</TD><TD>20012872</TD><TD>901459</TD><TD>IB</TD><TD>005513</TD><TD>24Nov2003</TD><TD>07Jan2004</TD><TD>MAY2018</TD><TD>NOV2003</TD><TD>JAN2004</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20029525</TD><TD>&nbsp;</TD><TD>900661</TD><TD>OTH</TD><TD>012113</TD><TD>08Jan2004</TD><TD>09Jan2005</TD><TD>MAY2018</TD><TD>JAN2004</TD><TD>JAN2005</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20012841</TD><TD>20012872</TD><TD>901459</TD><TD>IB</TD><TD>005513</TD><TD>10Jan2005</TD><TD>07Mar2005</TD><TD>MAY2018</TD><TD>JAN2005</TD><TD>MAR2005</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20012841</TD><TD>20026356</TD><TD>901459</TD><TD>IB</TD><TD>005513</TD><TD>08Mar2005</TD><TD>08Mar2005</TD><TD>MAY2018</TD><TD>MAR2005</TD><TD>MAR2005</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20012841</TD><TD>20012872</TD><TD>901459</TD><TD>IB</TD><TD>005513</TD><TD>09Mar2005</TD><TD>04Aug2005</TD><TD>MAY2018</TD><TD>MAR2005</TD><TD>AUG2005</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20029828</TD><TD>20012847</TD><TD>904956</TD><TD>CSL</TD><TD>005513</TD><TD>05Aug2005</TD><TD>06Nov2005</TD><TD>MAY2018</TD><TD>AUG2005</TD><TD>NOV2005</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20029828</TD><TD>20012847</TD><TD>903755</TD><TD>CSL</TD><TD>005513</TD><TD>07Nov2005</TD><TD>29Dec2005</TD><TD>MAY2018</TD><TD>NOV2005</TD><TD>DEC2005</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20029828</TD><TD>20012838</TD><TD>903755</TD><TD>CSL</TD><TD>005513</TD><TD>30Dec2005</TD><TD>18Jul2006</TD><TD>MAY2018</TD><TD>DEC2005</TD><TD>JUL2006</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20029828</TD><TD>20012847</TD><TD>903755</TD><TD>CSL</TD><TD>013423</TD><TD>19Jul2006</TD><TD>31Oct2006</TD><TD>MAY2018</TD><TD>JUL2006</TD><TD>OCT2006</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20029828</TD><TD>20012838</TD><TD>903755</TD><TD>CSL</TD><TD>013423</TD><TD>01Nov2006</TD><TD>29Apr2007</TD><TD>MAY2018</TD><TD>NOV2006</TD><TD>APR2007</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20029828</TD><TD>20064500</TD><TD>903755</TD><TD>CSL</TD><TD>013423</TD><TD>30Apr2007</TD><TD>01May2007</TD><TD>MAY2018</TD><TD>APR2007</TD><TD>MAY2007</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20029828</TD><TD>20012838</TD><TD>903755</TD><TD>CSL</TD><TD>013423</TD><TD>02May2007</TD><TD>14Sep2008</TD><TD>MAY2018</TD><TD>MAY2007</TD><TD>SEP2008</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20036820</TD><TD>&nbsp;</TD><TD>900661</TD><TD>OTH</TD><TD>012255</TD><TD>15Sep2008</TD><TD>07May2009</TD><TD>MAY2018</TD><TD>SEP2008</TD><TD>MAY2009</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>LWP</TD><TD>20036820</TD><TD>&nbsp;</TD><TD>900661</TD><TD>OTH</TD><TD>012255</TD><TD>08May2009</TD><TD>13Sep2009</TD><TD>MAY2018</TD><TD>MAY2009</TD><TD>SEP2009</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20036821</TD><TD>&nbsp;</TD><TD>900659</TD><TD>OTH</TD><TD>012255</TD><TD>14Sep2009</TD><TD>31Dec2009</TD><TD>MAY2018</TD><TD>SEP2009</TD><TD>DEC2009</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20029828</TD><TD>20012838</TD><TD>903755</TD><TD>CSL</TD><TD>013423</TD><TD>01Jan2010</TD><TD>22Jun2011</TD><TD>MAY2018</TD><TD>JAN2010</TD><TD>JUN2011</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20029828</TD><TD>20012838</TD><TD>930049</TD><TD>CLI</TD><TD>013423</TD><TD>23Jun2011</TD><TD>16Oct2011</TD><TD>MAY2018</TD><TD>JUN2011</TD><TD>OCT2011</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20029828</TD><TD>20012838</TD><TD>930049</TD><TD>CLI</TD><TD>013423</TD><TD>17Oct2011</TD><TD>03Mar2013</TD><TD>MAY2018</TD><TD>OCT2011</TD><TD>MAR2013</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>LWP</TD><TD>20036820</TD><TD>&nbsp;</TD><TD>930527</TD><TD>OTH</TD><TD>012255</TD><TD>04Mar2013</TD><TD>01Mar2015</TD><TD>MAY2018</TD><TD>MAR2013</TD><TD>MAR2015</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20029828</TD><TD>20012838</TD><TD>930049</TD><TD>CLI</TD><TD>013423</TD><TD>02Mar2015</TD><TD>26Oct2016</TD><TD>MAY2018</TD><TD>MAR2015</TD><TD>OCT2016</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20029828</TD><TD>20012838</TD><TD>930051</TD><TD>CLI</TD><TD>013423</TD><TD>27Oct2016</TD><TD>31Dec2099</TD><TD>MAY2018</TD><TD>OCT2016</TD><TD>DEC2099</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Review_Date</TD><TD>Name</TD><TD>Reviewmonth</TD><TD>RO</TD><TD>EMPL_I</TD><TD>EMPL_M</TD><TD>EMPL_STUS_C</TD><TD>POSN_I</TD><TD>PARN_POSN_I</TD><TD>JOB_C</TD><TD>JOB_FUNC_C</TD><TD>DEPT_I</TD><TD>EFFT_D</TD><TD>EXPY_D</TD><TD>appmonth</TD><TD>Joinmthyy</TD><TD>Endmthyy</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20012841</TD><TD>20012872</TD><TD>900802</TD><TD>CSL</TD><TD>005513</TD><TD>31Jul2000</TD><TD>09Jun2003</TD><TD>MAY2018</TD><TD>JUL2000</TD><TD>JUN2003</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20012841</TD><TD>20012872</TD><TD>902312</TD><TD>LND</TD><TD>005513</TD><TD>10Jun2003</TD><TD>23Nov2003</TD><TD>MAY2018</TD><TD>JUN2003</TD><TD>NOV2003</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20012841</TD><TD>20012872</TD><TD>901459</TD><TD>IB</TD><TD>005513</TD><TD>24Nov2003</TD><TD>07Jan2004</TD><TD>MAY2018</TD><TD>NOV2003</TD><TD>JAN2004</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20029525</TD><TD>&nbsp;</TD><TD>900661</TD><TD>OTH</TD><TD>012113</TD><TD>08Jan2004</TD><TD>09Jan2005</TD><TD>MAY2018</TD><TD>JAN2004</TD><TD>JAN2005</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20012841</TD><TD>20012872</TD><TD>901459</TD><TD>IB</TD><TD>005513</TD><TD>10Jan2005</TD><TD>07Mar2005</TD><TD>MAY2018</TD><TD>JAN2005</TD><TD>MAR2005</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20012841</TD><TD>20026356</TD><TD>901459</TD><TD>IB</TD><TD>005513</TD><TD>08Mar2005</TD><TD>08Mar2005</TD><TD>MAY2018</TD><TD>MAR2005</TD><TD>MAR2005</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20012841</TD><TD>20012872</TD><TD>901459</TD><TD>IB</TD><TD>005513</TD><TD>09Mar2005</TD><TD>04Aug2005</TD><TD>MAY2018</TD><TD>MAR2005</TD><TD>AUG2005</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20029828</TD><TD>20012847</TD><TD>904956</TD><TD>CSL</TD><TD>005513</TD><TD>05Aug2005</TD><TD>06Nov2005</TD><TD>MAY2018</TD><TD>AUG2005</TD><TD>NOV2005</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20029828</TD><TD>20012847</TD><TD>903755</TD><TD>CSL</TD><TD>005513</TD><TD>07Nov2005</TD><TD>29Dec2005</TD><TD>MAY2018</TD><TD>NOV2005</TD><TD>DEC2005</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20029828</TD><TD>20012838</TD><TD>903755</TD><TD>CSL</TD><TD>005513</TD><TD>30Dec2005</TD><TD>18Jul2006</TD><TD>MAY2018</TD><TD>DEC2005</TD><TD>JUL2006</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20029828</TD><TD>20012847</TD><TD>903755</TD><TD>CSL</TD><TD>013423</TD><TD>19Jul2006</TD><TD>31Oct2006</TD><TD>MAY2018</TD><TD>JUL2006</TD><TD>OCT2006</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20029828</TD><TD>20012838</TD><TD>903755</TD><TD>CSL</TD><TD>013423</TD><TD>01Nov2006</TD><TD>29Apr2007</TD><TD>MAY2018</TD><TD>NOV2006</TD><TD>APR2007</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20029828</TD><TD>20064500</TD><TD>903755</TD><TD>CSL</TD><TD>013423</TD><TD>30Apr2007</TD><TD>01May2007</TD><TD>MAY2018</TD><TD>APR2007</TD><TD>MAY2007</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20029828</TD><TD>20012838</TD><TD>903755</TD><TD>CSL</TD><TD>013423</TD><TD>02May2007</TD><TD>14Sep2008</TD><TD>MAY2018</TD><TD>MAY2007</TD><TD>SEP2008</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20036820</TD><TD>&nbsp;</TD><TD>900661</TD><TD>OTH</TD><TD>012255</TD><TD>15Sep2008</TD><TD>07May2009</TD><TD>MAY2018</TD><TD>SEP2008</TD><TD>MAY2009</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>LWP</TD><TD>20036820</TD><TD>&nbsp;</TD><TD>900661</TD><TD>OTH</TD><TD>012255</TD><TD>08May2009</TD><TD>13Sep2009</TD><TD>MAY2018</TD><TD>MAY2009</TD><TD>SEP2009</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20036821</TD><TD>&nbsp;</TD><TD>900659</TD><TD>OTH</TD><TD>012255</TD><TD>14Sep2009</TD><TD>31Dec2009</TD><TD>MAY2018</TD><TD>SEP2009</TD><TD>DEC2009</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20029828</TD><TD>20012838</TD><TD>903755</TD><TD>CSL</TD><TD>013423</TD><TD>01Jan2010</TD><TD>22Jun2011</TD><TD>MAY2018</TD><TD>JAN2010</TD><TD>JUN2011</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20029828</TD><TD>20012838</TD><TD>930049</TD><TD>CLI</TD><TD>013423</TD><TD>23Jun2011</TD><TD>16Oct2011</TD><TD>MAY2018</TD><TD>JUN2011</TD><TD>OCT2011</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20029828</TD><TD>20012838</TD><TD>930049</TD><TD>CLI</TD><TD>013423</TD><TD>17Oct2011</TD><TD>03Mar2013</TD><TD>MAY2018</TD><TD>OCT2011</TD><TD>MAR2013</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>LWP</TD><TD>20036820</TD><TD>&nbsp;</TD><TD>930527</TD><TD>OTH</TD><TD>012255</TD><TD>04Mar2013</TD><TD>01Mar2015</TD><TD>MAY2018</TD><TD>MAR2013</TD><TD>MAR2015</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20029828</TD><TD>20012838</TD><TD>930049</TD><TD>CLI</TD><TD>013423</TD><TD>02Mar2015</TD><TD>11Apr2018</TD><TD>MAY2018</TD><TD>MAR2015</TD><TD>APR2018</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20029828</TD><TD>20012838</TD><TD>930051</TD><TD>CLI</TD><TD>013423</TD><TD>12Apr2018</TD><TD>31Dec2099</TD><TD>MAY2018</TD><TD>APR2018</TD><TD>DEC2099</TD></TR></TBODY></TABLE> Thu, 03 May 2018 00:41:48 GMT BaalaRaaji 2018-05-03T00:41:48Z Code to pick the latest emply record based on review date https://communities.sas.com/t5/SAS-Programming/Code-to-pick-the-latest-emply-record-based-on-review-date/m-p/459522#M116727 <P>Hi Guys,</P><P>&nbsp;</P><P>I have attached belwo sample data with two secnarios..i need help in wiritng a sas code to pick the latest record by comparing the Review date that falls between EFFT_D(Joing date) and EXPY_D(end date).</P><P>&nbsp;</P><P>Any help is much appreciated.</P><P>n first scenario i should pick the belowrecord</P><TABLE><TBODY><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20029828</TD><TD>20012838</TD><TD>930051</TD><TD>CLI</TD><TD>013423</TD><TD>27Oct2016</TD><TD>31Dec2099</TD><TD>MAY2018</TD><TD>OCT2016</TD><TD><P>DEC2099</P><P>&nbsp;</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P><P>in second scenario the below lrecord</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20029828</TD><TD>20012838</TD><TD>930049</TD><TD>CLI</TD><TD>013423</TD><TD>02Mar2015</TD><TD>11Apr2018</TD><TD>MAY2018</TD><TD>MAR2015</TD><TD>APR2018</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;complete data below...</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Review_Date</TD><TD>Name</TD><TD>Reviewmonth</TD><TD>RO</TD><TD>EMPL_I</TD><TD>EMPL_M</TD><TD>EMPL_STUS_C</TD><TD>POSN_I</TD><TD>PARN_POSN_I</TD><TD>JOB_C</TD><TD>JOB_FUNC_C</TD><TD>DEPT_I</TD><TD>EFFT_D</TD><TD>EXPY_D</TD><TD>appmonth</TD><TD>Joinmthyy</TD><TD>Endmthyy</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20012841</TD><TD>20012872</TD><TD>900802</TD><TD>CSL</TD><TD>005513</TD><TD>31Jul2000</TD><TD>09Jun2003</TD><TD>MAY2018</TD><TD>JUL2000</TD><TD>JUN2003</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20012841</TD><TD>20012872</TD><TD>902312</TD><TD>LND</TD><TD>005513</TD><TD>10Jun2003</TD><TD>23Nov2003</TD><TD>MAY2018</TD><TD>JUN2003</TD><TD>NOV2003</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20012841</TD><TD>20012872</TD><TD>901459</TD><TD>IB</TD><TD>005513</TD><TD>24Nov2003</TD><TD>07Jan2004</TD><TD>MAY2018</TD><TD>NOV2003</TD><TD>JAN2004</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20029525</TD><TD>&nbsp;</TD><TD>900661</TD><TD>OTH</TD><TD>012113</TD><TD>08Jan2004</TD><TD>09Jan2005</TD><TD>MAY2018</TD><TD>JAN2004</TD><TD>JAN2005</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20012841</TD><TD>20012872</TD><TD>901459</TD><TD>IB</TD><TD>005513</TD><TD>10Jan2005</TD><TD>07Mar2005</TD><TD>MAY2018</TD><TD>JAN2005</TD><TD>MAR2005</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20012841</TD><TD>20026356</TD><TD>901459</TD><TD>IB</TD><TD>005513</TD><TD>08Mar2005</TD><TD>08Mar2005</TD><TD>MAY2018</TD><TD>MAR2005</TD><TD>MAR2005</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20012841</TD><TD>20012872</TD><TD>901459</TD><TD>IB</TD><TD>005513</TD><TD>09Mar2005</TD><TD>04Aug2005</TD><TD>MAY2018</TD><TD>MAR2005</TD><TD>AUG2005</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20029828</TD><TD>20012847</TD><TD>904956</TD><TD>CSL</TD><TD>005513</TD><TD>05Aug2005</TD><TD>06Nov2005</TD><TD>MAY2018</TD><TD>AUG2005</TD><TD>NOV2005</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20029828</TD><TD>20012847</TD><TD>903755</TD><TD>CSL</TD><TD>005513</TD><TD>07Nov2005</TD><TD>29Dec2005</TD><TD>MAY2018</TD><TD>NOV2005</TD><TD>DEC2005</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20029828</TD><TD>20012838</TD><TD>903755</TD><TD>CSL</TD><TD>005513</TD><TD>30Dec2005</TD><TD>18Jul2006</TD><TD>MAY2018</TD><TD>DEC2005</TD><TD>JUL2006</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20029828</TD><TD>20012847</TD><TD>903755</TD><TD>CSL</TD><TD>013423</TD><TD>19Jul2006</TD><TD>31Oct2006</TD><TD>MAY2018</TD><TD>JUL2006</TD><TD>OCT2006</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20029828</TD><TD>20012838</TD><TD>903755</TD><TD>CSL</TD><TD>013423</TD><TD>01Nov2006</TD><TD>29Apr2007</TD><TD>MAY2018</TD><TD>NOV2006</TD><TD>APR2007</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20029828</TD><TD>20064500</TD><TD>903755</TD><TD>CSL</TD><TD>013423</TD><TD>30Apr2007</TD><TD>01May2007</TD><TD>MAY2018</TD><TD>APR2007</TD><TD>MAY2007</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20029828</TD><TD>20012838</TD><TD>903755</TD><TD>CSL</TD><TD>013423</TD><TD>02May2007</TD><TD>14Sep2008</TD><TD>MAY2018</TD><TD>MAY2007</TD><TD>SEP2008</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20036820</TD><TD>&nbsp;</TD><TD>900661</TD><TD>OTH</TD><TD>012255</TD><TD>15Sep2008</TD><TD>07May2009</TD><TD>MAY2018</TD><TD>SEP2008</TD><TD>MAY2009</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>LWP</TD><TD>20036820</TD><TD>&nbsp;</TD><TD>900661</TD><TD>OTH</TD><TD>012255</TD><TD>08May2009</TD><TD>13Sep2009</TD><TD>MAY2018</TD><TD>MAY2009</TD><TD>SEP2009</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20036821</TD><TD>&nbsp;</TD><TD>900659</TD><TD>OTH</TD><TD>012255</TD><TD>14Sep2009</TD><TD>31Dec2009</TD><TD>MAY2018</TD><TD>SEP2009</TD><TD>DEC2009</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20029828</TD><TD>20012838</TD><TD>903755</TD><TD>CSL</TD><TD>013423</TD><TD>01Jan2010</TD><TD>22Jun2011</TD><TD>MAY2018</TD><TD>JAN2010</TD><TD>JUN2011</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20029828</TD><TD>20012838</TD><TD>930049</TD><TD>CLI</TD><TD>013423</TD><TD>23Jun2011</TD><TD>16Oct2011</TD><TD>MAY2018</TD><TD>JUN2011</TD><TD>OCT2011</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20029828</TD><TD>20012838</TD><TD>930049</TD><TD>CLI</TD><TD>013423</TD><TD>17Oct2011</TD><TD>03Mar2013</TD><TD>MAY2018</TD><TD>OCT2011</TD><TD>MAR2013</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>LWP</TD><TD>20036820</TD><TD>&nbsp;</TD><TD>930527</TD><TD>OTH</TD><TD>012255</TD><TD>04Mar2013</TD><TD>01Mar2015</TD><TD>MAY2018</TD><TD>MAR2013</TD><TD>MAR2015</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20029828</TD><TD>20012838</TD><TD>930049</TD><TD>CLI</TD><TD>013423</TD><TD>02Mar2015</TD><TD>26Oct2016</TD><TD>MAY2018</TD><TD>MAR2015</TD><TD>OCT2016</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20029828</TD><TD>20012838</TD><TD>930051</TD><TD>CLI</TD><TD>013423</TD><TD>27Oct2016</TD><TD>31Dec2099</TD><TD>MAY2018</TD><TD>OCT2016</TD><TD>DEC2099</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Review_Date</TD><TD>Name</TD><TD>Reviewmonth</TD><TD>RO</TD><TD>EMPL_I</TD><TD>EMPL_M</TD><TD>EMPL_STUS_C</TD><TD>POSN_I</TD><TD>PARN_POSN_I</TD><TD>JOB_C</TD><TD>JOB_FUNC_C</TD><TD>DEPT_I</TD><TD>EFFT_D</TD><TD>EXPY_D</TD><TD>appmonth</TD><TD>Joinmthyy</TD><TD>Endmthyy</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20012841</TD><TD>20012872</TD><TD>900802</TD><TD>CSL</TD><TD>005513</TD><TD>31Jul2000</TD><TD>09Jun2003</TD><TD>MAY2018</TD><TD>JUL2000</TD><TD>JUN2003</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20012841</TD><TD>20012872</TD><TD>902312</TD><TD>LND</TD><TD>005513</TD><TD>10Jun2003</TD><TD>23Nov2003</TD><TD>MAY2018</TD><TD>JUN2003</TD><TD>NOV2003</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20012841</TD><TD>20012872</TD><TD>901459</TD><TD>IB</TD><TD>005513</TD><TD>24Nov2003</TD><TD>07Jan2004</TD><TD>MAY2018</TD><TD>NOV2003</TD><TD>JAN2004</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20029525</TD><TD>&nbsp;</TD><TD>900661</TD><TD>OTH</TD><TD>012113</TD><TD>08Jan2004</TD><TD>09Jan2005</TD><TD>MAY2018</TD><TD>JAN2004</TD><TD>JAN2005</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20012841</TD><TD>20012872</TD><TD>901459</TD><TD>IB</TD><TD>005513</TD><TD>10Jan2005</TD><TD>07Mar2005</TD><TD>MAY2018</TD><TD>JAN2005</TD><TD>MAR2005</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20012841</TD><TD>20026356</TD><TD>901459</TD><TD>IB</TD><TD>005513</TD><TD>08Mar2005</TD><TD>08Mar2005</TD><TD>MAY2018</TD><TD>MAR2005</TD><TD>MAR2005</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20012841</TD><TD>20012872</TD><TD>901459</TD><TD>IB</TD><TD>005513</TD><TD>09Mar2005</TD><TD>04Aug2005</TD><TD>MAY2018</TD><TD>MAR2005</TD><TD>AUG2005</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20029828</TD><TD>20012847</TD><TD>904956</TD><TD>CSL</TD><TD>005513</TD><TD>05Aug2005</TD><TD>06Nov2005</TD><TD>MAY2018</TD><TD>AUG2005</TD><TD>NOV2005</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20029828</TD><TD>20012847</TD><TD>903755</TD><TD>CSL</TD><TD>005513</TD><TD>07Nov2005</TD><TD>29Dec2005</TD><TD>MAY2018</TD><TD>NOV2005</TD><TD>DEC2005</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20029828</TD><TD>20012838</TD><TD>903755</TD><TD>CSL</TD><TD>005513</TD><TD>30Dec2005</TD><TD>18Jul2006</TD><TD>MAY2018</TD><TD>DEC2005</TD><TD>JUL2006</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20029828</TD><TD>20012847</TD><TD>903755</TD><TD>CSL</TD><TD>013423</TD><TD>19Jul2006</TD><TD>31Oct2006</TD><TD>MAY2018</TD><TD>JUL2006</TD><TD>OCT2006</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20029828</TD><TD>20012838</TD><TD>903755</TD><TD>CSL</TD><TD>013423</TD><TD>01Nov2006</TD><TD>29Apr2007</TD><TD>MAY2018</TD><TD>NOV2006</TD><TD>APR2007</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20029828</TD><TD>20064500</TD><TD>903755</TD><TD>CSL</TD><TD>013423</TD><TD>30Apr2007</TD><TD>01May2007</TD><TD>MAY2018</TD><TD>APR2007</TD><TD>MAY2007</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20029828</TD><TD>20012838</TD><TD>903755</TD><TD>CSL</TD><TD>013423</TD><TD>02May2007</TD><TD>14Sep2008</TD><TD>MAY2018</TD><TD>MAY2007</TD><TD>SEP2008</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20036820</TD><TD>&nbsp;</TD><TD>900661</TD><TD>OTH</TD><TD>012255</TD><TD>15Sep2008</TD><TD>07May2009</TD><TD>MAY2018</TD><TD>SEP2008</TD><TD>MAY2009</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>LWP</TD><TD>20036820</TD><TD>&nbsp;</TD><TD>900661</TD><TD>OTH</TD><TD>012255</TD><TD>08May2009</TD><TD>13Sep2009</TD><TD>MAY2018</TD><TD>MAY2009</TD><TD>SEP2009</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20036821</TD><TD>&nbsp;</TD><TD>900659</TD><TD>OTH</TD><TD>012255</TD><TD>14Sep2009</TD><TD>31Dec2009</TD><TD>MAY2018</TD><TD>SEP2009</TD><TD>DEC2009</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20029828</TD><TD>20012838</TD><TD>903755</TD><TD>CSL</TD><TD>013423</TD><TD>01Jan2010</TD><TD>22Jun2011</TD><TD>MAY2018</TD><TD>JAN2010</TD><TD>JUN2011</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20029828</TD><TD>20012838</TD><TD>930049</TD><TD>CLI</TD><TD>013423</TD><TD>23Jun2011</TD><TD>16Oct2011</TD><TD>MAY2018</TD><TD>JUN2011</TD><TD>OCT2011</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20029828</TD><TD>20012838</TD><TD>930049</TD><TD>CLI</TD><TD>013423</TD><TD>17Oct2011</TD><TD>03Mar2013</TD><TD>MAY2018</TD><TD>OCT2011</TD><TD>MAR2013</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>LWP</TD><TD>20036820</TD><TD>&nbsp;</TD><TD>930527</TD><TD>OTH</TD><TD>012255</TD><TD>04Mar2013</TD><TD>01Mar2015</TD><TD>MAY2018</TD><TD>MAR2013</TD><TD>MAR2015</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20029828</TD><TD>20012838</TD><TD>930049</TD><TD>CLI</TD><TD>013423</TD><TD>02Mar2015</TD><TD>11Apr2018</TD><TD>MAY2018</TD><TD>MAR2015</TD><TD>APR2018</TD></TR><TR><TD>10Apr2018</TD><TD>XXXYYY</TD><TD>APR2018</TD><TD>XXX,YYY</TD><TD>00183256</TD><TD>XXX,YYY</TD><TD>ACT</TD><TD>20029828</TD><TD>20012838</TD><TD>930051</TD><TD>CLI</TD><TD>013423</TD><TD>12Apr2018</TD><TD>31Dec2099</TD><TD>MAY2018</TD><TD>APR2018</TD><TD>DEC2099</TD></TR></TBODY></TABLE> Thu, 03 May 2018 00:41:48 GMT https://communities.sas.com/t5/SAS-Programming/Code-to-pick-the-latest-emply-record-based-on-review-date/m-p/459522#M116727 BaalaRaaji 2018-05-03T00:41:48Z Re: Code to pick the latest emply record based on review date https://communities.sas.com/t5/SAS-Programming/Code-to-pick-the-latest-emply-record-based-on-review-date/m-p/459708#M116790 <P>Next time, trim your data set down to just the essential fields.</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">data first_set; input Review_Date:date9. Name:$6. Reviewmonth:MONYY7. RO:$8. EMPL_I:$8. EMPL_M:$8. EMPL_STUS_C:$4. POSN_I:$9. PARN_POSN_I:$9. JOB_C:$9. JOB_FUNC_C:$7. DEPT_I:$7. EFFT_D:date9. EXPY_D:date9. appmonth:MONYY7. Joinmthyy:MONYY7. Endmthyy:MONYY7. ; format review_date yymmdd10. efft_d yymmdd10. expy_d yymmdd10.; datalines; 10Apr2018 XXXYYY APR2018 XXX,YYY 00183256 XXX,YYY ACT 20012841 20012872 900802 CSL 005513 31Jul2000 09Jun2003 MAY2018 JUL2000 JUN2003 10Apr2018 XXXYYY APR2018 XXX,YYY 00183256 XXX,YYY ACT 20012841 20012872 902312 LND 005513 10Jun2003 23Nov2003 MAY2018 JUN2003 NOV2003 10Apr2018 XXXYYY APR2018 XXX,YYY 00183256 XXX,YYY ACT 20012841 20012872 901459 IB 005513 24Nov2003 07Jan2004 MAY2018 NOV2003 JAN2004 10Apr2018 XXXYYY APR2018 XXX,YYY 00183256 XXX,YYY ACT 20029525 . 900661 OTH 012113 08Jan2004 09Jan2005 MAY2018 JAN2004 JAN2005 10Apr2018 XXXYYY APR2018 XXX,YYY 00183256 XXX,YYY ACT 20012841 20012872 901459 IB 005513 10Jan2005 07Mar2005 MAY2018 JAN2005 MAR2005 10Apr2018 XXXYYY APR2018 XXX,YYY 00183256 XXX,YYY ACT 20012841 20026356 901459 IB 005513 08Mar2005 08Mar2005 MAY2018 MAR2005 MAR2005 10Apr2018 XXXYYY APR2018 XXX,YYY 00183256 XXX,YYY ACT 20012841 20012872 901459 IB 005513 09Mar2005 04Aug2005 MAY2018 MAR2005 AUG2005 10Apr2018 XXXYYY APR2018 XXX,YYY 00183256 XXX,YYY ACT 20029828 20012847 904956 CSL 005513 05Aug2005 06Nov2005 MAY2018 AUG2005 NOV2005 10Apr2018 XXXYYY APR2018 XXX,YYY 00183256 XXX,YYY ACT 20029828 20012847 903755 CSL 005513 07Nov2005 29Dec2005 MAY2018 NOV2005 DEC2005 10Apr2018 XXXYYY APR2018 XXX,YYY 00183256 XXX,YYY ACT 20029828 20012838 903755 CSL 005513 30Dec2005 18Jul2006 MAY2018 DEC2005 JUL2006 10Apr2018 XXXYYY APR2018 XXX,YYY 00183256 XXX,YYY ACT 20029828 20012847 903755 CSL 013423 19Jul2006 31Oct2006 MAY2018 JUL2006 OCT2006 10Apr2018 XXXYYY APR2018 XXX,YYY 00183256 XXX,YYY ACT 20029828 20012838 903755 CSL 013423 01Nov2006 29Apr2007 MAY2018 NOV2006 APR2007 10Apr2018 XXXYYY APR2018 XXX,YYY 00183256 XXX,YYY ACT 20029828 20064500 903755 CSL 013423 30Apr2007 01May2007 MAY2018 APR2007 MAY2007 10Apr2018 XXXYYY APR2018 XXX,YYY 00183256 XXX,YYY ACT 20029828 20012838 903755 CSL 013423 02May2007 14Sep2008 MAY2018 MAY2007 SEP2008 10Apr2018 XXXYYY APR2018 XXX,YYY 00183256 XXX,YYY ACT 20036820 . 900661 OTH 012255 15Sep2008 07May2009 MAY2018 SEP2008 MAY2009 10Apr2018 XXXYYY APR2018 XXX,YYY 00183256 XXX,YYY LWP 20036820 . 900661 OTH 012255 08May2009 13Sep2009 MAY2018 MAY2009 SEP2009 10Apr2018 XXXYYY APR2018 XXX,YYY 00183256 XXX,YYY ACT 20036821 . 900659 OTH 012255 14Sep2009 31Dec2009 MAY2018 SEP2009 DEC2009 10Apr2018 XXXYYY APR2018 XXX,YYY 00183256 XXX,YYY ACT 20029828 20012838 903755 CSL 013423 01Jan2010 22Jun2011 MAY2018 JAN2010 JUN2011 10Apr2018 XXXYYY APR2018 XXX,YYY 00183256 XXX,YYY ACT 20029828 20012838 930049 CLI 013423 23Jun2011 16Oct2011 MAY2018 JUN2011 OCT2011 10Apr2018 XXXYYY APR2018 XXX,YYY 00183256 XXX,YYY ACT 20029828 20012838 930049 CLI 013423 17Oct2011 03Mar2013 MAY2018 OCT2011 MAR2013 10Apr2018 XXXYYY APR2018 XXX,YYY 00183256 XXX,YYY LWP 20036820 . 930527 OTH 012255 04Mar2013 01Mar2015 MAY2018 MAR2013 MAR2015 10Apr2018 XXXYYY APR2018 XXX,YYY 00183256 XXX,YYY ACT 20029828 20012838 930049 CLI 013423 02Mar2015 26Oct2016 MAY2018 MAR2015 OCT2016 10Apr2018 XXXYYY APR2018 XXX,YYY 00183256 XXX,YYY ACT 20029828 20012838 930051 CLI 013423 27Oct2016 31Dec2099 MAY2018 OCT2016 DEC2099 ; run; * we want the record with a review date between efft_d date and expy_d date; proc sql; select * from first_set where review_date between efft_d and expy_d; quit; </CODE></PRE> <P>That gives:</P> <PRE><CODE class=" language-sas">The SAS System 09:52 Thursday, May 3, 2018 1 Review_ EMPL_ PARN_POSN_ Date Name Reviewmonth RO EMPL_I EMPL_M STUS_C POSN_I I JOB_FUNC_ JOB_C C DEPT_I EFFT_D EXPY_D appmonth Joinmthyy Endmthyy 2018-04-10 XXXYYY 21275 XXX,YYY 00183256 XXX,YYY ACT 20029828 20012838 930051 CLI 013423 2016-10-27 2099-12-31 21305 20728 51104 </CODE></PRE> <P>Yuck that is hard to read.&nbsp;</P> <P>&nbsp;</P> <P>Try that.</P> Thu, 03 May 2018 15:18:32 GMT https://communities.sas.com/t5/SAS-Programming/Code-to-pick-the-latest-emply-record-based-on-review-date/m-p/459708#M116790 HB 2018-05-03T15:18:32Z