topic Re: how to find latest time point from same day in SAS Programming https://communities.sas.com/t5/SAS-Programming/how-to-find-latest-time-point-from-same-day/m-p/137806#M295986 <HTML><HEAD></HEAD><BODY><P>Here is a possible SQL solution:</P><P></P><P>PROC SQL;</P><P>&nbsp; CREATE TABLE WANT AS</P><P>&nbsp; SELECT * FROM HAVE</P><P>&nbsp;&nbsp; GROUP BY DATE</P><P>&nbsp;&nbsp; HAVING TIME=MAX(TIME)</P><P>;</P><P>QUIT;</P><P></P><P>Haikuo </P></BODY></HTML> Fri, 05 Dec 2014 14:21:45 GMT Haikuo 2014-12-05T14:21:45Z how to find latest time point from same day https://communities.sas.com/t5/SAS-Programming/how-to-find-latest-time-point-from-same-day/m-p/137805#M295985 <HTML><HEAD></HEAD><BODY><P>Hi _ALL_</P><P></P><P>This is vicky i am having difficulty in finding latest TIME point from same DATE from below data&nbsp; , some one&nbsp; help me.</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 203px;"><TBODY><TR><TD class="xl66" height="20" width="75">DATE</TD><TD width="64">TIME</TD><TD class="xl67" width="64">DEPTH</TD></TR><TR><TD align="right" class="xl66" height="20">10/7/2013</TD><TD align="right" class="xl65">10:25:41</TD><TD align="right">4781.35</TD></TR><TR><TD align="right" class="xl66" height="20">10/9/2013</TD><TD align="right" class="xl65">16:45:29</TD><TD align="right">0</TD></TR><TR><TD align="right" class="xl66" height="20">10/9/2013</TD><TD align="right" class="xl65">17:28:31</TD><TD align="right">0</TD></TR><TR><TD align="right" class="xl66" height="20">10/13/2013</TD><TD align="right" class="xl65">8:54:22</TD><TD align="right">75.18197</TD></TR><TR><TD align="right" class="xl66" height="20">10/13/2013</TD><TD align="right" class="xl65">14:03:27</TD><TD align="right">87.27948</TD></TR><TR><TD align="right" class="xl66" height="20">10/13/2013</TD><TD align="right" class="xl65">20:46:52</TD><TD align="right">115.8728</TD></TR><TR><TD align="right" class="xl66" height="20">10/14/2013</TD><TD align="right" class="xl65">3:18:32</TD><TD align="right">135.7762</TD></TR><TR><TD align="right" class="xl66" height="20">10/14/2013</TD><TD align="right" class="xl65">7:38:21</TD><TD align="right">153.6802</TD></TR><TR><TD align="right" class="xl66" height="20">10/14/2013</TD><TD align="right" class="xl65">14:44:03</TD><TD align="right">181.4292</TD></TR><TR><TD align="right" class="xl66" height="20">10/14/2013</TD><TD align="right" class="xl65">18:57:05</TD><TD align="right">209.2909</TD></TR><TR><TD align="right" class="xl66" height="20">10/15/2013</TD><TD align="right" class="xl65">1:13:23</TD><TD align="right">237.2716</TD></TR><TR><TD align="right" class="xl66" height="20">10/15/2013</TD><TD align="right" class="xl65">5:26:44</TD><TD align="right">265.3894</TD></TR><TR><TD align="right" class="xl66" height="20">10/15/2013</TD><TD align="right" class="xl65">7:57:18</TD><TD align="right">274.509</TD></TR><TR><TD align="right" class="xl66" height="20">10/15/2013</TD><TD align="right" class="xl65">12:29:55</TD><TD align="right">303.2821</TD></TR><TR><TD align="right" class="xl66" height="20">10/15/2013</TD><TD align="right" class="xl65">16:57:01</TD><TD align="right">331.976</TD></TR><TR><TD align="right" class="xl66" height="20">10/14/2013</TD><TD align="right" class="xl65">20:02:00</TD><TD align="right">109.1032</TD></TR><TR><TD align="right" class="xl66" height="20">10/16/2013</TD><TD align="right" class="xl65">5:17:51</TD><TD align="right">385.9804</TD></TR><TR><TD align="right" class="xl66" height="20">10/16/2013</TD><TD align="right" class="xl65">5:58:19</TD><TD align="right">397.7579</TD></TR><TR><TD align="right" class="xl66" height="20">10/16/2013</TD><TD align="right" class="xl65">2:10:00</TD><TD align="right">360.8314</TD></TR><TR><TD align="right" class="xl66" height="20">10/26/2013</TD><TD align="right" class="xl65">16:42:01</TD><TD align="right">390.7048</TD></TR><TR><TD align="right" class="xl66" height="20">10/26/2013</TD><TD align="right" class="xl65">21:57:56</TD><TD align="right">419.0634</TD></TR><TR><TD align="right" class="xl66" height="20">10/27/2013</TD><TD align="right" class="xl65">2:21:01</TD><TD align="right">447.8823</TD></TR><TR><TD align="right" class="xl66" height="20">10/27/2013</TD><TD align="right" class="xl65">7:38:20</TD><TD align="right">476.3902</TD></TR><TR><TD align="right" class="xl66" height="20">10/27/2013</TD><TD align="right" class="xl65">12:48:38</TD><TD align="right">504.8128</TD></TR><TR><TD align="right" class="xl66" height="20">10/27/2013</TD><TD align="right" class="xl65">17:31:18</TD><TD align="right">532.0619</TD></TR><TR><TD align="right" class="xl66" height="20">10/27/2013</TD><TD align="right" class="xl65">22:11:26</TD><TD align="right">560.8838</TD></TR><TR><TD align="right" class="xl66" height="20">10/28/2013</TD><TD align="right" class="xl65">3:59:01</TD><TD align="right">588.7486</TD></TR><TR><TD align="right" class="xl66" height="20">10/28/2013</TD><TD align="right" class="xl65">10:34:02</TD><TD align="right">616.647</TD></TR><TR><TD align="right" class="xl66" height="20">10/28/2013</TD><TD align="right" class="xl65">18:17:32</TD><TD align="right">643.2316</TD></TR></TBODY></TABLE></BODY></HTML> Fri, 05 Dec 2014 14:08:57 GMT https://communities.sas.com/t5/SAS-Programming/how-to-find-latest-time-point-from-same-day/m-p/137805#M295985 vickram 2014-12-05T14:08:57Z Re: how to find latest time point from same day https://communities.sas.com/t5/SAS-Programming/how-to-find-latest-time-point-from-same-day/m-p/137806#M295986 <HTML><HEAD></HEAD><BODY><P>Here is a possible SQL solution:</P><P></P><P>PROC SQL;</P><P>&nbsp; CREATE TABLE WANT AS</P><P>&nbsp; SELECT * FROM HAVE</P><P>&nbsp;&nbsp; GROUP BY DATE</P><P>&nbsp;&nbsp; HAVING TIME=MAX(TIME)</P><P>;</P><P>QUIT;</P><P></P><P>Haikuo </P></BODY></HTML> Fri, 05 Dec 2014 14:21:45 GMT https://communities.sas.com/t5/SAS-Programming/how-to-find-latest-time-point-from-same-day/m-p/137806#M295986 Haikuo 2014-12-05T14:21:45Z Re: how to find latest time point from same day https://communities.sas.com/t5/SAS-Programming/how-to-find-latest-time-point-from-same-day/m-p/137807#M295987 <HTML><HEAD></HEAD><BODY><P>HI <SPAN style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: #ffffff;">Haikuo</SPAN></P><P><SPAN style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: #ffffff;">THANKS FOR YOUR REPLY ITS WORKING. </SPAN></P></BODY></HTML> Fri, 05 Dec 2014 14:35:19 GMT https://communities.sas.com/t5/SAS-Programming/how-to-find-latest-time-point-from-same-day/m-p/137807#M295987 vickram 2014-12-05T14:35:19Z