topic Re: I am trouble with ODS EXCEL and outputing a layout lattice to xlsx tab and keeping its SIze in Graphics Programming

I am trouble with ODS EXCEL and outputing a layout lattice to xlsx tab and keeping its SIze

AmfamNate — Fri, 07 Aug 2015 19:17:10 GMT

Hi all,

I am working with ODS Excel to build an Excel Workbook that will act like a scorecard. My problem is I need the graphic output to be a certain size in excel, but when it renders in Excel it defaults to 6.61 inches wide. Has anyone encountered this? Below is basically my code that I am using but very dummied down and using sashelp dataset.

data class;
set sashelp.class;
proc sort; by sex;
run;

ods listing close;

ODS EXCEL file="test.xlsx"    ;
ods excel options(sheet_name="Performance"
    fittopage='OFF'
    orientation='landscape');

%macro graph();

proc template;
define statgraph barchart ;
begingraph / designwidth=11in designheight=9in ;

   layout lattice / columns = 4 rows = 2 ;
    %do i = 1 %to 8;
        layout overlay/ ;

seriesplot x=sex y= weight / display=all lineattrs=(color=black pattern=solid) markerattrs= (symbol=circlefilled) legendlabel="ConversionRatio" name= "ser" ;
endlayout;
%end;
endlayout;

endgraph;
end;
run;
proc sgrender data=class template=barchart;
run;
%mend;
%graph();

Thanks for any help on this

Nate

Re: I am trouble with ODS EXCEL and outputing a layout lattice to xlsx tab and keeping its SIze

ballardw — Fri, 07 Aug 2015 19:50:37 GMT

Have you tried anything like:

ods graphics / height=4in width=3in;

before any procedure that produces output?

You may also want to consider scale=off if text in the graph gets too big or small.

Re: I am trouble with ODS EXCEL and outputing a layout lattice to xlsx tab and keeping its SIze

AmfamNate — Fri, 07 Aug 2015 20:00:52 GMT

I tried using the ods graphic options, but it still downsizes compared to the 11 or 12 inch width I am trying to accomplish. When I put in above 12 inch width I get the below warning.

WARNING: WIDTH exceeds available space for EXCEL destination. Setting WIDTH=1.09375in.

So does ODS Excel put a limit on the size of graphic it is rendering?