This audit procedure is a flexible approach to identifying any type of duplicate records, for example duplicate payments or duplicate invoices. It is named "same, same, same" because often the search criteria will be based on that. For example -

• Same invoice number, amount, invoice date, and vendor.
• Same invoice number, amount, and vendor. 
• Same invoice number and vendor. 
• Same amount and vendor. 
• Same purchase order, vendor, and amount.

Features

• Up to five variable names may be processed at once
• Input file does not need to be pre-sorted
• Ease of parameter specification
• Flexible processing

Benefits

• Identify a variety of types of duplicates
• Improve data integrity by removing duplicate records
• Fast - process 300 - 400 records per second
• Unlimited file size means you aren't restricted from examining large files
• Ability to process "overnight"

Example ScreenShot:

See example scripts and output for duplicate payments.

Analysts interested in Proc SSS may also be interested in Proc CR and Proc Univariate.