I am trying to figure out how to add Month over Month, Quarter over Quarter, and Year over Year calculations columns to a SAS EG data table. The green columns below is an example of the dataset I am working with. We have month end balances for several products for the previous 13 months stacked on top of each other. I added a second view to provide an alternative. I need to figure out how to add the orange colums with a calculation. For each product ID, I want to be able to calculate the difference between the current balance and the previous month, previous quarter, and previous year. Also inlcuded is the formula that I would use in excel. The formula starts with the current balance, finds the balance for the specific product ID and previous month, and then takes the difference between the two values. Let me know if you have any follow up questions regarding my issue.
... View more