topic Re: ODS PPT Adjust Height of Table Cells to fit more rows in SAS Programming

ODS PPT Adjust Height of Table Cells to fit more rows

radiate2357 — Fri, 24 Jul 2020 14:44:18 GMT

Hello Smart People

I tried to fit more rows of tables into a slide via ODS PPT. Somehow I cannot adjust the height of cells, even I have used the smallest font possible (0.1). Set cellheight in proc template does not work with ODS ppt either.

Please see the attached snapshot of the table. You can see a lot of space on top or below the numbers in the cells. How do we get rid of vertical spaces to be able to fit more rows?

Thanks.

Re: ODS PPT Adjust Height of Table Cells to fit more rows

ballardw — Fri, 24 Jul 2020 14:46:31 GMT

Please show us the code you are using to create the table(s).

There are a number of options available but they can depend on exactly how the tables are built.

You should also show all of the ODS destination options you are using.

Re: ODS PPT Adjust Height of Table Cells to fit more rows

radiate2357 — Fri, 24 Jul 2020 14:52:46 GMT

proc template ;
define style styles.teststyle1 ;
parent = styles.powerpointlight ;
class SystemTitle / font_size=23pt font_face="Arial" ;
class SystemTitle2 / font_size=18pt font_face="Arial" ;
class table / cellspacing=0pt cellpadding=0pt bordercolor=gray rules=all
frame=hsides cellheight=0.1in;
class header / fontsize=0.2 background=white foreground=black
fontweight=bold;
class data / fontsize=0.1 fontweight=medium just=left;
end;
run ;

ods powerpoint file="&defaultpath.\&filenm..ppt" image_dpi=720
style=styles.teststyle1 ;

ods region height=2.5in width=6in ;
title1 ;
title2 ;
footnote1 ;
filename getgraph "&GraphPath.\antenna-plot6_&i.-11.png" ;
proc gslide iframe= getgraph imagestyle=fit gout=graphics ;
run ;
quit ;

ods region height=0.1in;
proc odstext;
p "" / style=[FONT_SIZE=1];
run;

ods region height=6in width=10in;

proc report data=test2 split='@' ;
columns trtn trt statn statc &vislst ;
define trtn / order order=internal noprint;
define trt / order width=20 left 'Treatment';
define statn / order noprint ;
define statc / display width=20 left ' ' ;
%do j = 1 %to &nvars ;
define &&&vis&j / display width=10 left "Week &&&vislabl&j"
run ;
%end ;
ods layout end;

ods _all_ close;