BookmarkSubscribeRSS Feed
tparvaiz
Obsidian | Level 7

Hi,

I am using GCHART to show volumes by city... so I've used City to "grouped chart by".

On top of every chart I am getting something like this

CITY=TORONTO

then my chart

CITY = NEWYORK

then my chart

how can I remove CITY= and just show the name of the city...?

Thanks

4 REPLIES 4
ballardw
Super User

Since there are many ways to generate the same chart examples of what you are currently doing will help us answer your question better.

GraphGuy
Meteorite | Level 14

Depending on how you're doing things ...

You'll probably use the following to suppress the default by-titles...

options nobyline;

And then you can specify your own custom title2 (without the 'CITY=') using something like ...

title2 "#byval(&city)";

Google 'nobyline' and 'byval' for more info & variations of the techniques, such as ...

http://www2.sas.com/proceedings/sugi23/Coders/p75.pdf

Bill
Quartz | Level 8

I've used label city='00'x before ...

VD
Calcite | Level 5 VD
Calcite | Level 5

I had faced a similar issue while using Proc SGPANEL. I managed to solve it by using the NOVARNAME option. You can check if it works in proc gchart.

sas-innovate-white.png

Missed SAS Innovate in Orlando?

Catch the best of SAS Innovate 2025 — anytime, anywhere. Stream powerful keynotes, real-world demos, and game-changing insights from the world’s leading data and AI minds.

 

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.

SAS Training: Just a Click Away

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

Browse our catalog!

Discussion stats
  • 4 replies
  • 1434 views
  • 0 likes
  • 5 in conversation