I am trying to create a cummulative trend over a period of time for Penetration %, which is a aggregated measure. But SAs Va only allows me to use a measure as a value to create a cumulative variable. Is there a way to create this in SAS VA
You can't - Can't you just use your penetration measure? Penetration% must just be a calculated items: x/y * 100?
You could probably use the CumulativePeriod function to calculate the numerators and denominators (X & Y) seperately for a specific period then divide them in a third aggregated measure which would give you the % for the period.
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.