SUM and Eliminate records if the same key

abby.qiong.zhang · New User Joined: 07 Jun 2012 Posts: 26 Location: China

Is this can be done by SORT?

My input is like this:

Pandora-Box · Posted: Fri Nov 30, 2012 10:15 am Post subject:

Yes

It can be done using SUM FIELDS

But what you need to do is

Format the input and overlay the numeric data without comma and decimal

Use SUM fields

While writing to outrec reformat

chandan.inst · Posted: Fri Nov 30, 2012 10:16 am Post subject:

Hi,

Check for SUM FIELDS in Sort Manual

Regards,
Chandan

abby.qiong.zhang · New User Joined: 07 Jun 2012 Posts: 26 Location: China

Bill Woodger · DFSORT Moderator Joined: 09 Mar 2011 Posts: 7315

Please note that both your posts have had Code tags added to them to preserve the spacing of your code/data. Do that yourself next time.

Don't you now have a "leading" sign when previously you had a "trailing" one?

Pandora-Box · Posted: Fri Nov 30, 2012 2:14 pm Post subject:

Nice shot :-)

Frankly I didnt think of SFF

Pandora-Box · Posted: Fri Nov 30, 2012 2:43 pm Post subject:

abby.qiong.zhang

Did you test this code??

Did you get the output you wanted ??

abby.qiong.zhang · New User Joined: 07 Jun 2012 Posts: 26 Location: China

sqlcode1 · Active Member Joined: 08 Apr 2010 Posts: 578 Location: USA

abby.qiong.zhang,
As mentioned earlier, you are now getting leading sign instead of trailing sign which is what NOT you requested earlier.

Alternatively you can use below method so that you don't have to OVERLAY and do the conversion. If your input file is already sorted on key then replace SORT FIELDS= statement with OPTION COPY. If you want trailing positive (+) sign as well, change SIGNS=(,,+,-)

Bill Woodger · DFSORT Moderator Joined: 09 Mar 2011 Posts: 7315

abby.qiong.zhang,

Consult the manual for the difference between SUM and the OUTFIL reporting functions and the influence of EQUALS or NOEQUALS on the process, if this requirement is part of a larger one dealing with records of the same key but different information.