I have a category variable with age groups, such as 1-10, 11-20, 21-20, 31-, and want to graphically present the change in percent frequency of each class between two dates. Does anyone have an idea on how I can do this within the Report Designer in SAS visual analytics? The desired reslut (which should be presented grapically somehow) is something like this. The first three columns are percent frequency by data and the last two are growth in percent frequncey. Age group 2016-01-01 2016-06-01 2017-01-01 2016-01-01 - 2016-06-01 2016-01-01 - 2017-01-01 0-10 30% 20% 20% -33% -33% 11-20 20% 30% 20% 50% 0% 21-30 20% 30% 40% 50% 100% 31- 30% 20% 20% -33% -33% Tot 100% 100% 100% which shold be calculated from data something like this: Date ID Age group 2016-01-01 1 0-10 2016-01-01 2 0-10 2016-01-01 3 0-10 2016-01-01 4 11-20 2016-01-01 5 11-20 2016-01-01 6 21-30 2016-01-01 7 21-30 2016-01-01 8 31- 2016-01-01 9 31- 2016-01-01 10 31- 2016-06-01 1 0-10 2016-06-01 2 0-10 2016-06-01 3 11-20 2016-06-01 4 11-20 2016-06-01 5 11-20 2016-06-01 6 21-30 2016-06-01 7 21-30 2016-06-01 8 21-30 2016-06-01 9 31- 2016-06-01 10 31- 2017-01-01 1 0-10 2017-01-01 2 0-10 2017-01-01 3 11-20 2017-01-01 4 11-20 2017-01-01 5 21-30 2017-01-01 6 21-30 2017-01-01 7 21-30 2017-01-01 8 21-30 2017-01-01 9 31- 2017-01-01 10 31-
... View more