My question is: How to compute the overall average of ratios (aggregated measures) in SAS VA?
Let's say I have data on turnover and profit by day and want to sum it by month, compute the profit ratio by month (as an aggregated measure) and then compute the average of those individual profit ratios? I dont see a way to do this without a seperate data source (pre aggregated or aggregated data source in VA).
If I would just want the average of the individual sums of profit by month, then I could use the "aggregated table operator": First sum by month and then average for the total. But with ratios I dont see, how this could work!