topic Re: Table height in ods powerpoint in ODS and Base Reporting

Table height in ods powerpoint

akash1088 — Mon, 01 Oct 2018 11:39:51 GMT

Hi All,

I want to change the table height in ods powerpoint.

Re: Table height in ods powerpoint

RW9 — Mon, 01 Oct 2018 11:45:49 GMT

Google: sas table height in ods powerpoint

For example.

https://support.sas.com/resources/papers/proceedings16/SAS5443-2016.pdf

Not much else we can say as no example given, no test data (form of datastep), what needs to come out, example output, what code you have etc.

Re: Table height in ods powerpoint

akash1088 — Mon, 01 Oct 2018 11:53:14 GMT

I have used many options
1) height in ods layout gridded
2) cellwidth in style(column)
3) ods graphic on height
But know if above are working.
I don't know specific reason for this is anybody knows then please guide me .

Re: Table height in ods powerpoint

RW9 — Mon, 01 Oct 2018 12:07:20 GMT

Examples, code, logs, outputs? You have all this information, we have none of this information, how can we answer the question?

Re: Table height in ods powerpoint

akash1088 — Mon, 01 Oct 2018 12:28:46 GMT

This is the code

data m;
infile datalines dlm=',';
input name:$25. num ;
datalines;
ABCD,0.20
EFG,0.17
HIG,0.32
ghf,0.24
;
run;


goptions device=png;
ods powerpoint file='twotable.pptx' nogtitle nogfootnote;
ods layout gridded columns=2 column_widths=(50% 50%)  column_gutter=.1pct;
ods region ;
proc Report data=m
style(column)=[cellheight=2in]
style(report)={outputwidth=100%};
run;
ods region ;
proc Report data=m
style(report)={outputwidth=100%};
define name /style(column)={height=8pt};
run;
ods layout end;
ods powerpoint Close;

Re: Table height in ods powerpoint

RW9 — Mon, 01 Oct 2018 12:40:25 GMT

Interesting, I can't create pptx files from my SAS, probably because its MS proprietary as usual and backend if linux. So afraid I am going to have to leave this open for someone else to pick up. Only thing I could see that might help is this article:

https://blogs.sas.com/content/sgf/2017/11/17/ods-destination-powerpoint-new-option/

Which seems to indicate setting;

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

Can't test though.

Re: Table height in ods powerpoint

ballardw — Mon, 01 Oct 2018 15:14:05 GMT

GOPTIONS has nothing to do with the code shown. You have no Proc GPLOT GCHART GMAP or similar device based graphics output generated.

It is a suboptimal choice to not provide a fully qualified path for the output file. The relative path may place the output in strange locations.

And what do you want to change the height to?

Re: Table height in ods powerpoint

akash1088 — Tue, 02 Oct 2018 07:06:11 GMT

Yes I no that go options nothing to do with the code because I am getting warning device ActiveX that's y I have used that .

And my requirement is in my table the values are less so it's not covering the height of the slide like there was one option in SAS outputwudth=100 so like width I want height is also equal to 100.

So my plan is my increasing cell height I am trying to fit it to the page.