I have a Aggregated Measure where I need to display in button bar. But Button bar accepts only Categorical Value to display.
so I need to convert aggregated Measure to category value. Or Else Is there any other way to Display.
Most of the report controls (including button bar) - rely on categorical values given the nature of controls listing a distinct item list. You have however the option to assign an additional measure which is then aggregated given the categorical item (and displayed in brackets). More information about controls is in the VA user guide: https://go.documentation.sas.com/?cdcId=vacdc&cdcVersion=8.3&docsetId=vaobj&docsetTarget=n11d8xohg1c...
I'm not aware of a way to convert an aggregated measure to category. An aggregated measure would always need to be aggregated and as such can't be registered as stand-alone category value.
Hope this helps. Falko
I should have added - that typically you will use aggregated measures in visualizations with category value (e.g. list table, bar chart, etc.). Even a simple KPI or KeyValue would work - as long as there is a group-by/category role assigned.
Regards, Falko
You can't convert an aggregated measure into a category due to the reason mentioned before (it needs a group-by variable so it can be aggregated). This also applies to distinct count - which gives the number of distinct items given another category.
What you could try:
I'm not sure it's exactly what you need - but it should allow you to pass on the selected category in your button bar.
Regards, Falko
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.