How to force y-axis show certain value, which is 1 in this case

[Cruise]

Hello folks:

Is there any way to force y-axis to show 1.00? See the plot below, that 1.00 is not included. The max values that I have to present on the y-axis are 1.55 or 1.54 and 0.93 or 0.94 for minimum values.

I tried myriad different combinations of (min to max by 0.0n) in my code below with no success. Attached is the underlying data=(have).

Thanks for your time.

I greatly appreciate your help.

ods graphics ON;
OPTIONS NOTES; 
ods graphics/width=12in height=4.5in;
proc sgpanel data=HAVE noautolegend;
panelby agegrp/ novarname columns=4 rows=1;
styleattrs DATACONTRASTCOLORS=(BLUE green red);
series  x=PCT_MISS y=HazardRatio_Mean/GROUP=STAGE lineattrs=(pattern=solid);
series  x=PCT_MISS y=ONE/group=stage lineattrs=(pattern=dash) lineattrs=(thickness=4);
REFLINE 1 / LABEL = ('HR=1') lineattrs=(color=BLACK pattern=dash thickness=1.5) LABELPOS=MIN; 
colaxis min=1 max=100 grid values=(0 to 100 by 5) LABELATTRS=(Family=Arial Size=11);
rowaxis grid values=(0.93 to 1.54 by 0.01) LABELATTRS=(Family=Arial Size=11);
run;

[FreelanceReinh · Accepted solution]

Hello @Cruise,

I'd probably use 0.92 to 1.56 by 0.04. This comes close to your current settings and includes 1.00. The slight compression of the axis could be compensated by reducing the OFFSETMIN= and OFFSETMAX= values to zero or a small positive value (if necessary).

Edit: Thanks for posting conveniently usable code and test data. 🙂

[Cruise]

Thanks a lot. It worked out perfectly!