I'm trying to fit a table onto one PP slide. The problem is I can't figure out how to adjust row/cell height/spacing/margin. I've tried using 'height', 'cellpadding', 'cellspacing'. I've tried making each of those very small and very large, in "in" and "pt" but it never changes my output. I must be using them incorrectly. Not even sure if that is what I should be using to achieve my goal. Tried searching for this problem and how to use those style options with not much luck. I made a test table with sashelp.cars that has the same number of rows as my actual data to hopefully make this easier to help me. I've attached what I get vs what I want. Slides 1-2 are the current output. Slide 3 is what I want. proc sql outobs = 41; create table car_test as select make, model from sashelp.cars ;quit; run; ods _all_ close; run; options orientation= landscape papersize=letter nodate nonumber topmargin= .025in bottommargin= .001in leftmargin= .5in rightmargin= .5in ; ods noproctitle ; ods escapechar ="^" ; title ; footnote ; ods powerpoint file ="/mypath/test.pptx"; ***Create first slide; proc odstext; p "Test title" / style=[FONT_WEIGHT=BOLD FONT_SIZE=13 just=l]; run; ods layout gridded x=0.25in y=1.125in; ods region; option center; proc report nowd data = car_test style(header)=[font_weight=bold background=CXD3ADD9 foreground=black just=c fontsize=7pt] style(column)=[just=c fontsize=7pt verticalalign=middle height=9pt]; col make model; run; ods layout end; ods powerpoint close; ods listing; run;
... View more
