Hi all, I have a transaction file that contains account #s. Each account # has multiple transactions identified by tran_code for any single day. I am trying to select account #s that follow a sequence of changes on the tran code. for example, by the end of the day..tran_code should = 'cld', however prior to that it should have been either 'op' or 'sub'. This should all happen in one day. Here is an example of what the data looks like: Account# TranDate TranTime TranCode 12342 2Jul17 8:00am sub 12342 2Jul17 9:00am op 12342 2Jul17 10:00am dl 12342 2Jul17 11:00am cld 32132 2Jul17 6:00am sub 32132 2Jul17 11:35am op 32132 2Jul17 12:46am cld I could use a simple Where tran_code in(op.sub,cld) but that wont gaurantee that my results meet the criteria for a singe date as these changes can happen on different dates. Can someone help or at least point to a resource that I can refer to for this coding. Thanks all.
... View more