Is it possible to just display the values in a dataset without doing any kind of aggregation in a crosstab or a list table?
As my variable is a combination of numbers and ratio/percentatges I just want to display values as they are and no aggregation?
The problem is with adding category variables to the report where it aggregates values by itself, instead of showing what they are. There is no problem with numbers as it is obviously a sum but the issue arises when I have to show ratios and percentages in the same column.
Business Requirement- Tried to explain to keep them separate, basically trying to meet excel expectations here.
So I have a column which calculates ratio/percentages and if I group it by a variable SAS just sums up all the values instead of displaying the values I feed in.
I may not be articulating this well, your solution works well but it displays all the values in the category variable. I can create a ds in the backend to feed in values but can't have any report filters as the default aggregation SAS uses is "sum" for all the measures by default.
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.