The COMPARE Procedure Comparison of WORK.QC_DM with SDTM102.DM (Method=EXACT) Data Set Summary Dataset Created Modified NVar NObs WORK.QC_DM 08FEB15:19:35:41 08FEB15:19:35:41 18 60 SDTM102.DM 04FEB15:22:58:04 04FEB15:22:58:04 15 60 Variables Summary Number of Variables in Common: 13. Number of Variables in WORK.QC_DM but not in SDTM102.DM: 5. Number of Variables in SDTM102.DM but not in WORK.QC_DM: 2. Number of Variables with Conflicting Types: 1. Number of Variables with Differing Attributes: 12.
Skip to first unread message
Sumitra
Feb 8, 2015, 7:39:33 PM2/8/15
to anova...@googlegroups.com
The SAS System
Listing of Common Variables with Conflicting Types
Variable Dataset Type Length Label
SUBJID WORK.QC_DM Num 8 Subject Number
SDTM102.DM Char 7 Subject Identifier for the Study
Listing of Common Variables with Differing Attributes
Variable Dataset Type Length Label
STUDYID WORK.QC_DM Char 6
SDTM102.DM Char 15 Study Identifier
DOMAIN WORK.QC_DM Char 2
SDTM102.DM Char 2 Domain Abbreviation
USUBJID WORK.QC_DM Char 19
SDTM102.DM Char 25 Unique Subject Identifier
SITEID WORK.QC_DM Char 8
SDTM102.DM Char 7 Study Site Identifier
BRTHDTC WORK.QC_DM Char 10
SDTM102.DM Char 16 Date/Time of Birth
SEX WORK.QC_DM Char 1
SDTM102.DM Char 2 Sex
ARM WORK.QC_DM Char 19
SDTM102.DM Char 40 Description of Planned Arm
ARMCD WORK.QC_DM Char 7
SDTM102.DM Char 8 Planned Arm Code
AGE WORK.QC_DM Num 8
SDTM102.DM Num 8 Age
AGEU WORK.QC_DM Char 5
SDTM102.DM Char 5 Age Units
RFSTDTC WORK.QC_DM Char 10
SDTM102.DM Char 16 Subject Reference Start Date/Time
RFENDTC WORK.QC_DM Char 10
SDTM102.DM Char 16 Subject Reference End Date/Time
The SAS System
The COMPARE Procedure Comparison of WORK.QC_DM with SDTM102.DM (Method=EXACT) Observation Summary Observation Base Compare First Obs 1 1 First Unequal 1 1 Last Unequal 60 60 Last Obs 60 60 Number of Observations in Common: 60. Total Number of Observations Read from WORK.QC_DM: 60. Total Number of Observations Read from SDTM102.DM: 60. Number of Observations with Some Compared Variables Unequal: 60. The SAS System
The COMPARE Procedure Comparison of WORK.QC_DM with SDTM102.DM (Method=EXACT) Data Set Summary Dataset Created Modified NVar NObs WORK.QC_DM 08FEB15:19:35:41 08FEB15:19:35:41 18 60 SDTM102.DM 04FEB15:22:58:04 04FEB15:22:58:04 15 60 Variables Summary Number of Variables in Common: 13. Number of Variables in WORK.QC_DM but not in SDTM102.DM: 5. Number of Variables in SDTM102.DM but not in WORK.QC_DM: 2. Number of Variables with Conflicting Types: 1. Number of Variables with Differing Attributes: 12.
Listing of Common Variables with Conflicting Types
Variable Dataset Type Length Label
SUBJID WORK.QC_DM Num 8 Subject Number
SDTM102.DM Char 7 Subject Identifier for the Study
Listing of Common Variables with Differing Attributes
Variable Dataset Type Length Label
STUDYID WORK.QC_DM Char 6
SDTM102.DM Char 15 Study Identifier
DOMAIN WORK.QC_DM Char 2
SDTM102.DM Char 2 Domain Abbreviation
USUBJID WORK.QC_DM Char 19
SDTM102.DM Char 25 Unique Subject Identifier
SITEID WORK.QC_DM Char 8
SDTM102.DM Char 7 Study Site Identifier
BRTHDTC WORK.QC_DM Char 10
SDTM102.DM Char 16 Date/Time of Birth
SEX WORK.QC_DM Char 1
SDTM102.DM Char 2 Sex
ARM WORK.QC_DM Char 19
SDTM102.DM Char 40 Description of Planned Arm
ARMCD WORK.QC_DM Char 7
SDTM102.DM Char 8 Planned Arm Code
AGE WORK.QC_DM Num 8
SDTM102.DM Num 8 Age
AGEU WORK.QC_DM Char 5
SDTM102.DM Char 5 Age Units
RFSTDTC WORK.QC_DM Char 10
SDTM102.DM Char 16 Subject Reference Start Date/Time
RFENDTC WORK.QC_DM Char 10
SDTM102.DM Char 16 Subject Reference End Date/Time
The SAS System
The COMPARE Procedure Comparison of WORK.QC_DM with SDTM102.DM (Method=EXACT) Observation Summary Observation Base Compare First Obs 1 1 First Unequal 1 1 Last Unequal 60 60 Last Obs 60 60 Number of Observations in Common: 60. Total Number of Observations Read from WORK.QC_DM: 60. Total Number of Observations Read from SDTM102.DM: 60. Number of Observations with Some Compared Variables Unequal: 60. Number of Observations with All Compared Variables Equal: 0. Values Comparison Summary Number of Variables Compared with All Observations Equal: 7. Number of Variables Compared with Some Observations Unequal: 5. Total Number of Values which Compare Unequal: 235. Maximum Difference: 1. Variables with Unequal Values Variable Type Len1 Len2 Compare Label Ndif MaxDif STUDYID CHAR 6 15 Study Identifier 60 USUBJID CHAR 19 25 Unique Subject Identifier 60 AGE NUM 8 8 Age 2 1.000 RFSTDTC CHAR 10 16 Subject Reference Start Date/Time 57 RFENDTC CHAR 10 16 Subject Reference End Date/Time 56
Number of Observations with All Compared Variables Equal: 0.
Values Comparison Summary
Number of Variables Compared with All Observations Equal: 7.
Number of Variables Compared with Some Observations Unequal: 5.
Total Number of Values which Compare Unequal: 235.
Maximum Difference: 1.
Variables with Unequal Values
Variable Type Len1 Len2 Compare Label Ndif MaxDif
STUDYID CHAR 6 15 Study Identifier 60
USUBJID CHAR 19 25 Unique Subject Identifier 60
AGE NUM 8 8 Age 2 1.000
RFSTDTC CHAR 10 16 Subject Reference Start Date/Time 57
RFENDTC CHAR 10 16 Subject Reference End Date/Time 56
Reply all
Reply to author
Forward
0 new messages