Simple question I presume - For my PPT export, part of my code has a slide where a few counts are outputted into simple boxes with a label. However, the label text keeps shifting each word onto a separate line so I end up with 3+ lines for a label. I've tried options/methods that are used for ODS HTML including page size, gridded, etc. but to no avail. Any solution for this or is it better to use an alternate method (e.g. proc report, proc tabulate, etc.)?
Here's a sample of the code:
ods powerpoint file = customers;
options nodate papersize=(10in. 7.5in);
ods escapechar="^"
ods powerpoint layout=titleandcontent nogtitle style=sapphire;
proc sql;
select count(distinct ID) as Leads label="Leads for August" format=comma12.
from leads_august24;
select count(distinct ID) as Customers label="Customers for August" format=comma12.
from sales_august24;
select sum(amount) as Sales label="Sales for August" format=comma12.
from sales_august24;
quit;
ods powerpoint close;