BookmarkSubscribeRSS Feed
Naruto2012
Calcite | Level 5

   I’m having a bit of a problem getting SGPLOT to display different bar colors for me in a waterfall plot.  Graphing is not a particular strength of mine but I'm not sure what to make of this message in the log:

“Once a GROUP variable is used in a categorical chart, that GROUP variable must be used in all overlaid charts.  The specified GROUP variable has been removed from the graph display.”

The code I’m using isn’t anything crazy and a search of the internet hasn’t provided me any solutions as other publications I've seen use the GROUP option to dynamically change the color of the bars

This is what I’m using:

proc sgplot data=x;

  vbar dummyid/ response=pchg group=nhlpop barwidth=.5;

  vline dummyid/ response=CR_PLOT markers markerattrs=(symbol=star size=4 color=green)

                                  lineattrs=(thickness=0);

  xaxis display=none;

  yaxis values=(-100 to 100 by 50) label='Tumor Size (% Change from Baseline)';

  title 'Waterfall Plot: Tumor Size Change Across NHL Types';

run;

NHLPOP is just a numeric field with either a 1 or 2 value.  I just want to use the default ODS colors to change the bar colors based on what NHLPOP group they belong to.

Any assistance would be greatly appreciated.

1 REPLY 1
Naruto2012
Calcite | Level 5

Almost forgot I'm using SAS 9.2.

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

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
  • 1 reply
  • 1265 views
  • 0 likes
  • 1 in conversation