topic Re: How to remove spacing in the graph? in Graphics Programming

How to remove spacing in the graph?

mimi — Thu, 19 Jun 2014 05:44:10 GMT

Hi All,

My graph is not showing the complete y axis...need to increase the height of y axis . Too much space between # of subject visits label and the rows showing subject number for each treatment groups.

Since I increased the pixel with to 950 to include all visits , not creating any GIF image only html is created.

Please see the complete code.

I need to use this for different lab tests.

Please help me to fix this issue... its very urgent.

Any help is greatly appreciated.

Thanks in advance!

/* Create the template that will be used to graph the merged dataset */

%macro gtemplate(lbtestcd,ll=,lu=,fnote=);

proc template;

define statgraph &lbtestcd._profile4;

dynamic title;

begingraph / designwidth=15in designheight=15in;

entrytitle halign=left textattrs=(size=8 weight=normal) "xxxxxxxxxxxxxxxxxxx" halign=right "PAGE 1 OF 1";

entrytitle halign=center textattrs=(size=10 weight=bold) " ";

entrytitle halign=center textattrs=(size=10 weight=bold) "Mean of &lbtestcd. [&&lbt&lbtestcd.(&&lbu&lbtestcd.)] by Treatment: Profile Over Time";

entrytitle halign=center textattrs=(size=10 weight=bold) "Safety Population";

/* layout lattice / columndatarange=union rowweights=(0.84 0.05 0.05 0.05 0.05 0.05 0.05);*/

/* layout lattice / columndatarange=union rowweights=(0.90 0.08 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05);*/

layout lattice / columndatarange=union rowweights=(0.84 0.04 0.04 0.04 0.04 );

layout overlay / cycleattrs=true yaxisopts=(label="Mean (&&lbu&lbtestcd) with 95% CI" labelattrs=(size=11.5 weight=bold) griddisplay=on)

xaxisopts=(label='Visit' labelattrs=(size=11.5 weight=bold) /*offsetmin=0.05 offsetmax=0.05 display=(line ticks

tickvalues)*/

linearopts=(tickvaluelist=(1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39)

tickdisplaylist=('C1D1' 'C1D8' 'C1D9' 'C1D10' 'C1D11' 'C1D14' 'C1D18' '122' 'C2D1' 'C2D8' 'C2D18' 'C2D22' 'C3D1' 'C4D1' 'C4D22' 'C5D1' 'C6D1'

'C7D1' 'C7D29' 'C8D1' 'C9D1' 'C10D1' 'C11D1' 'C12D1' 'C13D1' 'C14D1' 'C15D1' 'C16D1' 'C17D1' 'C18D1' 'C19D1' 'C20D1' 'C21D1' 'C22D1'

'C23D1' 'C23D8' 'C24D1' 'C24D18' 'EOT')));

bandplot x=visitnum limitlower=&ll limitupper=&lu /display=standard datatransparency=.9 name='Overall Normal Range';

scatterplot x=eval(visitnum-0.15) y=DE / yerrorlower=LCLlow yerrorupper=UCLde name='DE'

markerattrs=graphdata1(size=9px weight=bold)

errorbarattrs=graphdata1(pattern=solid thickness=1.5);

scatterplot x=eval(visitnum+0.15) y=PHII / yerrorlower=LCLphii yerrorupper=UCLphii name='PHII'

markerattrs=graphdata2(size=9px weight=bold)

errorbarattrs=graphdata2(pattern=solid thickness=1.5);

seriesplot x=eval(visitnum-0.15) y=de / lineattrs=graphdata1(pattern=solid color=blue thickness=1.5px) name='DE';

seriesplot x=eval(visitnum+0.05) y=phii / lineattrs=graphdata2(pattern=shortdash color=red thickness=1.5px) name='PHII';

endlayout;

layout overlay;

entry halign=left '#of Subjects at Visit:';

endlayout;

blockplot x=visitx block=TDE / display=(values label) valuehalign=/*center*/left label='DE' repeatedvalues=true

valueattrs=graphdata1(size=7.5 color=blue) labelattrs=graphdata1(size=7.5 weight=normal color=blue);

blockplot x=visitx block=tphii / display=(values label) valuehalign=/*center*/left label='PHII' repeatedvalues=true

valueattrs=graphdata2(size=7.5 color=red) labelattrs=graphdata2(size=7.5 weight=normal color=red);

sidebar / spacefill=false;

discretelegend 'DE' 'PHII' 'Overall Normal Range' / title='Treatment Group Means:' titleattrs=(size=8 weight=normal) across=4

valueattrs=(size=8 weight=normal);

endsidebar;

endlayout;

entryfootnote halign=left textattrs=(size=8 weight=normal) "Note: Overall Normal Range represents the lowest lower limit and the highest upper limit from the set of ranges provided by different local laboratories";

entryfootnote halign=left textattrs=(size=8 weight=normal) "&fnote";

entryfootnote halign=left textattrs=(size=8 weight=normal) "Data Extract: &rawvers. Produced: %sysfunc(date(),date9.) %sysfunc(time(),time5.) Source: &pgm. Output:&lbtestcd.Profile.html";

endgraph;

end;

run;

%mend gtemplate;

%gtemplate(CREAT,ll=0,lu=176.8,fnote=%str(CTCAE Range (umol/L): Grade1:>177 - 265; Grade2:>265 - 530; Grade3:>530 - 1061; Grade4:>1061));

%macro greport(lbtestcd);

/* Create graph using the template and data. */

ods listing close;

ods html image_dpi=100 file="&lbtestcd.Profile.html" path="&path";

ods graphics / reset noborder width=950px height=800px

imagename="&lbtestcd.Profile" imagefmt=gif noscale;

proc sgrender data=&lbtestcd template=&lbtestcd._profile4;

run;

ods html close;

ods listing;

%mend greport;

see Screen shot

Re: How to remove spacing in the graph?

DanH_sas — Thu, 19 Jun 2014 14:34:14 GMT

What version of SAS are you using?

Re: How to remove spacing in the graph?

mimi — Thu, 19 Jun 2014 14:57:26 GMT

I am using SAS 9.3.

The previous program was showing 3 treatment groups . I just removed the last one.

The other program was working fine

Re: How to remove spacing in the graph?

mimi — Thu, 19 Jun 2014 15:06:45 GMT

Hi Dan,

How can send you the data set that I am using. Attachment is not working.

Re: How to remove spacing in the graph?

Jay54 — Thu, 19 Jun 2014 15:22:01 GMT

Not sure this is the problem, but you have a mismatch between the number of entries in the ROWHEIGHT options and the number of cells in the graph. Also, if you put the block plots in an INNERMARGIN, they will size correctly by themselves. If you can attach the full program, it may be better as you have macros and macro variables. I believe you can create a zip file of program and data and attach it.

Re: How to remove spacing in the graph?

mimi — Thu, 19 Jun 2014 15:51:22 GMT

Hi Sanjay,

Is it possible to send you in your email.

Re: How to remove spacing in the graph?

Jay54 — Thu, 19 Jun 2014 16:01:55 GMT

Sure. I assume you have my email address or can easily find it.

Re: How to remove spacing in the graph?

mimi — Thu, 19 Jun 2014 16:26:18 GMT

Hi Sanjay,

I sent it. did you get it?

Re: How to remove spacing in the graph?

mimi — Thu, 19 Jun 2014 18:37:14 GMT

Hi Sanjay,

I tried sending you email but not going

Re: How to remove spacing in the graph?

Jay54 — Thu, 19 Jun 2014 19:04:16 GMT

You can send me the program and data at ods@sas.com

Re: How to remove spacing in the graph?

mimi — Thu, 19 Jun 2014 19:23:14 GMT

Thanks Sanjay! Already sent

Re: How to remove spacing in the graph?

Jay54 — Thu, 19 Jun 2014 23:23:09 GMT

As I suggested earlier, removing the extra 0.04 in the ROWWEIGHTS option will produce better spacing.

layout lattice / columndatarange=union rowweights=(0.84 0.040.04 0.04);

Re: How to remove spacing in the graph?

mimi — Fri, 20 Jun 2014 20:15:59 GMT

Hi Sanjay,

Thank you very much the rawweight change worked perfect!

Now another issue is . The same code created the graph with gray back ground and the # of subject at visit is showing in uniform distance and is aligned with the plot.

If you look at my graph after first 2 visits few gap then after 3rd one few gap then showing in uniform distance till before last visits. See the part of sample graph with gray back ground and uniform distance (Same template code is for is used with one more REWWEIGHT value)

Thanks in advance!

Re: How to remove spacing in the graph?

Jay54 — Mon, 23 Jun 2014 22:49:34 GMT

To align the values with the tick values, use VALUEHALIGN=START on the BLOCKPLOTs.

Re: How to remove spacing in the graph?

mimi — Tue, 24 Jun 2014 16:36:20 GMT

Thanks Sanjay! I will try that! But how to get that greyish background?? Is it because my SAS version is 3.0?

Re: How to remove spacing in the graph?

mimi — Tue, 24 Jun 2014 16:47:42 GMT

VALUEHALIGN=START on the BLOCKPLOTs worked perfect! but I had increase the width to 1000px to show all values. But no grey background :smileyconfused:

Re: How to remove spacing in the graph?

mimi — Tue, 24 Jun 2014 16:55:07 GMT

That worked perfect for alignment! but the background is still white I am not getting same as one in the sample screen print I posted. Is is because of version 3.0? :smileyconfused:

Re: How to remove spacing in the graph?

Jay54 — Tue, 24 Jun 2014 17:10:12 GMT

You will get the gray background around the graph if you use STYLE=DEFAULT, which is the default style for HTML destination prior to SAS 9.3. To get white backgrounds, use STYLE=LISITNG or HTMLBLUE (SAS 9.3 or later).

If you really want the grey background and also gray behind the block plots, you need to add layout overlay around each blockplot like this:

layout overlay / wallcolor=graphbackground:color walldisplay=none xaxisopts=(display=none) yaxisopts=(display=none);

blockplot x=visitx block=TDE / display=(values label) valuehalign=/*center*/left label='DE' repeatedvalues=true

valueattrs=graphdata1(size=7.5 color=blue) labelattrs=graphdata1(size=7.5 weight=normal color=blue);

endlayout;

Re: How to remove spacing in the graph?

mimi — Thu, 26 Jun 2014 17:08:44 GMT

Thanks Sanjay for the fast response! I will try this out!