BookmarkSubscribeRSS Feed
Calcite | Level 5

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.

WRS Example.JPG

Any help on this would be greatly appreciated.



Super User

Code used to generate the existing table?

Calcite | Level 5

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.



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. 

Register now!

How to Concatenate Values

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.

Get the $99 certification deal.jpg



Back in the Classroom!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 2 in conversation