topic Re: Proc Report Header Border and ODS Powerpoint in ODS and Base Reporting

Proc Report Header Border and ODS Powerpoint

Dave25 — Tue, 10 Apr 2018 21:25:52 GMT

Any ideas why my Header Border works in pdf but not in powerpoint? (or, any ideas what I could do differently to get it to work?)

included stripped down program code.

thanks!

Dave

data test;
input School $ val1 val2;
cards;
A 1 2
B 1 2
;

run;

ods pdf file = 'C:\temp\test.pdf';
ods powerpoint file = 'C:\temp\test.pptx';
ods escapechar = "^";

proc report data=test;
column School ("^{style[borderrightcolor=Black borderrightwidth=8 ] Span}" val1 val2);
define val1/display style=[just=center FONT_SIZE=12pt cellwidth=1.4 cm cellheight=.35 cm borderrightwidth=5];;
define val2/display style=[just=center FONT_SIZE=12pt cellwidth=1.4 cm cellheight=.35 cm borderrightwidth=8 borderrightcolor=Black];;
run;
ods pdf close;
ods powerpoint close;

Re: Proc Report Header Border and ODS Powerpoint

Cynthia_sas — Wed, 11 Apr 2018 01:34:35 GMT

Hi,
You'd have to check with Tech Support for the definitive answer or in the documentation, but I remember that many of the "border" specific attributes are only valid in markup family destinations, the RTF destination, and the Measured RTF destination and sometimes in the Printer family destinations and sometimes in HTML destinations.

If you check the documentation and the destination, like PowerPoint or ODS Excel is not explicitly listed, then I would not expect the attribute to work.

Cynthia

Re: Proc Report Header Border and ODS Powerpoint

Dave25 — Wed, 11 Apr 2018 12:48:59 GMT

Thanks Cynthia - i checked with SAS technical support, this was their reply:

This is a known defect for multiple destinations including PowerPoint. It is being addressed in a future release of SAS. Currently there is no work-around for the PowerPoint destination.