Have you tried printall/listall options? PRINTALL seems to be specific to the report and not the outstats dataset LISTALL doesnt seem to have an impact on my outstats dataset Can you post the code you say isn't working? proc compare base=data compare=data2 outnoequal outbase outcomp outdif LISTALL PRINTALL novalues outstats=PC out=PCD ;run; How are you capturing tables, using output statements or ODS tables? I am writing the data out to unix I created an example of what I am looking at. Data Character_VAR Number_VAR Y 132 Y 456 Y 46 Y 2 75 Y 75 Y 42 Y 8585 N 21572 N N 42 N 452 N 42 N 42 N 42 Data2 Character_VAR Number_VAR Extra_VAR Y 132 1 Y 456 1 Y 46 1 N 13 1 75 1 Y 75 1 Y 42 1 Y 8585 1 N 21572 1 N 1 N 42 11 Y 452 1 N 145 0 N 42 0 N 1 0 Results: PC _VAR_ _TYPE_ _BASE_ _COMP_ _DIF_ _PCTDIF_ Number_VAR N 14 14 14 14 Number_VAR MEAN 2257.5 2262.714286 5.214285714 49.82993197 Number_VAR STD 6001.006169 5999.004166 30.42058658 161.1040973 Number_VAR MAX 21572 21572 103 550 Number_VAR MIN 2 1 -41 -97.61904762 Number_VAR STDERR 1603.836361 1603.301304 8.130243749 43.05688112 Number_VAR T 1.407562551 1.411284504 0.641344328 1.157304725 Number_VAR PROBT 0.182720142 0.181643492 0.532443888 0.267970401 Number_VAR NDIF 3 20 Number_VAR DIFMEANS 0.230976111 0.230443841 5.214285714 Number_VAR R,RSQ 0.999987203 0.999974406 PCD _TYPE_ _OBS_ Character_VAR Number_VAR BASE 4 Y 2 COMPARE 4 N 13 DIF 4 X 11 BASE 12 N 452 COMPARE 12 Y 452 DIF 12 X BASE 13 N 42 COMPARE 13 N 145 DIF 13 . 103 BASE 15 N 42 COMPARE 15 N 1 DIF 15 . -41 My goal is to run a query of the PC dataset from the outstats to obtain a list of variables that did not match. Keep in mind I have to do this 1,000 times and concat the results for reporting and sizing magnitude.
... View more