https://communities.sas.com/t5/SAS-Programming/proc-compare/m-p/768120#M243605 <P>Use something like this:</P> <PRE><CODE class=" language-sas">proc compare base=emp95_byidnum compare=emp96_byidnum out=result outnoequal outbase outcomp outdif noprint; id idnum; run;</CODE></PRE> <P>Koen</P> Thu, 16 Sep 2021 13:21:31 GMT sbxkoenk 2021-09-16T13:21:31Z https://communities.sas.com/t5/SAS-Programming/proc-compare/m-p/768104#M243597 <PRE>Values Comparison Summary Number of Variables Compared with All Observations Equal: 0. Number of Variables Compared with Some Observations Unequal: 1. Total Number of Values which Compare Unequal: 389124. All Variables Compared have Unequal Values <STRONG>Variable Type Len Label Ndif MaxDif Receipt CHAR 13 Recipt Number389124 </STRONG> <BR />When we use proc compare ,then we get a report in results tab,so under variables with unequal values we have a summary of variables(I have also highlighted in bold).<BR />From that highlighted summary i want to create a data set which with variable and ndif column only.<BR />Thanks you.</PRE> <P>&nbsp;</P> Thu, 16 Sep 2021 12:49:16 GMT https://communities.sas.com/t5/SAS-Programming/proc-compare/m-p/768104#M243597 asuman 2021-09-16T12:49:16Z https://communities.sas.com/t5/SAS-Programming/proc-compare/m-p/768108#M243600 <P>Could you please re-format your text so we don't have to scroll right and left to read it? Thanks!</P> Thu, 16 Sep 2021 12:55:31 GMT https://communities.sas.com/t5/SAS-Programming/proc-compare/m-p/768108#M243600 PaigeMiller 2021-09-16T12:55:31Z https://communities.sas.com/t5/SAS-Programming/proc-compare/m-p/768115#M243603 When we use proc compare ,then we get a report in results tab,so under variables with unequal values we have a summary of variables(I have also highlighted in bold).From that highlighted summary i want to create a data set which with variable and ndif column only.<BR />Thanks you. Thu, 16 Sep 2021 13:00:20 GMT https://communities.sas.com/t5/SAS-Programming/proc-compare/m-p/768115#M243603 asuman 2021-09-16T13:00:20Z https://communities.sas.com/t5/SAS-Programming/proc-compare/m-p/768120#M243605 <P>Use something like this:</P> <PRE><CODE class=" language-sas">proc compare base=emp95_byidnum compare=emp96_byidnum out=result outnoequal outbase outcomp outdif noprint; id idnum; run;</CODE></PRE> <P>Koen</P> Thu, 16 Sep 2021 13:21:31 GMT https://communities.sas.com/t5/SAS-Programming/proc-compare/m-p/768120#M243605 sbxkoenk 2021-09-16T13:21:31Z