newbie
New User
Joined: 05 Nov 2005 Posts: 12
|
|
|
|
Can you please show me how I can use sort to count and sum amount based on specific record types? I want the output to show me the type, record count for the type, and sum amount for the type. Then if possible, show a trailer record with the total count and total sum amount.
Input:
TYPE AMOUNT PIC 9(07)V99
AAA 0530
CCC 0100
BBB 0200
AAA 1050
CCC 0100
BBB 0420
CCC 0310
Output:
TYPE COUNT AMOUNT
AAA 2 15.80
BBB 2 06.20
CCC 3 05.10
TOTAL 7 27.10
Thanks in advance. |
|
Skolusu
Senior Member
Joined: 07 Dec 2007 Posts: 2205 Location: San Jose
|
|
|
|
newbie,
Use the following DFSORT JCL
Code: |
//STEP0100 EXEC PGM=SORT
//SYSOUT DD SYSOUT=*
//SORTIN DD *
AAA 000000530
CCC 000000100
BBB 000000200
AAA 000001050
CCC 000000100
BBB 000000420
CCC 000000310
//SORTOUT DD SYSOUT=*
//SYSIN DD *
SORT FIELDS=(1,3,CH,A)
OUTFIL REMOVECC,NODETAIL,BUILD=(80X),
SECTIONS=(1,3,
TRAILER3=(1,3,5X,COUNT=(M10,LENGTH=8),2X,
TOTAL=(5,9,ZD,EDIT=(IIIIIIIT.TT)))),
TRAILER1=(9:8C'=',X,12C'=',/,
'TOTAL : ',COUNT=(M10,LENGTH=8),X,
TOTAL=(5,9,ZD,EDIT=(IIIIIIIIT.TT)))
//* |
The output is
Code: |
AAA 2 15.80
BBB 2 6.20
CCC 3 5.10
======== ============
TOTAL : 7 27.10
|
|
|