Rotate label orientation of a reference line in SGPLOT procedure

[aquaman20]

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?

[PeterClemmensen]

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

[aquaman20]

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;

[PeterClemmensen]

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 🙂

[aquaman20]

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

[PeterClemmensen]

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

[aquaman20]

[PeterClemmensen]

Can you post an image of your entire plot please?

[aquaman20]

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

[PeterClemmensen]

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.

[ballardw]

---

@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.

[Jagadishkatam]

you may try the below option in xaxis statement

xaxis ValuesRotate=Diagonal;

[aquaman20]

Sorry doesn´t work. Thanks for your help.