The COMPARE Procedure Comparison of SDTM102.QC_DM with SDTM102.DM (Method=EXACT) Data Set Summary Dataset Created Modified NVar NObs SDTM102.QC_DM 28JAN15:18:53:15 28JAN15:18:53:15 15 60 SDTM102.DM 19DEC14:17:49:01 19DEC14:17:49:01 15 60 Variables Summary Number of Variables in Common: 14. Number of Variables in SDTM102.QC_DM but not in SDTM102.DM: 1. Number of Variables in SDTM102.DM but not in SDTM102.QC_DM: 1. Number of Variables with Differing Attributes: 14.
Skip to first unread message
Vijaya Kottapalli
Jan 28, 2015, 6:55:17 PM1/28/15
to anova...@googlegroups.com
The SAS System
Listing of Common Variables with Differing Attributes
Variable Dataset Type Length Format Label
STUDYID SDTM102.QC_DM Char 6
SDTM102.DM Char 15 Study Identifier
DOMAIN SDTM102.QC_DM Char 2
SDTM102.DM Char 2 Domain Abbreviation
USUBJID SDTM102.QC_DM Char 6
SDTM102.DM Char 25 Unique Subject Identifier
SUBJID SDTM102.QC_DM Char 3
SDTM102.DM Char 7 Subject Identifier for the Study
RFSTDTC SDTM102.QC_DM Char 10
SDTM102.DM Char 16 Subject Reference Start Date/Time
RFENDTC SDTM102.QC_DM Char 10
SDTM102.DM Char 16 Subject Reference End Date/Time
BRTHDTC SDTM102.QC_DM Char 10
SDTM102.DM Char 16 Date/Time of Birth
SITEID SDTM102.QC_DM Char 5
SDTM102.DM Char 7 Study Site Identifier
AGE SDTM102.QC_DM Num 8
SDTM102.DM Num 8 Age
AGEU SDTM102.QC_DM Char 5
SDTM102.DM Char 5 Age Units
SEX SDTM102.QC_DM Char 1 $GEND.
SDTM102.DM Char 2 Sex
ARMCD SDTM102.QC_DM Char 1
SDTM102.DM Char 8 Planned Arm Code
ARM SDTM102.QC_DM Char 1
SDTM102.DM Char 40 Description of Planned Arm
COUNTRY SDTM102.QC_DM Char 3
SDTM102.DM Char 3 Country
The SAS System
The COMPARE Procedure Comparison of SDTM102.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 SDTM102.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: 11. Number of Variables Compared with Some Observations Unequal: 3. Total Number of Values which Compare Unequal: 180. Maximum Difference: 0. Variables with Unequal Values Variable Type Len1 Len2 Compare Label Ndif MaxDif SEX CHAR 1 2 Sex 60 ARMCD CHAR 1 8 Planned Arm Code 60 ARM CHAR 1 40 Description of Planned Arm 60
Value Comparison Results for Variables
__________________________________________________________
|| Sex
|| Base Value Compare Value
Obs || SEX SEX
________ || _ __
||
1 || 1 M
2 || 2 F
3 || 1 M
4 || 2 F
5 || 1 M
6 || 2 F
7 || 1 M
8 || 2 F
9 || 1 M
10 || 2 F
The SAS System
The COMPARE Procedure Comparison of SDTM102.QC_DM with SDTM102.DM (Method=EXACT) Value Comparison Results for Variables __________________________________________________________ || Sex || Base Value Compare Value Obs || SEX SEX ________ || _ __ || 11 || 1 M 12 || 2 F 13 || 1 M 14 || 1 M 15 || 1 M 16 || 1 M 17 || 1 M 18 || 1 M 19 || 2 F 20 || 2 F 21 || 1 M 22 || 1 M 23 || 2 F 24 || 1 M 25 || 1 M 26 || 2 F 27 || 1 M 28 || 1 M 29 || 1 M 30 || 1 M 31 || 1 M 32 || 2 F 33 || 1 M 34 || 1 M 35 || 2 F 36 || 1 M 37 || 1 M 38 || 2 F 39 || 2 F 40 || 1 M 41 || 2 F 42 || 1 M 43 || 1 M 44 || 2 F 45 || 2 F 46 || 1 M 47 || 2 F 48 || 1 M 49 || 1 M 50 || 1 M NOTE: The MAXPRINT=50 printing limit has been reached for the variable SEX. No more values will be printed for this comparison. __________________________________________________________
The SAS System
The COMPARE Procedure Comparison of SDTM102.QC_DM with SDTM102.DM (Method=EXACT) Value Comparison Results for Variables __________________________________________________________ || Planned Arm Code || Base Value Compare Value Obs || ARMCD ARMCD ________ || _ ________ || 1 || 0 PLACEBO 2 || 1 ALG123 3 || 1 ALG123 4 || 0 PLACEBO 5 || 1 ALG123 6 || 0 PLACEBO 7 || 1 ALG123 8 || 0 PLACEBO 9 || 1 ALG123 10 || 0 PLACEBO 11 || 1 ALG123 12 || 1 ALG123 13 || 0 PLACEBO 14 || 0 PLACEBO 15 || 1 ALG123 16 || 0 PLACEBO 17 || 1 ALG123 18 || 0 PLACEBO 19 || 1 ALG123 20 || 0 PLACEBO 21 || 1 ALG123 22 || 1 ALG123 23 || 0 PLACEBO 24 || 1 ALG123 25 || 0 PLACEBO 26 || 1 ALG123 27 || 1 ALG123 28 || 0 PLACEBO 29 || 1 ALG123 30 || 0 PLACEBO 31 || 1 ALG123 32 || 0 PLACEBO 33 || 0 PLACEBO 34 || 0 PLACEBO 35 || 1 ALG123 36 || 1 ALG123 37 || 0 PLACEBO 38 || 0 PLACEBO 39 || 1 ALG123 40 || 0 PLACEBO 41 || 1 ALG123 42 || 0 PLACEBO 43 || 1 ALG123 44 || 0 PLACEBO 45 || 1 ALG123
The SAS System
The COMPARE Procedure Comparison of SDTM102.QC_DM with SDTM102.DM (Method=EXACT) Value Comparison Results for Variables __________________________________________________________ || Planned Arm Code || Base Value Compare Value Obs || ARMCD ARMCD ________ || _ ________ || 46 || 0 PLACEBO 47 || 1 ALG123 48 || 1 ALG123 49 || 1 ALG123 50 || 0 PLACEBO NOTE: The MAXPRINT=50 printing limit has been reached for the variable ARMCD. No more values will be printed for this comparison. __________________________________________________________ __________________________________________________________ || Description of Planned Arm || Base Value Compare Value Obs || ARM ARM ________ || _ ___________________+ || 1 || 0 Placebo 2 || 1 Analgezia HCL 30 mg 3 || 1 Analgezia HCL 30 mg 4 || 0 Placebo 5 || 1 Analgezia HCL 30 mg 6 || 0 Placebo 7 || 1 Analgezia HCL 30 mg 8 || 0 Placebo 9 || 1 Analgezia HCL 30 mg 10 || 0 Placebo 11 || 1 Analgezia HCL 30 mg 12 || 1 Analgezia HCL 30 mg 13 || 0 Placebo 14 || 0 Placebo 15 || 1 Analgezia HCL 30 mg 16 || 0 Placebo 17 || 1 Analgezia HCL 30 mg 18 || 0 Placebo 19 || 1 Analgezia HCL 30 mg 20 || 0 Placebo 21 || 1 Analgezia HCL 30 mg 22 || 1 Analgezia HCL 30 mg 23 || 0 Placebo 24 || 1 Analgezia HCL 30 mg 25 || 0 Placebo 26 || 1 Analgezia HCL 30 mg 27 || 1 Analgezia HCL 30 mg 28 || 0 Placebo 29 || 1 Analgezia HCL 30 mg
The SAS System
The COMPARE Procedure Comparison of SDTM102.QC_DM with SDTM102.DM (Method=EXACT) Value Comparison Results for Variables __________________________________________________________ || Description of Planned Arm || Base Value Compare Value Obs || ARM ARM ________ || _ ___________________+ || 30 || 0 Placebo 31 || 1 Analgezia HCL 30 mg 32 || 0 Placebo 33 || 0 Placebo 34 || 0 Placebo 35 || 1 Analgezia HCL 30 mg 36 || 1 Analgezia HCL 30 mg 37 || 0 Placebo 38 || 0 Placebo 39 || 1 Analgezia HCL 30 mg 40 || 0 Placebo 41 || 1 Analgezia HCL 30 mg 42 || 0 Placebo 43 || 1 Analgezia HCL 30 mg 44 || 0 Placebo 45 || 1 Analgezia HCL 30 mg 46 || 0 Placebo 47 || 1 Analgezia HCL 30 mg 48 || 1 Analgezia HCL 30 mg 49 || 1 Analgezia HCL 30 mg 50 || 0 Placebo NOTE: The MAXPRINT=50 printing limit has been reached for the variable ARM. No more values will be printed for this comparison. __________________________________________________________
Reply all
Reply to author
Forward
0 new messages