Hi all,
Been experimenting with this function a bit on a data set, containinig several rules per date. There's 12 dates per year, one for each month. In the report these lines are aggregated automatically . Somehow the ytd function works as expected for only the first to months of each year.
Does anybody have an idea why this is happening?
Thanks
There is a parameter in the Year to Date aggregation that is set to "_ToToday_" by default. As a result, the Year to Date function only computes the cumulative sum up until February 19th (today's date) for each year. Edit the aggregated measure and set this parameter to "_Full_" if you wish the Year to Date function to compute the cumulative sum throughout the entire year.
Thanks!
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.