How do I get more detail about the lines in BOLD? When I use option LISTOBS it will list the observations that it finds different. However when I view them I don't see any differences. How do I find out which vars are different when there are 95 vars? (Method=RELATIVE(0.0000222), Criterion=1.0E-09) Data Set Summary Dataset Created Modified NVar NObs ORDATA.ORACLETEMP 03MAY24:07:20:37 03MAY24:07:20:37 95 26553 SNOWDATA.SNOWTEMP 03MAY24:07:21:21 03MAY24:07:21:21 95 26553 Variables Summary Number of Variables in Common: 95. Number of ID Variables: 10. Number of Observations in Common: 24450. Number of Observations in ORDATA.ORACLETEMP but not in SNOWDATA.SNOWTEMP: 2103. Number of Observations in SNOWDATA.SNOWTEMP but not in ORDATA.ORACLETEMP: 2103. Total Number of Observations Read from ORDATA.ORACLETEMP: 26553. Total Number of Observations Read from SNOWDATA.SNOWTEMP: 26553. Number of Observations with Some Compared Variables Unequal: 0. Number of Observations with All Compared Variables Equal: 24450. Values Comparison Summary Number of Variables Compared with All Observations Equal: 85. Number of Variables Compared with Some Observations Unequal: 0. Total Number of Values which Compare Unequal: 0. Total Number of Values not EXACTLY Equal: 3628. Maximum Difference Criterion Value: 2.2094E-16. Here is my code: title "ordata.&ordsn versus &snowdsn"; proc compare base=ordata.&ordsn compare=snowdata.&snowdsn Criterion=0.000000001 fuzz=.001 out=result listobs outbase outcomp outdif outnoequal maxprint=50; id member medicaid_no claim_number line_number PAY_DT F_DOS L_DOS DOS AMT_REQ QTY ; attrib _all_ label=''; format _all_; informat _all_; run;
... View more