Hi everyone,
In my information map I have a measure called count that is always =1. Then 2 categories Flag and Region. Flag can take the values ('Correct'/'Incorrect') and region can be any of about 100 regions. My dataset contains about 2,000 rows each row has a value for region and a flag value of 'Correct' or 'Incorrect'.
So from this I create a crosstab. In the columns I have the flag, then count, then % (generated dynamically as a "Row Total percent" on the measure count). In the Rows I have Region.
I then apply a rank showing the top 25 regions where flag = Incorrect. But what I would really like is a ranking of the top 25 regions with the highest percentage of flag = Incorrect. I can sort by count but not by %. Is there a way to do this is in Web Report Studio? I'd also like to add a column called rank with rank values 1-25. I'd also like to sort by percentage in a bar graph.
Any help on this would be greatly appreciated.
Thanks,
Chickenhouse
Code used to generate the existing table?
I'm not sure what you mean. A SAS DI Studio job generated the data for the table through a complex series of joins. The data was loaded into Information Map Studio, (count was a measure generated in here). Then SAS Web Report Studio created the table by just dragging stuff around it's virtually codeless.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.