topic Re: Rotate label orientation of a reference line in SGPLOT procedure in New SAS User

Rotate label orientation of a reference line in SGPLOT procedure

aquaman20 — Fri, 10 May 2019 06:34:05 GMT

Hi SAS users,

Unfortunately my label references from my refline in PROC sgplot are vertical and I would like to rotate them 45 degrees to the right. Is there a solution or a command for this?

Re: Rotate label orientation of a reference line in SGPLOT procedure

PeterClemmensen — Fri, 10 May 2019 06:40:04 GMT

Can you show us your code please? What version of SAS do you use?

Re: Rotate label orientation of a reference line in SGPLOT procedure

aquaman20 — Fri, 10 May 2019 06:43:07 GMT

Here is the Code and I use SAS 9.4:

proc sgplot data=test2;

histogram T1 / scale=percent binwidth=0.25 fillattrs=(color='#C5AE45' ) legendlabel= "Vehicle group (VG)";
histogram T2 / scale=percent binwidth=0.25 fillattrs=(color='#216771' ) legendlabel = "Dose group (DG)" ;

refline 0.309 / axis = x LINEATTRS= (color='#C5AE45' PATTERN=dash thickness=2)label="Geom. mean";
refline 0.575/ axis = x LINEATTRS= (color='#C5AE45' PATTERN=shortdashdot thickness=2)label="Median";
refline 1.592 / axis = x LINEATTRS= (color='#C5AE45' PATTERN=solid thickness=2)label="Arithm. mean;

refline 15.653 / axis = x LINEATTRS= (color='#216771' PATTERN=dash thickness=2)label="Geom. mean" transparency=0.5;
refline 13.599 / axis = x LINEATTRS= (color='#216771' PATTERN=shortdashdot thickness=2)label="Median" transparency=0.5 ;
refline 18.879 / axis = x LINEATTRS= (color='#216771' PATTERN=solid thickness=2)label="Arithm. mean" transparency=0.5 ;
run;

Re: Rotate label orientation of a reference line in SGPLOT procedure

Jagadishkatam — Fri, 10 May 2019 06:46:52 GMT

you may try the below option in xaxis statement

xaxis ValuesRotate=Diagonal;

Re: Rotate label orientation of a reference line in SGPLOT procedure

aquaman20 — Fri, 10 May 2019 06:53:30 GMT

Sorry doesn´t work. Thanks for your help.

Re: Rotate label orientation of a reference line in SGPLOT procedure

PeterClemmensen — Fri, 10 May 2019 07:11:34 GMT

I'm not sure, but I don't think its possible to rotate 45 degrees. The only simple, non GTL workaround I can think of is to create another refline in the same position as the on already there with a transparent label like below.

proc sgplot data=sashelp.class;
   scatter x=height y=weight;
   refline 62 / axis=x LINEATTRS= (color='#C5AE45' PATTERN=dash thickness=2) label="Geom. mean";
   refline 62 / axis=x LINEATTRS= (color='#C5AE45' PATTERN=dash thickness=2) label="xxxxxxxxxx" labelattrs=(color="white");
run;

This will rotate your refline label by 90 degrees. Let me know if it works for you 🙂

Re: Rotate label orientation of a reference line in SGPLOT procedure

aquaman20 — Fri, 10 May 2019 07:14:32 GMT

Sorry, also does´t work really well, because now the label overlay each other and you can´t read anything.

Re: Rotate label orientation of a reference line in SGPLOT procedure

PeterClemmensen — Fri, 10 May 2019 07:16:24 GMT

What do you mean by overlay each other? can you post an image?

Re: Rotate label orientation of a reference line in SGPLOT procedure

aquaman20 — Fri, 10 May 2019 07:19:55 GMT

Re: Rotate label orientation of a reference line in SGPLOT procedure

PeterClemmensen — Fri, 10 May 2019 07:21:37 GMT

Can you post an image of your entire plot please?

Re: Rotate label orientation of a reference line in SGPLOT procedure

aquaman20 — Fri, 10 May 2019 07:23:47 GMT

Sorry, I can´t .Unfortunately, the data are confusing.

Re: Rotate label orientation of a reference line in SGPLOT procedure

PeterClemmensen — Fri, 10 May 2019 08:01:09 GMT

Ok. I can't see your data, so I can't help you on that one. My best advice is to use the mentioned workaround and place the 'fake' refline statements before any of the 'real' ones. Remember to specify the same color for the refline labels as the background. That way, the 'real' refline labels will overwrite the 'fake' ones and that shouldn't be a problem.

I hope you find a suitable solution 🙂 Otherwise, don't hesitate to ask again.

Re: Rotate label orientation of a reference line in SGPLOT procedure

ballardw — Fri, 10 May 2019 14:41:22 GMT

@aquaman20 wrote:

Here is the Code and I use SAS 9.4:

proc sgplot data=test2;

histogram T1 / scale=percent binwidth=0.25 fillattrs=(color='#C5AE45' ) legendlabel= "Vehicle group (VG)";
histogram T2 / scale=percent binwidth=0.25 fillattrs=(color='#216771' ) legendlabel = "Dose group (DG)" ;

refline 0.309 / axis = x LINEATTRS= (color='#C5AE45' PATTERN=dash thickness=2)label="Geom. mean";
refline 0.575/ axis = x LINEATTRS= (color='#C5AE45' PATTERN=shortdashdot thickness=2)label="Median";
refline 1.592 / axis = x LINEATTRS= (color='#C5AE45' PATTERN=solid thickness=2)label="Arithm. mean;

refline 15.653 / axis = x LINEATTRS= (color='#216771' PATTERN=dash thickness=2)label="Geom. mean" transparency=0.5;
refline 13.599 / axis = x LINEATTRS= (color='#216771' PATTERN=shortdashdot thickness=2)label="Median" transparency=0.5 ;
refline 18.879 / axis = x LINEATTRS= (color='#216771' PATTERN=solid thickness=2)label="Arithm. mean" transparency=0.5 ;
run;

Try this. For the offending REFLINE do not add a label.

To you data add an observation with a text variable holding the label text, and an x and y coordinate. Plot that variable using a TEXT plot. You can use options such as ROTATE for the text value and TEXTATTRS to control color, font and size.