I have no idea how to do it in DIS, but the concept is simple.   1) Convert each Excel file into actual SAS datasets so they are useful as data. 2) Merge the two datasets using the common variable CUSTOMER_ID to create a new third dataset. 3) If want to share the data for someone to look at then you can make a report.  It could be PDF file.  Or you could write the data back into an Excel file. ... View more