Sample 25344: Comparison of two data sets using PROC COMPARE
This sample is from the SAS Sample Library. For additional information refer to SAS Help and Online Documentation.
/****************************************************************/
/* S A S S A M P L E L I B R A R Y */
/* */
/* NAME: COMPARE */
/* TITLE: Comparison of Two Data Sets Using PROC COMPARE */
/* PRODUCT: SAS */
/* SYSTEM: ALL */
/* KEYS: DATA MANAGEMENT, */
/* PROCS: COMPARE */
/* DATA: */
/* */
/* SUPPORT: UPDATE: */
/* REF: */
/* MISC: */
/* */
/****************************************************************/
DATA ONE;
DO R=1 TO 4;
DO S=1 TO 20;
T = RANUNI(111111);
U = ARCOS(T);
OUTPUT;
END;
END;
RUN;
PROC PRINT DATA=ONE;
TITLE 'DATA SET ONE';
RUN;
DATA TWO;
SET ONE;
IF R=1 THEN DELETE;
IF S=1 THEN S=0;
IF S=10 THEN DELETE;
IF S=20 THEN S=10;
IF S>15 & S<20 THEN T = T+1;
IF U<T THEN U = 0;
RUN;
PROC PRINT DATA=TWO;
TITLE 'DATA SET TWO';
RUN;
PROC COMPARE DATA=ONE C=TWO OUTNOEQUAL OUT=OUT ALLOBS;
TITLE;
BY R;
RUN;
PROC PRINT DATA=OUT;
TITLE 'DATA SET OUT';
ID R S;
RUN;
DATA SET ONE
Obs R S T U
1 1 1 0.37610 1.18522
2 1 2 0.52728 1.01539
3 1 3 0.87847 0.49814
4 1 4 0.04289 1.52790
5 1 5 0.18403 1.38571
6 1 6 0.37561 1.18574
7 1 7 0.95891 0.28767
8 1 8 0.79901 0.64514
9 1 9 0.66405 0.84458
10 1 10 0.27611 1.29105
11 1 11 0.30570 1.26013
12 1 12 0.77751 0.68010
13 1 13 0.49527 1.05265
14 1 14 0.94551 0.33163
15 1 15 0.87784 0.49946
16 1 16 0.51855 1.02564
17 1 17 0.16849 1.40149
18 1 18 0.77122 0.69004
19 1 19 0.32063 1.24440
20 1 20 0.47689 1.07368
21 2 1 0.65134 0.86145
22 2 2 0.60595 0.91984
23 2 3 0.50602 1.04024
24 2 4 0.92483 0.39020
25 2 5 0.42547 1.13131
26 2 6 0.34800 1.21536
27 2 7 0.60933 0.91559
28 2 8 0.00877 1.56203
29 2 9 0.21598 1.35310
30 2 10 0.33246 1.23188
31 2 11 0.98128 0.19378
32 2 12 0.22476 1.34410
33 2 13 0.07364 1.49709
34 2 14 0.45785 1.09522
35 2 15 0.74981 0.72302
36 2 16 0.72768 0.75587
37 2 17 0.11582 1.45472
38 2 18 0.07813 1.49258
39 2 19 0.78541 0.66744
40 2 20 0.46477 1.08743
41 3 1 0.88183 0.49107
42 3 2 0.33507 1.22912
43 3 3 0.80385 0.63705
44 3 4 0.98099 0.19531
45 3 5 0.21449 1.35462
46 3 6 0.09990 1.47073
47 3 7 0.06759 1.50316
48 3 8 0.34731 1.21610
49 3 9 0.04129 1.52949
50 3 10 0.79226 0.65629
51 3 11 0.28929 1.27732
52 3 12 0.81403 0.61974
53 3 13 0.80642 0.63272
54 3 14 0.73813 0.74050
55 3 15 0.36671 1.19533
56 3 16 0.54905 0.98957
57 3 17 0.73320 0.74779
58 3 18 0.58023 0.95179
59 3 19 0.97381 0.22938
60 3 20 0.22206 1.34687
61 4 1 0.40495 1.15387
62 4 2 0.66300 0.84597
63 4 3 0.58865 0.94141
64 4 4 0.68480 0.81647
65 4 5 0.18505 1.38468
66 4 6 0.73618 0.74339
67 4 7 0.14178 1.42854
68 4 8 0.88574 0.48272
69 4 9 0.73771 0.74113
70 4 10 0.54161 0.99845
71 4 11 0.39932 1.16002
72 4 12 0.32264 1.24228
73 4 13 0.24074 1.32767
74 4 14 0.78583 0.66676
75 4 15 0.60844 0.91671
76 4 16 0.24102 1.32738
77 4 17 0.41241 1.14570
78 4 18 0.68927 0.81031
79 4 19 0.10690 1.46369
80 4 20 0.04745 1.52333
DATA SET TWO
Obs R S T U
1 2 0 0.65134 0.86145
2 2 2 0.60595 0.91984
3 2 3 0.50602 1.04024
4 2 4 0.92483 0.00000
5 2 5 0.42547 1.13131
6 2 6 0.34800 1.21536
7 2 7 0.60933 0.91559
8 2 8 0.00877 1.56203
9 2 9 0.21598 1.35310
10 2 11 0.98128 0.00000
11 2 12 0.22476 1.34410
12 2 13 0.07364 1.49709
13 2 14 0.45785 1.09522
14 2 15 0.74981 0.00000
15 2 16 1.72768 0.00000
16 2 17 1.11582 1.45472
17 2 18 1.07813 1.49258
18 2 19 1.78541 0.00000
19 2 10 0.46477 1.08743
20 3 0 0.88183 0.00000
21 3 2 0.33507 1.22912
22 3 3 0.80385 0.00000
23 3 4 0.98099 0.00000
24 3 5 0.21449 1.35462
25 3 6 0.09990 1.47073
26 3 7 0.06759 1.50316
27 3 8 0.34731 1.21610
28 3 9 0.04129 1.52949
29 3 11 0.28929 1.27732
30 3 12 0.81403 0.00000
31 3 13 0.80642 0.00000
32 3 14 0.73813 0.74050
33 3 15 0.36671 1.19533
34 3 16 1.54905 0.00000
35 3 17 1.73320 0.00000
36 3 18 1.58023 0.00000
37 3 19 1.97381 0.00000
38 3 10 0.22206 1.34687
39 4 0 0.40495 1.15387
40 4 2 0.66300 0.84597
41 4 3 0.58865 0.94141
42 4 4 0.68480 0.81647
43 4 5 0.18505 1.38468
44 4 6 0.73618 0.74339
45 4 7 0.14178 1.42854
46 4 8 0.88574 0.00000
47 4 9 0.73771 0.74113
48 4 11 0.39932 1.16002
49 4 12 0.32264 1.24228
50 4 13 0.24074 1.32767
51 4 14 0.78583 0.00000
52 4 15 0.60844 0.91671
53 4 16 1.24102 1.32738
54 4 17 1.41241 0.00000
55 4 18 1.68927 0.00000
56 4 19 1.10690 1.46369
57 4 10 0.047447 1.52333
The COMPARE Procedure
Comparison of WORK.ONE with WORK.TWO
(Method=EXACT)
Data Set Summary
Dataset Created Modified NVar NObs
WORK.ONE 01JUL05:15:00:59 01JUL05:15:00:59 4 80
WORK.TWO 01JUL05:15:00:59 01JUL05:15:00:59 4 57
Variables Summary
Number of Variables in Common: 4.
Number of BY Variables: 1.
The COMPARE Procedure
Comparison of WORK.ONE with WORK.TWO
(Method=EXACT)
R=2
Observation Summary
Observation Base Compare
First Obs 21 1
First Unequal 21 1
Last Unequal 39 19
Last Match 39 19
Last Obs 40
Number of Observations in Common: 19.
Number of Observations in WORK.ONE but not in WORK.TWO: 1.
Total Number of Observations Read from WORK.ONE: 20.
Total Number of Observations Read from WORK.TWO: 19.
Number of Observations with Some Compared Variables Unequal: 12.
Number of Observations with All Compared Variables Equal: 7.
Values Comparison Summary
Number of Variables Compared with All Observations Equal: 0.
Number of Variables Compared with Some Observations Unequal: 3.
Total Number of Values which Compare Unequal: 32.
Maximum Difference: 9.
All Variables Compared have Unequal Values
Variable Type Len Ndif MaxDif
S NUM 8 11 9.000
T NUM 8 10 1.707
U NUM 8 11 1.493
Value Comparison Results for Variables
__________________________________________________________
|| Base Compare
Obs || S S Diff. % Diff
________ || _________ _________ _________ _________
||
21 || 1.0000 0 -1.0000 -100.0000
22 || 2.0000 2.0000 0 0
23 || 3.0000 3.0000 0 0
24 || 4.0000 4.0000 0 0
25 || 5.0000 5.0000 0 0
26 || 6.0000 6.0000 0 0
27 || 7.0000 7.0000 0 0
28 || 8.0000 8.0000 0 0
29 || 9.0000 9.0000 0 0
The COMPARE Procedure
Comparison of WORK.ONE with WORK.TWO
(Method=EXACT)
R=2
Value Comparison Results for Variables
__________________________________________________________
|| Base Compare
Obs || S S Diff. % Diff
________ || _________ _________ _________ _________
||
30 || 10.0000 11.0000 1.0000 10.0000
31 || 11.0000 12.0000 1.0000 9.0909
32 || 12.0000 13.0000 1.0000 8.3333
33 || 13.0000 14.0000 1.0000 7.6923
34 || 14.0000 15.0000 1.0000 7.1429
35 || 15.0000 16.0000 1.0000 6.6667
36 || 16.0000 17.0000 1.0000 6.2500
37 || 17.0000 18.0000 1.0000 5.8824
38 || 18.0000 19.0000 1.0000 5.5556
39 || 19.0000 10.0000 -9.0000 -47.3684
__________________________________________________________
__________________________________________________________
|| Base Compare
Obs || T T Diff. % Diff
________ || _________ _________ _________ _________
||
21 || 0.6513 0.6513 0 0
22 || 0.6060 0.6060 0 0
23 || 0.5060 0.5060 0 0
24 || 0.9248 0.9248 0 0
25 || 0.4255 0.4255 0 0
26 || 0.3480 0.3480 0 0
27 || 0.6093 0.6093 0 0
28 || 0.008766 0.008766 0 0
29 || 0.2160 0.2160 0 0
30 || 0.3325 0.9813 0.6488 195.1561
31 || 0.9813 0.2248 -0.7565 -77.0952
32 || 0.2248 0.0736 -0.1511 -67.2344
33 || 0.0736 0.4579 0.3842 521.7083
34 || 0.4579 0.7498 0.2920 63.7669
35 || 0.7498 1.7277 0.9779 130.4160
36 || 0.7277 1.1158 0.3881 53.3394
37 || 0.1158 1.0781 0.9623 830.8925
38 || 0.0781 1.7854 1.7073 2185
39 || 0.7854 0.4648 -0.3206 -40.8249
__________________________________________________________
The COMPARE Procedure
Comparison of WORK.ONE with WORK.TWO
(Method=EXACT)
R=2
Value Comparison Results for Variables
__________________________________________________________
|| Base Compare
Obs || U U Diff. % Diff
________ || _________ _________ _________ _________
||
21 || 0.8614 0.8614 0 0
22 || 0.9198 0.9198 0 0
23 || 1.0402 1.0402 0 0
24 || 0.3902 0 -0.3902 -100.0000
25 || 1.1313 1.1313 0 0
26 || 1.2154 1.2154 0 0
27 || 0.9156 0.9156 0 0
28 || 1.5620 1.5620 0 0
29 || 1.3531 1.3531 0 0
30 || 1.2319 0 -1.2319 -100.0000
31 || 0.1938 1.3441 1.1503 593.6082
32 || 1.3441 1.4971 0.1530 11.3821
33 || 1.4971 1.0952 -0.4019 -26.8432
34 || 1.0952 0 -1.0952 -100.0000
35 || 0.7230 0 -0.7230 -100.0000
36 || 0.7559 1.4547 0.6989 92.4574
37 || 1.4547 1.4926 0.0379 2.6030
38 || 1.4926 0 -1.4926 -100.0000
39 || 0.6674 1.0874 0.4200 62.9251
__________________________________________________________
The COMPARE Procedure
Comparison of WORK.ONE with WORK.TWO
(Method=EXACT)
R=3
Observation Summary
Observation Base Compare
First Obs 41 20
First Unequal 41 20
Last Unequal 59 38
Last Match 59 38
Last Obs 60
Number of Observations in Common: 19.
Number of Observations in WORK.ONE but not in WORK.TWO: 1.
Total Number of Observations Read from WORK.ONE: 20.
Total Number of Observations Read from WORK.TWO: 19.
Number of Observations with Some Compared Variables Unequal: 13.
Number of Observations with All Compared Variables Equal: 6.
Values Comparison Summary
Number of Variables Compared with All Observations Equal: 0.
Number of Variables Compared with Some Observations Unequal: 3.
Total Number of Values which Compare Unequal: 34.
Maximum Difference: 9.
All Variables Compared have Unequal Values
Variable Type Len Ndif MaxDif
S NUM 8 11 9.000
T NUM 8 10 1.394
U NUM 8 13 1.277
Value Comparison Results for Variables
__________________________________________________________
|| Base Compare
Obs || S S Diff. % Diff
________ || _________ _________ _________ _________
||
41 || 1.0000 0 -1.0000 -100.0000
42 || 2.0000 2.0000 0 0
43 || 3.0000 3.0000 0 0
44 || 4.0000 4.0000 0 0
45 || 5.0000 5.0000 0 0
46 || 6.0000 6.0000 0 0
47 || 7.0000 7.0000 0 0
48 || 8.0000 8.0000 0 0
49 || 9.0000 9.0000 0 0
The COMPARE Procedure
Comparison of WORK.ONE with WORK.TWO
(Method=EXACT)
R=3
Value Comparison Results for Variables
__________________________________________________________
|| Base Compare
Obs || S S Diff. % Diff
________ || _________ _________ _________ _________
||
50 || 10.0000 11.0000 1.0000 10.0000
51 || 11.0000 12.0000 1.0000 9.0909
52 || 12.0000 13.0000 1.0000 8.3333
53 || 13.0000 14.0000 1.0000 7.6923
54 || 14.0000 15.0000 1.0000 7.1429
55 || 15.0000 16.0000 1.0000 6.6667
56 || 16.0000 17.0000 1.0000 6.2500
57 || 17.0000 18.0000 1.0000 5.8824
58 || 18.0000 19.0000 1.0000 5.5556
59 || 19.0000 10.0000 -9.0000 -47.3684
__________________________________________________________
__________________________________________________________
|| Base Compare
Obs || T T Diff. % Diff
________ || _________ _________ _________ _________
||
41 || 0.8818 0.8818 0 0
42 || 0.3351 0.3351 0 0
43 || 0.8039 0.8039 0 0
44 || 0.9810 0.9810 0 0
45 || 0.2145 0.2145 0 0
46 || 0.0999 0.0999 0 0
47 || 0.0676 0.0676 0 0
48 || 0.3473 0.3473 0 0
49 || 0.0413 0.0413 0 0
50 || 0.7923 0.2893 -0.5030 -63.4860
51 || 0.2893 0.8140 0.5247 181.3931
52 || 0.8140 0.8064 -0.007607 -0.9344
53 || 0.8064 0.7381 -0.0683 -8.4682
54 || 0.7381 0.3667 -0.3714 -50.3199
55 || 0.3667 1.5490 1.1823 322.4229
56 || 0.5490 1.7332 1.1841 215.6722
57 || 0.7332 1.5802 0.8470 115.5262
58 || 0.5802 1.9738 1.3936 240.1767
59 || 0.9738 0.2221 -0.7518 -77.1971
__________________________________________________________
The COMPARE Procedure
Comparison of WORK.ONE with WORK.TWO
(Method=EXACT)
R=3
Value Comparison Results for Variables
__________________________________________________________
|| Base Compare
Obs || U U Diff. % Diff
________ || _________ _________ _________ _________
||
41 || 0.4911 0 -0.4911 -100.0000
42 || 1.2291 1.2291 0 0
43 || 0.6371 0 -0.6371 -100.0000
44 || 0.1953 0 -0.1953 -100.0000
45 || 1.3546 1.3546 0 0
46 || 1.4707 1.4707 0 0
47 || 1.5032 1.5032 0 0
48 || 1.2161 1.2161 0 0
49 || 1.5295 1.5295 0 0
50 || 0.6563 1.2773 0.6210 94.6256
51 || 1.2773 0 -1.2773 -100.0000
52 || 0.6197 0 -0.6197 -100.0000
53 || 0.6327 0.7405 0.1078 17.0343
54 || 0.7405 1.1953 0.4548 61.4228
55 || 1.1953 0 -1.1953 -100.0000
56 || 0.9896 0 -0.9896 -100.0000
57 || 0.7478 0 -0.7478 -100.0000
58 || 0.9518 0 -0.9518 -100.0000
59 || 0.2294 1.3469 1.1175 487.1725
__________________________________________________________
The COMPARE Procedure
Comparison of WORK.ONE with WORK.TWO
(Method=EXACT)
R=4
Observation Summary
Observation Base Compare
First Obs 61 39
First Unequal 61 39
Last Unequal 79 57
Last Match 79 57
Last Obs 80
Number of Observations in Common: 19.
Number of Observations in WORK.ONE but not in WORK.TWO: 1.
Total Number of Observations Read from WORK.ONE: 20.
Total Number of Observations Read from WORK.TWO: 19.
Number of Observations with Some Compared Variables Unequal: 12.
Number of Observations with All Compared Variables Equal: 7.
Values Comparison Summary
Number of Variables Compared with All Observations Equal: 0.
Number of Variables Compared with Some Observations Unequal: 3.
Total Number of Values which Compare Unequal: 32.
Maximum Difference: 9.
All Variables Compared have Unequal Values
Variable Type Len Ndif MaxDif
S NUM 8 11 9.000
T NUM 8 10 1.277
U NUM 8 11 1.328
Value Comparison Results for Variables
__________________________________________________________
|| Base Compare
Obs || S S Diff. % Diff
________ || _________ _________ _________ _________
||
61 || 1.0000 0 -1.0000 -100.0000
62 || 2.0000 2.0000 0 0
63 || 3.0000 3.0000 0 0
64 || 4.0000 4.0000 0 0
65 || 5.0000 5.0000 0 0
66 || 6.0000 6.0000 0 0
67 || 7.0000 7.0000 0 0
68 || 8.0000 8.0000 0 0
69 || 9.0000 9.0000 0 0
The COMPARE Procedure
Comparison of WORK.ONE with WORK.TWO
(Method=EXACT)
R=4
Value Comparison Results for Variables
__________________________________________________________
|| Base Compare
Obs || S S Diff. % Diff
________ || _________ _________ _________ _________
||
70 || 10.0000 11.0000 1.0000 10.0000
71 || 11.0000 12.0000 1.0000 9.0909
72 || 12.0000 13.0000 1.0000 8.3333
73 || 13.0000 14.0000 1.0000 7.6923
74 || 14.0000 15.0000 1.0000 7.1429
75 || 15.0000 16.0000 1.0000 6.6667
76 || 16.0000 17.0000 1.0000 6.2500
77 || 17.0000 18.0000 1.0000 5.8824
78 || 18.0000 19.0000 1.0000 5.5556
79 || 19.0000 10.0000 -9.0000 -47.3684
__________________________________________________________
__________________________________________________________
|| Base Compare
Obs || T T Diff. % Diff
________ || _________ _________ _________ _________
||
61 || 0.4050 0.4050 0 0
62 || 0.6630 0.6630 0 0
63 || 0.5887 0.5887 0 0
64 || 0.6848 0.6848 0 0
65 || 0.1850 0.1850 0 0
66 || 0.7362 0.7362 0 0
67 || 0.1418 0.1418 0 0
68 || 0.8857 0.8857 0 0
69 || 0.7377 0.7377 0 0
70 || 0.5416 0.3993 -0.1423 -26.2704
71 || 0.3993 0.3226 -0.0767 -19.2033
72 || 0.3226 0.2407 -0.0819 -25.3852
73 || 0.2407 0.7858 0.5451 226.4241
74 || 0.7858 0.6084 -0.1774 -22.5735
75 || 0.6084 1.2410 0.6326 103.9680
76 || 0.2410 1.4124 1.1714 486.0181
77 || 0.4124 1.6893 1.2769 309.6072
78 || 0.6893 1.1069 0.4176 60.5897
79 || 0.1069 0.0474 -0.0595 -55.6166
__________________________________________________________
The COMPARE Procedure
Comparison of WORK.ONE with WORK.TWO
(Method=EXACT)
R=4
Value Comparison Results for Variables
__________________________________________________________
|| Base Compare
Obs || U U Diff. % Diff
________ || _________ _________ _________ _________
||
61 || 1.1539 1.1539 0 0
62 || 0.8460 0.8460 0 0
63 || 0.9414 0.9414 0 0
64 || 0.8165 0.8165 0 0
65 || 1.3847 1.3847 0 0
66 || 0.7434 0.7434 0 0
67 || 1.4285 1.4285 0 0
68 || 0.4827 0 -0.4827 -100.0000
69 || 0.7411 0.7411 0 0
70 || 0.9984 1.1600 0.1616 16.1819
71 || 1.1600 1.2423 0.0823 7.0914
72 || 1.2423 1.3277 0.0854 6.8739
73 || 1.3277 0 -1.3277 -100.0000
74 || 0.6668 0.9167 0.2499 37.4856
75 || 0.9167 1.3274 0.4107 44.7991
76 || 1.3274 0 -1.3274 -100.0000
77 || 1.1457 0 -1.1457 -100.0000
78 || 0.8103 1.4637 0.6534 80.6332
79 || 1.4637 1.5233 0.0596 4.0748
__________________________________________________________
DATA SET OUT
R S _TYPE_ _OBS_ T U
2 -1 DIF 1 E E
2 E DIF 4 E -0.39020
2 1 DIF 10 0.64882 -1.23188
2 1 DIF 11 -0.75652 1.15032
2 1 DIF 12 -0.15112 0.15299
2 1 DIF 13 0.38421 -0.40187
2 1 DIF 14 0.29196 -1.09522
2 1 DIF 15 0.97787 -0.72302
2 1 DIF 16 0.38814 0.69885
2 1 DIF 17 0.96231 0.03787
2 1 DIF 18 1.70728 -1.49258
2 -9 DIF 19 -0.32064 0.41999
3 -1 DIF 1 E -0.49107
3 E DIF 3 E -0.63705
3 E DIF 4 E -0.19531
3 1 DIF 10 -0.50297 0.62102
3 1 DIF 11 0.52474 -1.27732
3 1 DIF 12 -0.00761 -0.61974
3 1 DIF 13 -0.06829 0.10778
3 1 DIF 14 -0.37143 0.45483
3 1 DIF 15 1.18234 -1.19533
3 1 DIF 16 1.18415 -0.98957
3 1 DIF 17 0.84703 -0.74779
3 1 DIF 18 1.39358 -0.95179
3 -9 DIF 19 -0.75175 1.11749
4 -1 DIF 1 E E
4 E DIF 8 E -0.48272
4 1 DIF 10 -0.14228 0.16157
4 1 DIF 11 -0.07668 0.08226
4 1 DIF 12 -0.08190 0.08539
4 1 DIF 13 0.54509 -1.32767
4 1 DIF 14 -0.17739 0.24994
4 1 DIF 15 0.63258 0.41068
4 1 DIF 16 1.17139 -1.32738
4 1 DIF 17 1.27686 -1.14570
4 1 DIF 18 0.41763 0.65338
4 -9 DIF 19 -0.05946 0.05964
This example demonstrates how to compare two data sets using PROC COMPARE.
| Type: | Sample |
| Topic: | SAS Reference ==> Procedures ==> COMPARE
|
| Date Modified: | 2005-11-08 03:03:19 |
| Date Created: | 2005-05-23 13:47:24 |
Operating System and Release Information
| SAS System | Base SAS | All | n/a | n/a |
