BookmarkSubscribeRSS Feed
akash1088
Obsidian | Level 7
Hi All,

I want to change the table height in ods powerpoint.
7 REPLIES 7
RW9
Diamond | Level 26 RW9
Diamond | Level 26

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.

akash1088
Obsidian | Level 7
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 .
RW9
Diamond | Level 26 RW9
Diamond | Level 26

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

akash1088
Obsidian | Level 7

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;
RW9
Diamond | Level 26 RW9
Diamond | Level 26

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.

ballardw
Super User

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?

akash1088
Obsidian | Level 7
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.

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 7 replies
  • 1726 views
  • 0 likes
  • 3 in conversation