Hi,
I have to summarize data as below. Input file is sorted in ascending order on first 5 bytes (employee ID). Could you please let me know, how can we achieve the expected output thru JCL SORT ?
********************************* TOP OF DATA ******
12345,GEORGE,012118,022818,033118,
22222,ALAN ,042018, , ,
33333,ALEX ,050118, ,060118,
55555,JOHN , , ,070118,
******************************** BOTTOM OF DATA ****
SORT FIELDS=COPY
OUTFIL REMOVECC,NODETAIL,
SECTIONS=(1,5,
TRAILER3=(1,13,
MAX=(14,6,ZD,EDIT=(TTTTTT)),C',',
MAX=(21,6,ZD,EDIT=(TTTTTT)),C',',
MAX=(28,6,ZD,EDIT=(TTTTTT)),C','))
END
Code:
********************************* TOP OF DATA ****
12345,GEORGE,012118,022818,033118,
22222,ALAN ,042018,000000,000000,
33333,ALEX ,050118,000000,060118,
55555,JOHN ,000000,000000,070118,
******************************** BOTTOM OF DATA **
Code:
SORT FIELDS=COPY
OUTFIL REMOVECC,NODETAIL,
SECTIONS=(1,5,
TRAILER3=(1,13,
MAX=(14,6,ZD,EDIT=(IIIIII)),C',',
MAX=(21,6,ZD,EDIT=(IIIIII)),C',',
MAX=(28,6,ZD,EDIT=(IIIIII)),C','))
END
Code:
********************************* TOP OF DATA *****
12345,GEORGE, 12118, 22818, 33118,
22222,ALAN , 42018, , ,
33333,ALEX , 50118, , 60118,
55555,JOHN , , , 70118,
******************************** BOTTOM OF DATA ***