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)
I would import the Excel files sheet by sheet and then use PROC COMPARE to compare the SAS tables from each sheet.
You can only compare column names, column types and data values in SAS. You can't compare Excel formulas or macros.
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.