topic How to fix x axis value label range using proc sgplot? in SAS Visual Analytics

How to fix x axis value label range using proc sgplot?

Rayhan — Fri, 15 Nov 2024 22:27:40 GMT

I want to create a graph with a fixed x-axis range using the SGPLOT command. Specifically, I want the x-axis to range from -100 to 100 by 10. However, when I ran the code, the x-axis displayed a range of -25 to -75 by 25 instead.

Here is my code:

proc sgplot data=test5aT nowall noborder nocycleattrs dattrmap=attrmap noautolegend ;
title 'A';

format text $txt.;
styleattrs axisextent=data ;
highlow y=obsid low=low high=high/lineattrs=(thickness=.05);
scatter y=obsid x=percent / markerattrs=(symbol=circle size=10);
refline 1 / axis=x noclip;
text x=xl y=obsid text=text / position=bottom contributeoffsets=none strip;
yaxistable exposure / location=inside position=left textgroup=id labelattrs=(size=12 Weight=Bold);
yaxistable nobsused / location=inside position=left labelattrs=(size=12 Weight=Bold) valueattrs=(size=9);
yaxistable iqr percent _95/ location=inside position=left;

yaxis reverse display=none;
xaxis labelattrs=(size=12) valueattrs=(size=9);
x2axis min=-100 max=100 values=(-100 to 100 by 10)display=all labelattrs=(size=9) offsetmin=0 offsetmax=0;
xaxis label='Rate (%)' LABELPOS=DATACENTER labelattrs=(color=Black size=9 WEIGHT= BOLD);
run;

Re: How to fix x axis value label range using proc sgplot?

ballardw — Fri, 15 Nov 2024 23:04:40 GMT

Your values list is for an X2AXIS, or the top of the graph. I don't see any plot actually using the X2AXIS though.

Strong hint: ONE Xaxis and ONE Yaxis statement with all the options.

We see cases where multiple statements only have the last Xaxis or Yaxis statement applied.

Re: How to fix x axis value label range using proc sgplot?

Rayhan — Fri, 15 Nov 2024 23:13:57 GMT

I also use following ways but didn't get fixed x axis

xaxis values=(-100 to 100 by 10) labelattrs=(size=12) valueattrs=(size=9);
xaxis label='Excess rate (%)' LABELPOS=DATACENTER labelattrs=(color=Black size=9 WEIGHT= BOLD);
run;

Re: How to fix x axis value label range using proc sgplot?

quickbluefish — Sat, 16 Nov 2024 00:08:25 GMT

You have two xaxis statements - get rid of the semicolon on the first line and get rid of the 'xaxis' on the 2nd line and you should be good.

Re: How to fix x axis value label range using proc sgplot?

Rayhan — Sat, 16 Nov 2024 14:52:20 GMT

Thanks a lot, it works.