Hi, I am trying to calculate % change in monthly "Write off amount" in my data. To do this, I am using the periodic aggregation as below: {Periodic aggregate (Current month) - Relative Period Aggregate (previous month)}/ Relative Period aggregate (previous month). My queries: 1. The formula for current month's aggregate works fine if I use "_Inferred_" as the interval for period. But it returns a missing value if I use "_ByMonth_". "Period" is a date variable formatted as monyy. Screenshot attached. 2. The same formula does not work for "Relative Period" aggregation. So if I use "Relative Period" aggregation, it returns a missing value while using "_Inferred_" or "_ByMonth_". Hence unable to output any percentage change. Screenshot attached. Note: Variable "Period" is SAS date variable (includes year) formatted as monyy. Please can someone help me understand where is the problem and why is one function working fine whereas another similar function is not.
... View more