Comparing Two Data Sets: Full Report |
COMPARE Procedure Comparison of PROCLIB.ONE with PROCLIB.TWO (Method=EXACT) Data Set Summary Dataset Created Modified NVar NObs Label PROCLIB.ONE 13MAY98:15:54:12 13MAY98:15:54:12 5 4 First Data Set PROCLIB.TWO 13MAY98:15:54:13 13MAY98:15:54:13 6 5 Second Data Set Variables Summary Number of Variables in Common: 5. Number of Variables in PROCLIB.TWO but not in PROCLIB.ONE: 1. Number of Variables with Conflicting Types: 1. Number of Variables with Differing Attributes: 3. |
Listing of Variables in PROCLIB.TWO but not in PROCLIB.ONE Variable Type Length major Char 8 Listing of Common Variables with Conflicting Types Variable Dataset Type Length student PROCLIB.ONE Num 8 PROCLIB.TWO Char 8 |
COMPARE Procedure
Comparison of PROCLIB.ONE with PROCLIB.TWO
(Method=EXACT)
Listing of Common Variables with Differing Attributes
Variable Dataset Type Length Format Label
year PROCLIB.ONE Char 8 Year of Birth
PROCLIB.TWO Char 8
state PROCLIB.ONE Char 8
PROCLIB.TWO Char 8 Home State
gr1 PROCLIB.ONE Num 8 4.1
PROCLIB.TWO Num 8 5.2
Comparison Results for Observations Observation 5 in PROCLIB.TWO not found in PROCLIB.ONE. |
Observation Summary Observation Base Compare First Obs 1 1 First Unequal 1 1 Last Unequal 4 4 Last Match 4 4 Last Obs . 5 Number of Observations in Common: 4. Number of Observations in PROCLIB.TWO but not in PROCLIB.ONE: 1. Total Number of Observations Read from PROCLIB.ONE: 4. Total Number of Observations Read from PROCLIB.TWO: 5. Number of Observations with Some Compared Variables Unequal: 4. Number of Observations with All Compared Variables Equal: 0. |
COMPARE Procedure
Comparison of PROCLIB.ONE with PROCLIB.TWO
(Method=EXACT)
Values Comparison Summary
Number of Variables Compared with All Observations Equal: 1.
Number of Variables Compared with Some Observations Unequal: 3.
Total Number of Values which Compare Unequal: 6.
Maximum Difference: 20.
Variables with All Equal Values
Variable Type Len Label
year CHAR 8 Year of Birth
Variables with Unequal Values
Variable Type Len Compare Label Ndif MaxDif
state CHAR 8 Home State 2
gr1 NUM 8 2 1.000
gr2 NUM 8 2 20.000
COMPARE Procedure Comparison of PROCLIB.ONE with PROCLIB.TWO (Method=EXACT) Value Comparison Results for Variables __________________________________________________________ || Year of Birth || Base Value Compare Value Obs || year year ________ || ________ ________ || 1 || 1970 1970 2 || 1971 1971 3 || 1969 1969 4 || 1970 1970 __________________________________________________________ __________________________________________________________ || Home State || Base Value Compare Value Obs || state state ________ || ________ ________ || 1 || NC NC 2 || MD MA 3 || PA PA 4 || MA MD __________________________________________________________ |
COMPARE Procedure
Comparison of PROCLIB.ONE with PROCLIB.TWO
(Method=EXACT)
Value Comparison Results for Variables
__________________________________________________________
|| Base Compare
Obs || gr1 gr1 Diff. % Diff
________ || _________ _________ _________ _________
||
1 || 85.0 84.00 -1.0000 -1.1765
2 || 92.0 92.00 0 0
3 || 78.0 79.00 1.0000 1.2821
4 || 87.0 87.00 0 0
________ || _________ _________ _________ _________
||
N || 4 4 4 4
Mean || 85.5000 85.5000 0 0.0264
Std || 5.8023 5.4467 0.8165 1.0042
Max || 92.0000 92.0000 1.0000 1.2821
Min || 78.0000 79.0000 -1.0000 -1.1765
StdErr || 2.9011 2.7234 0.4082 0.5021
t || 29.4711 31.3951 0.0000 0.0526
Prob>|t| || <.0001 <.0001 1.0000 0.9614
||
Ndif || 2 50.000%
DifMeans || 0.000% 0.000% 0
r, rsq || 0.991 0.983
__________________________________________________________
COMPARE Procedure
Comparison of PROCLIB.ONE with PROCLIB.TWO
(Method=EXACT)
Value Comparison Results for Variables
__________________________________________________________
|| Base Compare
Obs || gr2 gr2 Diff. % Diff
________ || _________ _________ _________ _________
||
1 || 87.0000 87.0000 0 0
2 || 92.0000 92.0000 0 0
3 || 72.0000 73.0000 1.0000 1.3889
4 || 94.0000 74.0000 -20.0000 -21.2766
________ || _________ _________ _________ _________
||
N || 4 4 4 4
Mean || 86.2500 81.5000 -4.7500 -4.9719
Std || 9.9457 9.4692 10.1776 10.8895
Max || 94.0000 92.0000 1.0000 1.3889
Min || 72.0000 73.0000 -20.0000 -21.2766
StdErr || 4.9728 4.7346 5.0888 5.4447
t || 17.3442 17.2136 -0.9334 -0.9132
Prob>|t| || 0.0004 0.0004 0.4195 0.4285
||
Ndif || 2 50.000%
DifMeans || -5.507% -5.828% -4.7500
r, rsq || 0.451 0.204
__________________________________________________________