Hopefully we can support aggregated filters against crosstabs in a future release.
For the second part of your question, if I understand correctly, you want to apply nested aggregations in a filter expression (average of the average values, stddev of average values.) I don't think this is possible in our expression builder, but I'm not sure.
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.