Hi, I'm comparing current month and previous month data, to check for the amount drop and movement between the products. Please consider the below example:- Previous month data CUSTOMER_ID MONTH PRDT_TYPE ACCOUNT_BALANCE XXX 30-Sep-22 PRDT A 25,000 XXX 30-Sep-22 PRDT B 30,000 Current Month data CUSTOMER_ID MONTH PRDT_TYPE ACCOUNT_BALANCE XXX 31-Oct-22 PRDT A 30,000 XXX 31-Oct-22 PRDT B 10,000 XXX 31-Oct-22 PRDT C 15,000 1. In previous month, customer has two products and hold total amount 55k 2. In current month, customer has three products (opened new product - PRDT C) and hold total amount 55k. 3. When comparing previous and current month data - customer moved his/her amount as follows from one to another products. TO PRODUCT FROM PRODUCT PRDT A PRDT C PRDT B 5K 15K I'm not sure, what would be the best approach to track these amount movements in SAS. Could someone of you help me on this ? Thanks in advance for your help.
... View more