The COMPARE Procedure
Comparison of SDTM102.SUPPDM with WORK.FINAL_SUPPDM
(Method=EXACT)
Data Set Summary
Dataset Created Modified NVar NObs
SDTM102.SUPPDM 19DEC14:17:49:01 19DEC14:17:49:01 10 66
WORK.FINAL_SUPPDM 09FEB15:18:52:58 09FEB15:18:52:58 10 60
Variables Summary
Number of Variables in Common: 10.
Number of Variables with Differing Attributes: 1.
Skip to first unread message
Sarika
Feb 9, 2015, 6:57:23 PM2/9/15
to anova...@googlegroups.com
The SAS System
Listing of Common Variables with Differing Attributes
Variable Dataset Type Length Label
QEVAL SDTM102.SUPPDM Char 8 Evaluator
WORK.FINAL_SUPPDM Char 20 Evaluator
Observation Summary
Observation Base Compare
First Obs 1 1
First Unequal 1 1
Last Unequal 60 60
Last Match 60 60
Last Obs 66 .
Number of Observations in Common: 60.
Number of Observations in SDTM102.SUPPDM but not in WORK.FINAL_SUPPDM: 6.
Total Number of Observations Read from SDTM102.SUPPDM: 66.
Total Number of Observations Read from WORK.FINAL_SUPPDM: 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: 5.
Number of Variables Compared with Some Observations Unequal: 5.
Number of Variables with Missing Value Differences: 1.
Total Number of Values which Compare Unequal: 287.
The SAS System
The COMPARE Procedure
Comparison of SDTM102.SUPPDM with WORK.FINAL_SUPPDM
(Method=EXACT)
Variables with Unequal Values
Variable Type Len1 Len2 Label Ndif MaxDif MissDif
USUBJID CHAR 25 25 Unique Subject Identifier 59 0
QNAM CHAR 8 8 Qualifier Variable Name 54 0
QLABEL CHAR 40 40 Qualifier Variable Label 54 0
QVAL CHAR 200 200 Data Value 60 0
QEVAL CHAR 8 20 Evaluator 60 60
Value Comparison Results for Variables
__________________________________________________________
|| Unique Subject Identifier
|| Base Value Compare Value
Obs || USUBJID USUBJID
________ || ___________________+ ___________________+
||
2 || UNI101 UNI102
3 || UNI102 UNI103
4 || UNI103 UNI104
5 || UNI104 UNI105
6 || UNI105 UNI106
7 || UNI105 UNI201
8 || UNI106 UNI202
9 || UNI201 UNI203
10 || UNI201 UNI204
11 || UNI202 UNI205
12 || UNI203 UNI206
13 || UNI204 UNI301
14 || UNI205 UNI302
15 || UNI205 UNI303
16 || UNI206 UNI304
17 || UNI301 UNI305
18 || UNI302 UNI306
19 || UNI303 UNI401
20 || UNI304 UNI402
21 || UNI305 UNI403
22 || UNI306 UNI404
23 || UNI401 UNI405
24 || UNI402 UNI406
25 || UNI403 UNI501
26 || UNI404 UNI502
27 || UNI405 UNI503
28 || UNI406 UNI504
29 || UNI501 UNI505
30 || UNI502 UNI506
31 || UNI503 UNI507
32 || UNI504 UNI508
33 || UNI504 UNI509
34 || UNI505 UNI510
The SAS System
The COMPARE Procedure
Comparison of SDTM102.SUPPDM with WORK.FINAL_SUPPDM
(Method=EXACT)
Value Comparison Results for Variables
__________________________________________________________
|| Unique Subject Identifier
|| Base Value Compare Value
Obs || USUBJID USUBJID
________ || ___________________+ ___________________+
||
35 || UNI506 UNI511
36 || UNI507 UNI512
37 || UNI508 UNI601
38 || UNI509 UNI602
39 || UNI510 UNI603
40 || UNI510 UNI604
41 || UNI511 UNI605
42 || UNI512 UNI606
43 || UNI601 UNI607
44 || UNI602 UNI608
45 || UNI603 UNI609
46 || UNI604 UNI610
47 || UNI605 UNI611
48 || UNI606 UNI612
49 || UNI607 UNI701
50 || UNI608 UNI702
51 || UNI609 UNI703
NOTE: The MAXPRINT=50 printing limit has been reached for the variable USUBJID. No more values will be printed for this comparison.
__________________________________________________________
__________________________________________________________
|| Qualifier Variable Name
|| Base Value Compare Value
Obs || QNAM QNAM
________ || ________ ________
||
2 || RANDDTC RACEOTH
3 || RANDDTC RACEOTH
4 || RANDDTC RACEOTH
5 || RANDDTC RACEOTH
7 || RANDDTC RACEOTH
8 || RANDDTC RACEOTH
10 || RANDDTC RACEOTH
11 || RANDDTC RACEOTH
12 || RANDDTC RACEOTH
13 || RANDDTC RACEOTH
15 || RANDDTC RACEOTH
16 || RANDDTC RACEOTH
17 || RANDDTC RACEOTH
18 || RANDDTC RACEOTH
19 || RANDDTC RACEOTH
20 || RANDDTC RACEOTH
21 || RANDDTC RACEOTH
The SAS System
The COMPARE Procedure
Comparison of SDTM102.SUPPDM with WORK.FINAL_SUPPDM
(Method=EXACT)
Value Comparison Results for Variables
__________________________________________________________
|| Qualifier Variable Name
|| Base Value Compare Value
Obs || QNAM QNAM
________ || ________ ________
||
22 || RANDDTC RACEOTH
23 || RANDDTC RACEOTH
24 || RANDDTC RACEOTH
25 || RANDDTC RACEOTH
26 || RANDDTC RACEOTH
27 || RANDDTC RACEOTH
28 || RANDDTC RACEOTH
29 || RANDDTC RACEOTH
30 || RANDDTC RACEOTH
31 || RANDDTC RACEOTH
33 || RANDDTC RACEOTH
34 || RANDDTC RACEOTH
35 || RANDDTC RACEOTH
36 || RANDDTC RACEOTH
37 || RANDDTC RACEOTH
38 || RANDDTC RACEOTH
40 || RANDDTC RACEOTH
41 || RANDDTC RACEOTH
42 || RANDDTC RACEOTH
43 || RANDDTC RACEOTH
44 || RANDDTC RACEOTH
45 || RANDDTC RACEOTH
46 || RANDDTC RACEOTH
47 || RANDDTC RACEOTH
48 || RANDDTC RACEOTH
49 || RANDDTC RACEOTH
50 || RANDDTC RACEOTH
51 || RANDDTC RACEOTH
52 || RANDDTC RACEOTH
53 || RANDDTC RACEOTH
54 || RANDDTC RACEOTH
55 || RANDDTC RACEOTH
56 || RANDDTC RACEOTH
NOTE: The MAXPRINT=50 printing limit has been reached for the variable QNAM. No more values will be printed for this comparison.
__________________________________________________________
The SAS System
The COMPARE Procedure
Comparison of SDTM102.SUPPDM with WORK.FINAL_SUPPDM
(Method=EXACT)
Value Comparison Results for Variables
__________________________________________________________
|| Qualifier Variable Label
|| Base Value Compare Value
Obs || QLABEL QLABEL
________ || ___________________+ ___________________+
||
2 || Randomization Date Race, Other
3 || Randomization Date Race, Other
4 || Randomization Date Race, Other
5 || Randomization Date Race, Other
7 || Randomization Date Race, Other
8 || Randomization Date Race, Other
10 || Randomization Date Race, Other
11 || Randomization Date Race, Other
12 || Randomization Date Race, Other
13 || Randomization Date Race, Other
15 || Randomization Date Race, Other
16 || Randomization Date Race, Other
17 || Randomization Date Race, Other
18 || Randomization Date Race, Other
19 || Randomization Date Race, Other
20 || Randomization Date Race, Other
21 || Randomization Date Race, Other
22 || Randomization Date Race, Other
23 || Randomization Date Race, Other
24 || Randomization Date Race, Other
25 || Randomization Date Race, Other
26 || Randomization Date Race, Other
27 || Randomization Date Race, Other
28 || Randomization Date Race, Other
29 || Randomization Date Race, Other
30 || Randomization Date Race, Other
31 || Randomization Date Race, Other
33 || Randomization Date Race, Other
34 || Randomization Date Race, Other
35 || Randomization Date Race, Other
36 || Randomization Date Race, Other
37 || Randomization Date Race, Other
38 || Randomization Date Race, Other
40 || Randomization Date Race, Other
41 || Randomization Date Race, Other
42 || Randomization Date Race, Other
43 || Randomization Date Race, Other
44 || Randomization Date Race, Other
45 || Randomization Date Race, Other
46 || Randomization Date Race, Other
47 || Randomization Date Race, Other
48 || Randomization Date Race, Other
49 || Randomization Date Race, Other
50 || Randomization Date Race, Other
51 || Randomization Date Race, Other
The SAS System
The COMPARE Procedure
Comparison of SDTM102.SUPPDM with WORK.FINAL_SUPPDM
(Method=EXACT)
Value Comparison Results for Variables
__________________________________________________________
|| Qualifier Variable Label
|| Base Value Compare Value
Obs || QLABEL QLABEL
________ || ___________________+ ___________________+
||
52 || Randomization Date Race, Other
53 || Randomization Date Race, Other
54 || Randomization Date Race, Other
55 || Randomization Date Race, Other
56 || Randomization Date Race, Other
NOTE: The MAXPRINT=50 printing limit has been reached for the variable QLABEL. No more values will be printed for this comparison.
__________________________________________________________
__________________________________________________________
|| Data Value
|| Base Value Compare Value
Obs || QVAL QVAL
________ || ___________________+ ___________________+
||
1 || BRAZILIAN .
2 || 2010-04-02 .
3 || 2010-02-13 .
4 || 2010-05-16 .
5 || 2010-01-02 .
6 || ABORIGINE .
7 || 2010-04-20 .
8 || 2010-04-01 .
9 || LIBYAN .
10 || 2010-06-11 .
11 || 2010-02-23 .
12 || 2010-06-10 .
13 || 2010-02-03 .
14 || HMONG .
15 || 2010-04-13 .
16 || 2010-07-01 .
17 || 2010-02-20 .
18 || 2010-05-12 .
19 || 2010-02-19 .
20 || 2010-05-19 .
21 || 2010-06-10 .
22 || 2010-05-23 .
23 || 2010-06-13 .
24 || 2010-01-02 .
25 || 2010-03-03 .
26 || 2010-04-24 .
27 || 2010-03-01 .
28 || 2010-06-12 .
29 || 2010-02-23 .
The SAS System
The COMPARE Procedure
Comparison of SDTM102.SUPPDM with WORK.FINAL_SUPPDM
(Method=EXACT)
Value Comparison Results for Variables
__________________________________________________________
|| Data Value
|| Base Value Compare Value
Obs || QVAL QVAL
________ || ___________________+ ___________________+
||
30 || 2010-05-28 .
31 || 2010-01-21 .
32 || JAPANESE .
33 || 2010-06-19 .
34 || 2010-03-13 .
35 || 2010-01-20 .
36 || 2010-04-06 .
37 || 2010-02-04 .
38 || 2010-05-16 .
39 || HMONG .
40 || 2010-01-12 .
41 || 2010-04-10 .
42 || 2010-04-03 .
43 || 2010-06-04 .
44 || 2010-02-28 .
45 || 2010-01-12 .
46 || 2010-03-13 .
47 || 2010-04-23 .
48 || 2010-02-22 .
49 || 2010-06-10 .
50 || 2010-02-20 .
NOTE: The MAXPRINT=50 printing limit has been reached for the variable QVAL. No more values will be printed for this comparison.
__________________________________________________________
__________________________________________________________
|| Evaluator
|| Base Value Compare Value
Obs || QEVAL QEVAL
________ || ________ ____________________
||
1 || Investigator
2 || Investigator
3 || Investigator
4 || Investigator
5 || Investigator
6 || Investigator
7 || Investigator
8 || Investigator
9 || Investigator
10 || Investigator
11 || Investigator
12 || Investigator
13 || Investigator
The SAS System
The COMPARE Procedure
Comparison of SDTM102.SUPPDM with WORK.FINAL_SUPPDM
(Method=EXACT)
Value Comparison Results for Variables
__________________________________________________________
|| Evaluator
|| Base Value Compare Value
Obs || QEVAL QEVAL
________ || ________ ____________________
||
14 || Investigator
15 || Investigator
16 || Investigator
17 || Investigator
18 || Investigator
19 || Investigator
20 || Investigator
21 || Investigator
22 || Investigator
23 || Investigator
24 || Investigator
25 || Investigator
26 || Investigator
27 || Investigator
28 || Investigator
29 || Investigator
30 || Investigator
31 || Investigator
32 || Investigator
33 || Investigator
34 || Investigator
35 || Investigator
36 || Investigator
37 || Investigator
38 || Investigator
39 || Investigator
40 || Investigator
41 || Investigator
42 || Investigator
43 || Investigator
44 || Investigator
45 || Investigator
46 || Investigator
47 || Investigator
48 || Investigator
49 || Investigator
50 || Investigator
NOTE: The MAXPRINT=50 printing limit has been reached for the variable QEVAL. No more values will be printed for this comparison.
__________________________________________________________ Reply all
Reply to author
Forward
0 new messages