Style elements in PROC REPORT to hide cell lines in .docx output

jackieme — Wed, 22 Jun 2022 19:46:58 GMT

ods word file="\test.docx";
ods escapechar="^";
proc report data=final1 nowd
	style(report)=[verticalalign=middle cellspacing=0 width=100% bordercolor=black]
	style(header)=[background=white verticalalign=middle just=center bordercolor=black borderbottomstyle=hidden]
	style(column)=[just=center];

	columns ("^S={borderbottomstyle=hidden bordertopstyle=hidden}Group" grpvar) ("Total A and B^{super a}" ("A" a1 a2) ("B" b1 b2));

define grpvar/display " " style(column)=[just=left] style(header)=[bordertopstyle=hidden];
define a1/display "A1";
define a2/display "A2";
define b1/display "B1";
define b2/display "B2";
run;
ods word close;

I am having trouble removing the line above the "Group" cell in the table below when creating .docx output, but I am able to create it with .rtf output.

current output:

desired output:

Thank you!

Re: Style elements in PROC REPORT to hide cell lines in .docx output

ballardw — Wed, 22 Jun 2022 19:32:44 GMT

ODS Word is preproduction which means that things sometimes don't work as expected.

If you can get the output you want with RTF then use RTF. I have found in my limited attempts with ODS Word that anything except extremely simple tables seems to have an issue with one or more of the complications.

Also, please double check your posted proc report code. I tried substituting a data set I had for yours get errors with the Columns statement with a missing )

topic Re: Style elements in PROC REPORT to hide cell lines in .docx output in SAS Programming

Style elements in PROC REPORT to hide cell lines in .docx output

Re: Style elements in PROC REPORT to hide cell lines in .docx output