topic Re: ODS Powerpoint: Unbale to export a table with multiple columns to powerpoint slide in ODS and Base Reporting

ODS Powerpoint: Unbale to export a table with multiple columns to powerpoint slide

SanaMohanReddy — Tue, 03 Sep 2024 14:19:43 GMT

Hi Everyone,

Below is my code:

ods powerpoint file = "path/slide1.pptx";

proc sql;

select dept, sum(sales) sales, sum(repossessions) as repossesions, sum(losses) as loss, sum(profit) as profit, sum(accounts) as no_of_accounts

from table table1

group by dept;

quit;

ods powerpoint close;

I am expecting the complete output in a single slide, but the initial two columns in first slide, next two columns in 2nd slide and the rest in 3rd slide. the tabular data is flowing into multiple slide instead of a single slide.

Could you please or guide

I have attached a zip folders which has got 3 slides. Need to show in those formats.

Re: ODS Powerpoint: Unbale to export a table with multiple columns to powerpoint slide

Quentin — Tue, 03 Sep 2024 14:39:02 GMT

I would suggest using PROC REPORT, or maybe even just PROC PRINT to generate the report. It gives you control over font size, column widths, etc. You can still use PROC SQL to calculate the values, then use PROC REPORT to print them out.

@JaneEslinger has a bunch of great papers on ODS PowerPoint, including one specifically on the topic of how to make content fit a slide:
https://www.lexjansen.com/pharmasug/2018/DV/PharmaSUG-2018-DV01.pdf

Re: ODS Powerpoint: Unbale to export a table with multiple columns to powerpoint slide

Ksharp — Wed, 04 Sep 2024 01:28:08 GMT

I got no problem at all. Maybe there are some code you did not show?

ods powerpoint file = "c:\temp\slide1.pptx";

proc sql;
select sex length=8, sum(weight) as sales, sum(weight) as repossesions, sum(weight) as loss, sum(weight) as profit, sum(weight) as no_of_accounts
from sashelp.class
group by sex;
quit;

ods powerpoint close;

Re: ODS Powerpoint: Unbale to export a table with multiple columns to powerpoint slide

SanaMohanReddy — Wed, 04 Sep 2024 13:20:25 GMT

Hi, Thank you. But i dont have any other code. i tried using proc print directly but the columns are flowing into multiple slides. Not sure of the issue

Re: ODS Powerpoint: Unbale to export a table with multiple columns to powerpoint slide

SanaMohanReddy — Wed, 04 Sep 2024 13:20:57 GMT

Thank you. Let me try and come back

Re: ODS Powerpoint: Unbale to export a table with multiple columns to powerpoint slide

ballardw — Wed, 04 Sep 2024 14:55:03 GMT

This sounds like your output is using LAYOUT=twocontent.

See if using

ods powerpoint file = "path/slide1.pptx" layout=titleandcontent;

helps.