topic Adding minutes to time field and comparing in SAS Programming https://communities.sas.com/t5/SAS-Programming/Adding-minutes-to-time-field-and-comparing/m-p/29078#M5464 <HTML><HEAD></HEAD><BODY><P>You didn't indicate what kind of fields cent_tm10 and coll_tm1 were.&nbsp; If they are datatime fields they are measured in seconds thus you would have to change your comparison to that unit of measurement (i.e., times 60).</P></BODY></HTML> Thu, 13 Oct 2011 14:03:53 GMT art297 2011-10-13T14:03:53Z Adding minutes to time field and comparing https://communities.sas.com/t5/SAS-Programming/Adding-minutes-to-time-field-and-comparing/m-p/29077#M5463 <HTML><HEAD></HEAD><BODY><P>I wanted to know if the CENT_TM10 is greater than (COLL_TM1 + 15 minutes) </P><P></P><P>Data EC02;Set Ec01;</P><P>if cent_tm10 &gt; coll_tm1 + 15 ;</P><P>Run;</P><P></P><P></P><P>I get all the records in EC01 again into EC02..</P><P></P><P>Any help.. </P><P></P><P>Bob</P></BODY></HTML> Thu, 13 Oct 2011 13:59:46 GMT https://communities.sas.com/t5/SAS-Programming/Adding-minutes-to-time-field-and-comparing/m-p/29077#M5463 User123 2011-10-13T13:59:46Z Adding minutes to time field and comparing https://communities.sas.com/t5/SAS-Programming/Adding-minutes-to-time-field-and-comparing/m-p/29078#M5464 <HTML><HEAD></HEAD><BODY><P>You didn't indicate what kind of fields cent_tm10 and coll_tm1 were.&nbsp; If they are datatime fields they are measured in seconds thus you would have to change your comparison to that unit of measurement (i.e., times 60).</P></BODY></HTML> Thu, 13 Oct 2011 14:03:53 GMT https://communities.sas.com/t5/SAS-Programming/Adding-minutes-to-time-field-and-comparing/m-p/29078#M5464 art297 2011-10-13T14:03:53Z Re: Adding minutes to time field and comparing https://communities.sas.com/t5/SAS-Programming/Adding-minutes-to-time-field-and-comparing/m-p/29079#M5465 <HTML><HEAD></HEAD><BODY><P>SAS stores time in seconds. Use 15*60 to get 15 minutes.</P></BODY></HTML> Thu, 13 Oct 2011 14:04:16 GMT https://communities.sas.com/t5/SAS-Programming/Adding-minutes-to-time-field-and-comparing/m-p/29079#M5465 Tom 2011-10-13T14:04:16Z Adding minutes to time field and comparing https://communities.sas.com/t5/SAS-Programming/Adding-minutes-to-time-field-and-comparing/m-p/29080#M5466 <HTML><HEAD></HEAD><BODY><P>time5. is the format that I have on all the time fields.</P><P></P><P>BOB</P></BODY></HTML> Thu, 13 Oct 2011 14:18:53 GMT https://communities.sas.com/t5/SAS-Programming/Adding-minutes-to-time-field-and-comparing/m-p/29080#M5466 User123 2011-10-13T14:18:53Z