Hi, I'm trying to inner join two datasets with 4 field in each. 3 of the fields are the same in both tables; data set Nov: ACCTNB, ID, SourceACCT, Amount_Nov data set Dec: ACCTNB, ID, SourceACCT, Amount_Dec I'm trying o inner join these data sets to compare the amounts and see if customers are paying different amount in two months. The problem is if there is one transaction for ID1 in Dec and three transactions for the same ID in Nov, SAS duplicates the Dec data three times to match Nov data. how can I solve this problem? Thank you
... View more