Hello guys, I want to calcuate and express the time difference between two numeric variables in PROC SQL. For example, start_time is 103027. It means that the start time is 10:30:27 and end_time is 114037. It means that the end time is 11:40:37. Both variables are numeric type and their calculated time differnece is 1 hour 10 minutes 10 seconds. How can I express PROC SQL in this logic? If you have any questions, please leave comment below.
... View more