Can someone explain why this results in all nulls? It's a "Percent difference from previous period" but I am not using _month_, I and using _inferred_. It's a week over week calculation. I can seem to find an answer.
Thanks, Dave
This is the code produced by SAS VA.
( RelativePeriod(_Sum_, 'Pageviews'n, _IgnoreAllTimeFrameFilters_
, 'EndDate'n, _Inferred_, 0, _Full_, {Date}) - RelativePeriod(
_Sum_, 'Pageviews'n, _IgnoreAllTimeFrameFilters_, 'EndDate'n,
_Inferred_, -1, _Full_, {Date}) ) / Abs(RelativePeriod(_Sum_,
'Pageviews'n, _IgnoreAllTimeFrameFilters_, 'EndDate'n, _Inferred_
, -1, _Full_, {Date}))
Yes it's 7.5. I swore I used this in previous versions. Maybe before Flash was removed.
Thanks for the info. I'll hardcode on backend I guess.
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Hurry, sign up by Dec. 31 to get the 2024 rate of just $495 before it ends! Don't miss out on this incredible savings!
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.