Question

[11427qvolaf]

A research analyst is asked to calculate overall response time, using two times in their SAS dataset: dispatch time (format hh:mm:ss) and hospital arrival time (format hh:mm).  What would be the SAS or SQL code to calculate the response time.

[SASKiwi · Accepted solution]

@11427qvolaf  - Welcome to the SAS Community. Please be aware it is not considered good form to post SAS homework questions without:

• Posting the example data referred to in the question
• Posting evidence of trying to answer the question yourself

[japelin]

First of all, it is recommended that you include appropriate words in the subject.
Also, it is easier to get an answer if you provide sample data, variables, and exact conditions in your question.

Then, to answer your question
Since the formatting seems to be applied to both times, they can actually be subtracted directly as numeric data, as follows.

data want;
  set have;
  response_time=hospital_arrival_time-dispatch_time;
run;