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