topic Re: Rotate header labels with LAYOUT DATALATTICE in GTL in Graphics Programming

Rotate header labels with LAYOUT DATALATTICE in GTL

vladem — Wed, 16 Mar 2011 15:21:59 GMT

I place header labels on bottom and want to rotate it. Is it possible?

Thank you,
Vladimir

Re: Rotate header labels with LAYOUT DATALATTICE in GTL

GraphGuy — Wed, 16 Mar 2011 16:01:28 GMT

We'll need more details ...

For example, what proc are you using?

And do you want to rotate the one axis label, or the values at each tickmark along the axis?

Re: Rotate header labels with LAYOUT DATALATTICE in GTL

DanH_sas — Wed, 16 Mar 2011 16:02:04 GMT

Hey Vladimir,

I'm assuming you are running a PROC SGPANEL and used COLUMNHEADERPOS to move the labels to the bottom. If so, It is not currently possible to rotate them. Please post a code snipit so I'll precisely know your situation.

Thanks!
Dan

Re: Rotate header labels with LAYOUT DATALATTICE in GTL

vladem — Wed, 16 Mar 2011 16:35:12 GMT

Actually, I use code from "Sample 39166: Distribution of eye irritation". I modernized it for testing and put header labels on bottom. I need to increase length of label but SAS truncated it, and I want to rotate labels.
Is it possible?

proc format;
value xvarf
1 = 'Week 1 Week 1 Week 1'
2 = 'Week 2'
3 = 'Week 4'
4 = 'Week 6'
5 = 'Week 8'
6 = 'End Point';
value groupf
1 = 'Placebo'
2 = 'Drug A'
3 = 'Drug B';
run;
%macro test;
proc template;
define statgraph EyeIrritation;
begingraph;
mvar %do j=1 %to 6; tck1&j tck2&j %end; ;
entrytitle halign=center 'Distribution of Eye Irritation (Redness)'{sup "1"}
/ textattrs=GraphTitleText(FAMILY="arial"
SIZE=12pt
WEIGHT=bold
COLOR=cx3f4896);
layout gridded / border=false;
layout datalattice columnvar=time / shrinkfonts=false
COLUMNHEADERS=bottom
HEADERBACKGROUNDCOLOR=GraphAltBlock:color
HEADEROPAQUE=FALSE
HEADERLABELDISPLAY=VALUE
HEADERLABELLOCATION=OUTSIDE
HEADERLABELATTRS=GRAPHVALUETEXT(SIZE=6pt
WEIGHT=normal
COLOR=black
FAMILY="arial")
cellwidthmin=50
border=false
columndatarange=union
columnaxisopts=(display=(line))
rowaxisopts=(offsetmin=0
linearopts=(viewmax=100 tickvaluepriority=true)
LABEL='Number of Patients, %'
LABELATTRS=GraphLabelText(SIZE=10pt
WEIGHT=bold
COLOR=cx3f4896
FAMILY="arial")
TICKVALUEATTRS=GraphValueText(SIZE=6pt
WEIGHT=bold
COLOR=black
FAMILY="arial")
griddisplay=off);
layout prototype / walldisplay=none;
barchart x=n y=percent / group=chartvar
name='a'
BARLABEL=TRUE
BARLABELFORMAT=pctfmt.
BARLABELATTRS=GraphDataText(SIZE=6pt
WEIGHT=bold
COLOR=black
FAMILY="arial")
skin=modern
outlineattrs=(color=black)
barwidth=1;
endlayout;

endlayout;
entry ' ';

discretelegend 'a' / LOCATION=OUTSIDE
HALIGN=CENTER
VALIGN=CENTER
BORDER=FALSE
TITLE=''
TITLEATTRS=GraphValueText(SIZE=8pt
WEIGHT=bold
COLOR=red
FAMILY="arial")
VALUEATTRS=GraphValueText(SIZE=8pt
WEIGHT=bold
COLOR=black
FAMILY="arial");
endlayout;
endgraph;
end;
run;
%mend;
%test;

Re: Rotate header labels with LAYOUT DATALATTICE in GTL

DanH_sas — Thu, 17 Mar 2011 14:57:51 GMT

Hey Vladimir,

The LAYOUT DATALATTICE has the same limitation as PROC SGPANEL in that the headers currently cannot be rotated.

Dan

Re: Rotate header labels with LAYOUT DATALATTICE in GTL

tma — Wed, 25 Jan 2017 05:03:19 GMT

Hi Dan,

Is there any solution when column header is truncated when using LAYOUT DATALATTICE?

I am using SAS9.4.

Thank you very much,

Ting

Re: Rotate header labels with LAYOUT DATALATTICE in GTL

DanH_sas — Wed, 25 Jan 2017 17:03:18 GMT

There is not a direct option to prevent truncation, such as wrapping, so that data alignment across cells is maintained. Looking at your template, you are already doing the other things I would have sugested (displaying on ly the values and shrinking the header font). A couple of other thoughts would be to either increase the graph size, or use a format to create a smaller form of your header text.

Hope this helps!

Dan