topic Re: Merge cell headers vertically in proc report in ODS and Base Reporting

Merge cell headers vertically in proc report

mariko5797 — Tue, 02 Aug 2022 14:24:55 GMT

I only have subheaders for select columns. For the columns that there are no subheaders, I would prefer there to be one singular cell.

Current Output:

Study Day^a	Treatment Groups
	Group A	Group B	Total

Want:

Study Day^a	Treatment Groups
Study Day^a	Group A	Group B	Total

Note: Study Day spans two columns which are defined by day (e.g. Day 1, Day 2, etc) and the milestone (e.g. Blood Draw 1). Treatment groups are each one column and contain counts.

%let title= %str(Study Status: Number of Subjects Completing Study Milestones);

%report(2C_milestone);
proc report data= _milestone nowd split= '|' %reportstyle;
 columns ("Study Day^{super a}" milestone milestone2) ("Treatment Groups" a b /*c d e*/ f);
 	define milestone  / "" order= internal format= dy.  style(column)= [just= left vjust= t];
	define milestone2 / "" order= internal format= mil. style(column)= [just= left vjust= t];
	define a 		  / "Group A" center;
	define b 		  / "Group B"	center;
	/*define c 		  / "Group C" center;*/
	/*define d 		  / "Group D"	center;*/
	/*define e 		  / "Group E" center;*/
	define f 		  / "Total"	center;

 compute after / style= [just= l];
 	line "Note: Percentages reflective of ongoing status of the trial.";
	line "^{super a} The study schedule for Group C differs from Groups A, B, D, and E.
 When Study Day differs between treatment groups, the Study Day is listed for Groups A, B, D, and E followed by the Study Day for Group C.";
 endcomp;
run;

ods word close;

%report defines options, layout, and ods word file.

	ods word file= "&file.\&filename..docx" style= cword startpage= no options(cant_split= 'on' keep_next= 'off' keep_lines= 'on');

%reportstyle defines font style and size.

%macro reportstyle;
	style(report)=[cellspacing=0 width=100%]
	style(header)=[just=center vjust=b font_size=9pt fontfamily="Times New Roman"]
	style(column)=[just=center vjust=b font_size=9pt fontfamily="Times New Roman"]
	style(lines)=[bordercolor=black];
%mend;

Re: Merge cell headers vertically in proc report

JosvanderVelden — Thu, 04 Aug 2022 09:13:06 GMT

I'm not sure if this can be achieved in proc report. Proc document (ODS) would allow to do colspan and rowspan for the header. See example 3: https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/odsadvug/p1ki00t96zkir2n1g6l4eczqbgrk.htm#n1x72n4is4bey5n1nr66oduuij5u

Re: Merge cell headers vertically in proc report

yascm — Mon, 30 Jan 2023 20:15:45 GMT

I'm looking for this too, haven´t had any success.

I have this header,

And I want this header,

Re: Merge cell headers vertically in proc report

Cynthia_sas — Thu, 09 Feb 2023 01:04:51 GMT

Hi, Unfortunately, your screen shot is too small to see. Even using the Zoom function, the headers become all pixellated and not readable. Also, the white font on the current background is also unreadable. It looks like the suggestion posted was for an HTML/CSS solution and I'm not sure that would work for ODS WORD or ODS RTF. Microsoft designed their own version of CSS that was different than the CSS used with HTML, so that might now work. You might have to move to the Report Writing Interface to get the type of headers you want. But without your code AND your data or some dummy data to test with, it's hard to do more than make a comment.
Cynthia

Re: Merge cell headers vertically in proc report

ballardw — Thu, 09 Feb 2023 01:11:27 GMT

@yascm wrote:

I'm looking for this too, haven´t had any success.

I have this header,

And I want this header,

Start your own question, provide some example data in the form of a data step and your code. Since it appears that you may be playing with ODS Style options include your entire ODS destination code as well.

Hint: displaying something where every single value is Text doesn't give much clue as to what is going on.