MVSFORUMS.com

Fin · Beginner Joined: 19 Jan 2004 Posts: 27 Topics: 8

Hi.
I am eliminating duplicates from a file using SYNCSORT using the statement below.
//SYSIN DD *
SORT FIELDS=(139,9,CH,A)
SUM FIELDS=NONE
/*

Is it possible to find the number of duplicates of each field.
For example, if the input file had the records
AAA
AAA
BBB
BBB
CCC
CCC
CCC

the sorted file would may have the following records:
AAA
BBB
CCC

What I would like to do is find out how to output
2 duplicates of AAA
2 duplicates of BBB
3 duplicates of CCC

Please help!
I have tried
SUM FIELDS=NONE,XSUM
but it does not run, is there a count utility or any other way to achieve this?

kolusu · Posted: Mon Sep 06, 2004 6:21 am Post subject:

Fin,

please search before posting. This topic has been discussed earlier. check the following links.

http://www.mvsforums.com/helpboards/viewtopic.php?t=1733&highlight=count

http://www.mvsforums.com/helpboards/viewtopic.php?t=705&highlight=count

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

Fin · Beginner Joined: 19 Jan 2004 Posts: 27 Topics: 8

Kolusus, thanks for pointing me in the right direction.
Much appreciated.