title: Flagging Lines Below HHMM Threshold SAS IF/THEN Data Statement
body: <p>I have a dataset where I calculated the number of total hours it took to process a request in hours. A request should be completed in 72 hours, or else if an extension is requested a request should be completed in 408 hours (14 days plus 72 hours).</p>
  <p>I need to flag values with a Y or N depending if they meet these criteria.</p>
  <p>My problem is that it is only recognizing negative HHMM values as below threshold, not a value like 29:15 which would represent 29 hours 15 minutes. This is less than 72 hours and should be marked &quot;Y&quot; indicating it is timely, but it is marking it &quot;N&quot;.</p>
  <p>This is what I tried so far:</p>
  <pre><code>
  data work.tbl_6;
  set work.tbl_6;
  
  if was_a_timeframe_extension_taken_ = &quot;N&quot; and time_to_notification &lt;= 72 then notification_timely=&quot;Y&quot;;
  else if was_a_timeframe_extension_taken_ = &quot;Y&quot; and time_to_notification &lt;= 408 then notification_timely=&quot;Y&quot;;
  else notification_timely=&quot;N&quot;;
  
  run;
  
  </code></pre>
  <p>Can someone advise what could be going wrong here?</p>