Reports | Duplicate Records

Duplicate Records
This report identifies sets of records that have identical values on more than one occasion within a subject or between subjects within a study site. This report identifies records based on USUBJID and the following covariates (if available): visit number ( VISITNUM ), location ( xxLOC ), method ( xxMETHOD ), position ( xxPOS ), specimen ( xxSPEC ), and planned time point ( xxTPT ).
Report Results Description
Running Duplicate Records for Nicardipine using default settings generates the Report shown below.
The Report contains a section for each findings domain that contains the variable specified by the Analyze: option on the dialog . Data that are summarized are those test codes that are constant throughout the course of the study. For one example of such a tab, see Vital Signs . Each results section contains a Data Filter .
Action Buttons
Action buttons, provide you with an easy way to drill down into your data. The following action buttons are generated by this report:
Show Subjects : Select subjects and click to open and subset the underlying data table to the selected subjects.
Show Duplicates : Select subjects and click to open and subset the underlying data table to the selected subjects.
General
Click to generate a standardized pdf - or rtf -formatted report containing the plots and charts of selected sections.
Click the Options arrow to reopen the completed report dialog used to generate this output.
Click the gray border to the left of the Options tab to open a dynamic report navigator that lists all of the reports in the review. Refer to Report Navigator for more information.
Methodology
No statistical tests are performed. This report identifies sets of tests with similar values using Unique Subject Identifier; Visit number, BY-values based on xxCAT , xxSCAT , xxLOC , xxMETHOD , xxPOS , xxSPEC , and xxTPT (if selected); and date-time of collection ( xxDTC ) to determine sets of records.
Report Options
Report Option Descriptions
Specific documentation for each of the options can be viewed by clicking on the following links:
General Options
Analyze all tests from all findings domains , Findings Tests , Analyze: , Consider BY variables in the analysis
Ignore duplicate records within subject , Ignore duplicate records when covariates don’t match
Subject Filter 1
Additional Filters
Additional Filter to Include Subjects 2 , Select the population to include in the analysis

1
Subject-specific filters must be created using the Create Subject Filter report prior to your analysis.

2
For more information about how to specify a filter using this option, see The SAS WHERE Expression .