https://communities.sas.com/t5/SAS-Programming/In-SAS-how-do-i-compare-two-excel-files-or-two-data-set-to-make/m-p/744289#M233170 <P>For example, i want to check that two excel files are identical. How would I check that? And also produce a separate table in excel or report on which rows are same and which rows are different(it belonged to this test2 excel file but it was not in the other test2 excel file)</P> Thu, 27 May 2021 20:03:02 GMT kmin87 2021-05-27T20:03:02Z https://communities.sas.com/t5/SAS-Programming/In-SAS-how-do-i-compare-two-excel-files-or-two-data-set-to-make/m-p/744289#M233170 <P>For example, i want to check that two excel files are identical. How would I check that? And also produce a separate table in excel or report on which rows are same and which rows are different(it belonged to this test2 excel file but it was not in the other test2 excel file)</P> Thu, 27 May 2021 20:03:02 GMT https://communities.sas.com/t5/SAS-Programming/In-SAS-how-do-i-compare-two-excel-files-or-two-data-set-to-make/m-p/744289#M233170 kmin87 2021-05-27T20:03:02Z https://communities.sas.com/t5/SAS-Programming/In-SAS-how-do-i-compare-two-excel-files-or-two-data-set-to-make/m-p/744294#M233173 <P>I would import the Excel files sheet by sheet and then use PROC COMPARE to compare the SAS tables from each sheet.</P> <P>&nbsp;</P> <P>You can only compare column names, column types and data values in SAS. You can't compare Excel formulas or macros.</P> Thu, 27 May 2021 20:20:36 GMT https://communities.sas.com/t5/SAS-Programming/In-SAS-how-do-i-compare-two-excel-files-or-two-data-set-to-make/m-p/744294#M233173 SASKiwi 2021-05-27T20:20:36Z