As an easy example to present my problem I have the following very ordinary table showing monthly volumes per year. I would like VA to automatically do the Year to date calculation for me, so that I would not have to manually update the report each month. But when i choose "create and add" and choose "Year to date using date", I see that 2015 looks ok, we have data until february and the total is thus january+february as is shown in the table below. But I see that in 2014, also a part of March is counted into the total. And this means that 2013 and 2014 havemore than Ferbruary in the Year to date total. Which means it is not comparable with 2015. Does anyone know what I'm doing wrong? To clarify, we get new monthly data in the beginning of each month. So we get the whole month of March in the beginning of April.
All answers are highly appreciated.
Thank you for the reply. I tried this solution. But when changing the scope to "Full", the years 2013 and 2014 became full years, but my intention was to get 2013-2014 to be the exact same period as 2015 to be able to compare the YTD 2015 with 2013-2014.
I also tried to change the scope to "To date" and chose February. This gives me the right numbers, but I guess in this case I need to go in each month and change the date manually?
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.