how to save the base table only records in data set after PROC compare process?

[Jade_SAS]

Hi All,

    I did proc compare and from the below coding I get the records in the base table1 only, my question is these records only show in the resuts tab in SAS, how I can save these records in SAS data set? Thank you!

Proc compare base = table1 compare = table2 listbase;

ID record_ID;

Run;

Thanks,

Jade

[ChrisBrooks · Accepted solution]

Try something like this example where OUTNOEQUAL tells Proc Compare to only output records which are not equal and OUTBASE to only output records from the base table

data class;
	set sashelp.class;
	if name="Alice" then age=99;
run;

proc compare base=sashelp.class compare=class listbase out=diffs outnoequal outbase;
run;

[Jade_SAS]

Thank you!