BookmarkSubscribeRSS Feed
Matt3
Quartz | Level 8

Hello,

Is there any way to paint background in eg.  10 percent (or just 10) of higher values in proc tabulate report?

I can use proc format when i know the values but I have a lot of large tables with different variables, thus I would like paint just higher values in each table. Appreciate any help.

1 REPLY 1
Reeza
Super User

You can't do it dynamically within the tabulate procedure, AFAIK, but you could probably dynamically generate your ranges and that would require pre summarizing your data, figuring out the boundaries, creating the custom format and then applying it with proc tabulate.

 

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

Creating Custom Steps in SAS Studio

Check out this tutorial series to learn how to build your own steps in SAS Studio.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 942 views
  • 0 likes
  • 2 in conversation