Summation of an input field using SORT

[goldyroshan]

My input file has 614 records. I want to sum one field at 3273 rd position (length = 12). It is a S9(10)V9(2)

I tried using the below sort card, but I am not getting the desired output - which should be one row in output file showing me the summation of the above field.
Instead I am getting 614 rows in output file.


SORT FIELDS=(3809,9,CH,A) -> another field having values as Alphabets
SUM FIELDS=(3273,12,ZD) -> desired field to be added

Please provide the sort card.
I even tried using BI instead of ZD, but same result.

[goldyroshan]

I tried the below sort card & it worked -

OPTION COPY
OUTFIL REMOVECC,
TRAILER1=(TOT=(3273,12,ZD,TO=ZD,LENGTH=12))

I did get a trailer record with a value, but I would want to see the value in displayable format so that I can directly export it to xls. Please help with that.

[William Collins]

SUM only gives a sum for value with duplicate key(s), the key(s) being those defined in the SORT statement.. You seem to want a total for a file, so SUM is no good to you for that.

What do you consider non-displayable about the value you received from TRAILER1?

[goldyroshan]

Here is what I used finally to get the desired sum -

OPTION COPY
OUTFIL REMOVECC,
TRAILER1=(TOT=(3273,12,ZD,TO=FS,LENGTH=12))

Thx William for replying to my posts!