topic Re: how to save the base table only records in data set after PROC compare process? in SAS Data Management

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

Jade_SAS — Thu, 26 Oct 2017 16:06:01 GMT

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

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

ChrisBrooks — Fri, 27 Oct 2017 07:53:44 GMT

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;

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

Jade_SAS — Fri, 27 Oct 2017 19:22:28 GMT

Thank you!