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.
Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!
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.