topic Re: Multiple Reference Line inside SGPLOT in SAS Programming

Multiple Reference Line inside SGPLOT

hellohere — Mon, 10 Jul 2023 13:32:15 GMT

refline 2800/axis=x lineattrs=(color=red thickness=2.0);

DOES one reference line inside SGPLOT. I am running a macro, need generate SGPLOT with multiple reference lines and the values are

varied (upto macro outcome).

Anyone knows how, assume the macro saves out reference line values into a set of macro variables, refvalues.

Re: Multiple Reference Line inside SGPLOT

hellohere — Mon, 10 Jul 2023 13:35:51 GMT

One way I can think of is to store the refvalues into a dataset, and generate a text line for each reference value, and then passes into

PROC SGPLOT ... tedious though. Any straightforward way?!

Re: Multiple Reference Line inside SGPLOT

FreelanceReinh — Mon, 10 Jul 2023 14:20:26 GMT

Hi @hellohere,

Can you modify the macro so that it concatenates the reference line values into a single macro variable? Then you could just refer to that macro variable in the REFLINE statement, as shown in the example below (which also uses optional labels for the reference lines).

%let refvalues=57.5 62.8 66.5; 
%let reflabels="Q1" "Median" "Q3";

proc sgplot data=sashelp.class;
scatter x=height y=weight;
refline &refvalues / axis=x label=(&reflabels) labelloc=inside;
run;

Re: Multiple Reference Line inside SGPLOT

hellohere — Tue, 24 Oct 2023 02:32:14 GMT

How to make a HREF(Horizontal RefLine)?! at y-axis, say y=100?

Re: Multiple Reference Line inside SGPLOT

hellohere — Tue, 24 Oct 2023 02:46:31 GMT

SAS DOC gives out example below. Somehow I tried and did not show up?!
proc sgplot data=out;
scatter x=s y=residual_q;
refline 0 / axis=y;
run;

Re: Multiple Reference Line inside SGPLOT

FreelanceReinh — Tue, 24 Oct 2023 07:01:25 GMT

@hellohere wrote:
How to make a HREF(Horizontal RefLine)?! at y-axis, say y=100?

Add the statement

refline 100;

to the PROC SGPLOT step in my solution. The axis=y option is not necessary (but can be used for clarity) because the default axis for reference lines is the y-axis.

Re: Multiple Reference Line inside SGPLOT

Ksharp — Tue, 24 Oct 2023 11:26:41 GMT

/*
That is due to your variable "residual_q" did not contains ZERO.
Add option NOCLIP in it.
*/


proc sgplot data=sashelp.class;
scatter x=weight y=height;
refline 0 / axis=y NOCLIP ;
run;

Re: Multiple Reference Line inside SGPLOT

hellohere — Thu, 26 Oct 2023 01:58:33 GMT

thanks for reply. It still does not show up. The issue might be that I am using y2axis. Still confusing though...

Re: Multiple Reference Line inside SGPLOT

FreelanceReinh — Thu, 26 Oct 2023 06:23:24 GMT

@hellohere wrote:
thanks for reply. It still does not show up. The issue might be that I am using y2axis.

Then specify axis=y2 as in the example below:

%let refvalues=57.5 62.8 66.5; 
%let reflabels="Q1" "Median" "Q3";

proc sgplot data=sashelp.class;
scatter x=height y=weight / y2axis;
refline &refvalues / axis=x label=(&reflabels) labelloc=inside;
refline 100 / axis=y2 label="Your label" labelloc=inside;
run;