SAS ODS PowerPoint：如何让Proc SQL标签文本强制单行显示？

问题场景 #

使用SAS ODS PowerPoint导出PPT幻灯片，通过Proc SQL输出带标签的统计数值时，标签文本总是自动拆分为每行一个单词。调整ODS HTML的页面尺寸等设置无效，需解决该问题或确认是否需改用Proc Report、Proc Tabulate等工具。

附原代码：

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;

解决方案 #

方法1：调整ODS PowerPoint的表格样式（无需更换Proc SQL） #

在ODS PowerPoint语句中指定表格单元格宽度，给标签足够显示空间，避免自动换行。修改后的代码如下：

ods powerpoint file = customers;
options nodate papersize=(10in. 7.5in);
ods escapechar="^";

/* 添加style(table)设置单元格宽度，避免标签换行 */
ods powerpoint layout=titleandcontent nogtitle style=sapphire style(table)={cellwidth=3in};

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;

也可针对单个列单独设置宽度，在Proc SQL的SELECT语句中添加style选项：

select count(distinct ID) as Leads label="Leads for August" format=comma12. style={cellwidth=3in}
from leads_august24;

方法2：改用Proc Report（更灵活的格式控制） #

Proc Report对输出格式的控制能力更强，可直接定义列的显示样式，避免标签自动换行问题，示例代码：

ods powerpoint file = customers;
options nodate papersize=(10in. 7.5in);
ods escapechar="^";

ods powerpoint layout=titleandcontent nogtitle style=sapphire;

proc report data=leads_august24 nowindows headline headskip;
columns Leads;
define Leads / display "Leads for August" format=comma12. style={cellwidth=3in};
compute Leads;
  Leads = count(distinct ID);
endcomp;
run;

proc report data=sales_august24 nowindows headline headskip;
columns Customers;
define Customers / display "Customers for August" format=comma12. style={cellwidth=3in};
compute Customers;
  Customers = count(distinct ID);
endcomp;
run;

proc report data=sales_august24 nowindows headline headskip;
columns Sales;
define Sales / display "Sales for August" format=comma12. style={cellwidth=3in};
compute Sales;
  Sales = sum(amount);
endcomp;
run;

ods powerpoint close;

方法3：改用Proc Tabulate（适合统计汇总场景） #

如果是批量统计汇总需求，Proc Tabulate也能很好控制标签显示，示例代码：

ods powerpoint file = customers;
options nodate papersize=(10in. 7.5in);
ods escapechar="^";

ods powerpoint layout=titleandcontent nogtitle style=sapphire;

proc tabulate data=leads_august24;
class _page_;
var ID;
table _page_, 
      ID*(N="Leads for August" format=comma12.) / style={cellwidth=3in};
run;

proc tabulate data=sales_august24;
class _page_;
var ID amount;
table _page_, 
      ID*(N="Customers for August" format=comma12.)
      amount*(sum="Sales for August" format=comma12.) / style={cellwidth=3in};
run;

ods powerpoint close;

内容的提问来源于stack exchange，提问作者Jont