KSharp. Thanks! Your assumption above is correct. Even though the queuenames are the same, one transaction happened after the worked transaction. The one that happened after the worked transaction happened before the Inbound action so it should be marked as Inbound. The problem I am having now is that for data Queued, the tran_tm is not a SAS time. So datetime=dhms(tran_dt,0,0,tran_tm); does not work. I've tried: datetime=dhms(tran_dt, substr(left(put(tran_tm,best12.)),1,2), substr(left(put(tran_tm,best12.)),3,2), substr(left(put(tran_tm,best12.)),5,2)); But because the tran_tm could be 1, for example, if the tranasction occured on the first second of the day, I'm not sure how to handle it. Do you know how to get a number in this format converted to SAS time?
... View more