You can use ICETOOL to generate an OCCURS report on the key in a temporary dataset and sort the report on the count field in descending order with a STOPAFT=1 parameter.
-----Original Message----- From: Howard Brazee [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 11:51 AM To: [email protected] Subject: Find the most duplicates Is there a way to use the sort utility (or another tool) to come up with the key with the most duplicates only? I want to search a file to find out which person has the most detail records, and how many detail records that person has. ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
