Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

unexpected behavior year_to_date function?

Reply
Occasional Contributor
Posts: 12

unexpected behavior year_to_date function?

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

yeartodate.png

New Contributor
Posts: 4

Re: unexpected behavior year_to_date function?

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.

Occasional Contributor
Posts: 12

Re: unexpected behavior year_to_date function?

Thanks!

Ask a Question
Discussion stats
  • 2 replies
  • 274 views
  • 0 likes
  • 2 in conversation