IBM Mainframe Forum

Hi
I have an input file with data like below:

My output should contain 16 bytes. There should be no duplicates. If you see there are 3 entries where the first 8 bytes are 00000011,I want an output like below:

As in only the last 3 bytes which are highest in value are displayed. Here,672.



this code gives me the output as below:

It is displaying the lowest number 562.
could someone tell me how to do it? Thanks!

This is not JCL, but *Sort. As you are careful not to let us know which sort, I will start by moving this to the DFSORT forum.

Since you show in your sample that your data is already in sequence, why SORT it?

You've used SORT because you want to use SUM. But SUM is going to use the first record that it encounters as the base.

Instead, use OUTFIL reporting features, REMOVECC, NODETAIL, and SECTIONS with TRAILER3.

Hi,
The data in my input file is not in a sorted order, I only gave a sample. May I use sum if the sort fields are like below?
SORT FIELDS=(1,8,CH,A,9,8,CH,D)

If your data is not in sequence, then please don't show sample data as in-sequence. Remember that for next time

No, because SUM will want to consolidate on all elements of the key. Your data will be in the correct order for SUM processing to work, but it is not going to "SUM" on 1,8, but on 1,16.

Just do the SORT as one key, ascending. Then your data is in sequence, and you follow that with OUTFIL and the reporting features to give you want you want (the last item in the sequence within the SORT key) and you will have what you want.

Thanks for your help