Counting transactions after event

[#1]

Hi community,

I would like to count the numnber of transactions occuring after a specific event for each person.

The data looks like this:

The event of interest is entered as a variable (v_Code). So if i enter 2 as event in v_code, i would like to have a result like this:

Person     Number of Transactions after Code=2 (TAID)

1               3

2               1

Does anybody know how to solve this? I guess set-analysis is not possible. I tried asof-Tables, but cannot create them because of size (3 million transactions in table).

Any help appreciated.

Cheers Andreas.

[#2]

Tried it again and found it working. Thanks so much swuehl. No I'm trying the reponse time for 3 million entries