Records in dataset are like this:
Code: Select all
|ST|AGENT:CODE|EFF DATE|
========================
IL |A |021 |20160128|
MI |A |002 |20160110|
CT |A |036 |20160208|
CT |A |266 |20160117|
AK |A |723 |20160107|
MD |A |876 |20160114|
CA |A |244 |20160102|
MA |A |499 |20160225|
Code: Select all
//SYSIN DD *
INREC FIELDS=(1,224,225:C'000001')
SORT FIELDS=(150,2,CH,A)
INCLUDE COND=(150,2,CH,NE,C' ',AND,150,2,CH,NE,C'==')
SUM FIELDS=(225,6),FORMAT=ZD
OUTREC FIELDS=(1:150,2,3:C' - ',6:225,6)
Code: Select all
AK - 000032
AL - 000321
AR - 000013
AZ - 000032
CA - 000234
CO - 000128
Can anyone help me out with this please? I think it can be done in a single step instead of writing another step to sort the output again.