Posted: Wed Apr 16, 2014 10:42 am Post subject: Summation of an input field using SORT
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. _________________ Logically yours,
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum