topic Re: Why does the label option after the refline statement not work in the PROC sgpanel. in Graphics Programming

Why does the label option after the refline statement not work in the PROC sgpanel.

Tiny_Kane — Tue, 25 Apr 2017 17:21:12 GMT

Hi there,

I want to generate a panel of histogram by using PRCO SGPANEL. Please see my codes below. The output is attached. Why the lable='median' does not show beside each line in the plot? Thank you in advance.

proc sgpanel data=test;
panelby group;
histogram q2;
refline medianline_q2/axis=x lineattrs=(color=red) label="median";
run;

Re: Why does the label option after the refline statement not work in the PROC sgpanel.

DanH_sas — Tue, 25 Apr 2017 17:30:35 GMT

When your refline values come from a variable, your labels must also come from a variable. Try RETAINing the "median" value in a variable and referencing that variable from the LABEL option.

Hope this helps!

Dan

Re: Why does the label option after the refline statement not work in the PROC sgpanel.

Tiny_Kane — Tue, 25 Apr 2017 19:17:13 GMT

Hi Dan,

Thanks for your solution. I tried to create a variable with value='Median' then apply it to the Label option..However, the output looks a little ungly. Do do have any way to refine the font of the label? See the attached plot.

Thank you!

Re: Why does the label option after the refline statement not work in the PROC sgpanel.

DanH_sas — Tue, 25 Apr 2017 19:23:49 GMT

Ah..it's drawing the label multiple times. Sorry about that. Instead of RETAINing the value, add the value to the LABEL column only once per cell value. That should do it.

Thanks!
Dan

Re: Why does the label option after the refline statement not work in the PROC sgpanel.

Tiny_Kane — Tue, 25 Apr 2017 19:52:00 GMT

Works perfect! Thank you!