Hello, I'm trying to make my VA report display the change of a rate from last year to this year in percentage points. The rate is a calculated element that is the sum of one column divided by the absolute frequency of the table. When I try to create a new calculated element that divides the rate by the rate of the parallel period I get the error "nested aggregate expressions are not supported. So what is the correct way of doing this in VA?
Since nested aggregate expressions are not possible you could possibly work around this using aggregated data sources and then data joins.
SAS INNOVATE 2024
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.