Sorry I should have included updated data.  Here is a sample USER JOBNAME TRAN TRANNUM PHAPPLID PHTRAN PHTRANNO USRCPUT_MICROSEC   APP3 CSMI 43856 APP7 QZ81 70322 72   APP5 CSMI 20634 APP7 QZ81 70322 8860   APP7 QZ81 70322 APP3 QZ81 43836 16043 GPDCFC26 APP3 QZ81 43836     0 897   APP3 CSMI 41839 APP5 QZ61 15551 51   APP3 CSMI 41838 APP5 QZ61 15551 64   APP3 CSMI 41837 APP5 QZ61 15551 79   APP5 QZ61 15551 APP3 QZ61 41835 5232 GOTLIS12 APP3 QZ61 41835     0 778   APP5 QZ61 12 APP3 QZ61 1 5232 GOTLIS12 APP3 QZ61 1     0 778   APP5 CSMI 111 APP7 QZ81 110 8860   APP7 QZ81 110 APP3 QZ81 100 16043 ABCDEF APP3 QZ81 100     0 897 ... View more

Thanks that is really close, but the problem is I can't use PHTRAN to group them, that ID appears heaps in data, the grouping needs to be based on TRANNUM, so  43836 is the initial transaction, it starts 70322 which then runs the first 9.  This could be 4-5 layers deep.  How do I handle that and get totals at the highest level? ... View more

Hi everybody thanks for the replies.  Sorry I didn't provide enough detail in the original post, I'm trying to workout the data structure as we have lots of data, I've pull some data out that shows 2 examples. The first example starts with USER=GPDCFC26, all the rows above that are sub-tasks or sub-sub-tasks.  And the second example is USER=GOTLIS12 and the 4 rows above are again the sub and sub-sub tasks. What I want is by user (which is at the task level only) get a couple of bits of information, the average and max total CPU time (USRCPUT_MICROSEC), the average number of sub tasks for each task (so 10 for GPDCFC26 and 4 for GOTLIS12), and a count of the number of time each task has executed (1 for both in this case). START STOP USER JOBNAME TRAN TRANNUM PHAPPLID PHTRAN PHTRANNO USRCPUT_MICROSEC 2:10:30 p.m. 2:10:30 p.m.   APP3 CSMI 43853 APP7 QZ81 70322 76 2:10:30 p.m. 2:10:30 p.m.   APP3 CSMI 43850 APP7 QZ81 70322 64 2:10:30 p.m. 2:10:30 p.m.   APP3 CSMI 43848 APP7 QZ81 70322 64 2:10:30 p.m. 2:10:30 p.m.   APP3 CSMI 43846 APP7 QZ81 70322 74 2:10:30 p.m. 2:10:30 p.m.   APP3 CSMI 43845 APP7 QZ81 70322 68 2:10:30 p.m. 2:10:30 p.m.   APP3 CSMI 43844 APP7 QZ81 70322 71 2:10:30 p.m. 2:10:30 p.m.   APP3 CSMI 43857 APP7 QZ81 70322 65 2:10:30 p.m. 2:10:30 p.m.   APP3 CSMI 43856 APP7 QZ81 70322 72 2:10:30 p.m. 2:10:30 p.m.   APP5 CSMI 20634 APP7 QZ81 70322 8860 2:10:30 p.m. 2:10:30 p.m.   APP7 QZ81 70322 APP3 QZ81 43836 16043 2:10:30 p.m. 2:10:30 p.m. GPDCFC26 APP3 QZ81 43836     0 897 2:10:17 p.m. 2:10:17 p.m.   APP3 CSMI 41839 APP5 QZ61 15551 51 2:10:17 p.m. 2:10:17 p.m.   APP3 CSMI 41838 APP5 QZ61 15551 64 2:10:17 p.m. 2:10:17 p.m.   APP3 CSMI 41837 APP5 QZ61 15551 79 2:10:17 p.m. 2:10:17 p.m.   APP5 QZ61 15551 APP3 QZ61 41835 5232 2:10:17 p.m. 2:10:17 p.m. GOTLIS12 APP3 QZ61 41835     0 778 ... View more