Hi All, I working on creating a program in SAS that reconciles two data sets by four variables: Date, Category, ID, and summation of Amount. Data set one has a total amount and data set two has multiple amounts that when summed equal the total amount in data set one. In the summation I need the program to match the two data sets by ID, Category and Date. The issue is the ID in data set one is slightly different than data set two; Data set one has 8 number ID and Data set two has 12 number ID. The leftmost 8 numbers match in both data sets. I then need the program to export the results to an excel file. Is there an easy way to write this? I have all the import steps complete, just need to write the reconciliation part? Is there a reconciliation function in SAS or Macro function that could do this? Thanks, iMaq_23
... View more