Hi all, I have a data set that reports values yearly and monthly. The first year given in a category I need the previous values to be missing. Here is a screenshot below with my general code being: PREVIOUS_YTD=LAG12(YTD); Here's with: IF FIRST.YEAR THEN PREVIOUS_YTD=. ; ELSE PREVIOUS_YTD=LAG12(YTD); In this example, 2018 is the first year for this category, so the previous YTD values should be missing. I have no idea where 86 or 104 is coming from. Possibly from the other categories?
... View more