topic comparing 2 large data sets in Statistical Procedures https://communities.sas.com/t5/Statistical-Procedures/comparing-2-large-data-sets/m-p/133137#M6950 <HTML><HEAD></HEAD><BODY><P><BR />I have 2 data sets with the same named 150 variables and need to look at them side by side by their unique id.&nbsp; I need to check how closely the data set I created matches what should be a near identical data set I am trying to emulate.&nbsp; How do I look at these datasets side by side in one data set by the unique identifier so I can put it is a pivot table (not my&nbsp; choice but my task) to compare the 2 sets of 150 variables?</P></BODY></HTML> Wed, 06 Jun 2012 12:59:39 GMT diva_di_dati 2012-06-06T12:59:39Z comparing 2 large data sets https://communities.sas.com/t5/Statistical-Procedures/comparing-2-large-data-sets/m-p/133137#M6950 <HTML><HEAD></HEAD><BODY><P><BR />I have 2 data sets with the same named 150 variables and need to look at them side by side by their unique id.&nbsp; I need to check how closely the data set I created matches what should be a near identical data set I am trying to emulate.&nbsp; How do I look at these datasets side by side in one data set by the unique identifier so I can put it is a pivot table (not my&nbsp; choice but my task) to compare the 2 sets of 150 variables?</P></BODY></HTML> Wed, 06 Jun 2012 12:59:39 GMT https://communities.sas.com/t5/Statistical-Procedures/comparing-2-large-data-sets/m-p/133137#M6950 diva_di_dati 2012-06-06T12:59:39Z Re: comparing 2 large data sets https://communities.sas.com/t5/Statistical-Procedures/comparing-2-large-data-sets/m-p/133138#M6951 <HTML><HEAD></HEAD><BODY><P>The standard way to compare two data set to see if they are equal is PROC COMPARE.&nbsp; If you suspect they are nearly equal and want to locate the few inequalities, this would be a good way to go about it. </P><P></P><P>You mention that you have a unique identifier.&nbsp; PROC COMPARE does permit the use of a BY statement.</P><P></P><P>Good luck.</P><P></P><P><BR /> </P></BODY></HTML> Wed, 06 Jun 2012 14:03:46 GMT https://communities.sas.com/t5/Statistical-Procedures/comparing-2-large-data-sets/m-p/133138#M6951 Astounding 2012-06-06T14:03:46Z