topic Re: Inserting max on sgpanel in SAS Programming

Inserting max on sgpanel

Kaeslock223_ — Mon, 03 Oct 2022 20:02:30 GMT

I can't figure out where I am supposed to put y axis max value. I am trying to stop the y axis at 30 percent instead of the full 100. I've tried adding max=0.3 on the colaxis line but it does not work nor does it work on the panelby statement. I've also tried to make a new colaxis or replace the one I have, but it will not change the y-axis. Here is my code below.

ods graphics on / width=9in;
ods graphics on / height=7in;
proc sgpanel data = final;
title "Race Distribution of Hypertension events across Metroplex";
where Program= "Hypertension";
styleattrs datacolors=(blue green red purple orange pink yellow) datacontrastcolors=(blue green red purple orange pink yellow);
panelby a b c d e/columns=5 noheader spacing=0;
rowaxis label="Percentage of Frequency of Events";
label freq_race=".";
vbar freq_race/ group=Race stat=pct dataskin=matte;
keylegend/ outerpad=2;
colaxis display= (novalues noticks);
run;
title;

Re: Inserting max on sgpanel

Reeza — Mon, 03 Oct 2022 20:41:51 GMT

So changing your colaxis statement to this does not work?

Can you show the log?

colaxis display= (novalues noticks) max = 0.3;
colaxis display= (novalues noticks) max = 30; *not sure what units are used;

Re: Inserting max on sgpanel

ballardw — Mon, 03 Oct 2022 21:03:11 GMT

Typically for SGPANEL the Y axis is the Rowaxis.

So add Max= 0.3 to your Rowaxis statement.

Re: Inserting max on sgpanel

Kaeslock223_ — Mon, 03 Oct 2022 21:41:22 GMT

Yes, that worked, thanks!