trendline, Average Line or target line

[JBrew]

Hi All,

I'm having problems with the SGPLOT refline option  I have provided an example .  Please see attached

[SuryaKiran · Accepted solution]

You can define the start and end values for axis in XAXIS, YAXIS values. 

something like: YAXIS values=(&min to &max by 0.1)

You can get the max and min values from the dataset using proc sql INTO;

proc sql;

select max(var1),Min(var2) into: max,:min

from have;

quit;

If you want the yaxis to extend then add values to max like: YAXIS values=(&min to &max+2 by 0.1)

Check this example how to increase the yaxis lines:

proc sql;
select max(weight)+50,min(weight) into: max,:min
from sashelp.class;
quit;
options symbolgen;
proc sgplot data=sashelp.class;
  scatter x=height y=weight / group=sex;
  yaxis values=(&min to &max by 20);
run;

If you still don't get then please provide your sample data in the form of data step. Someone can sure help you if you clearly provide your requirement. 

https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-dat...