topic Re: Need a 2nd headline when using spanning header in ODS and Base Reporting

Need a 2nd headline when using spanning header

VCM — Thu, 21 Jun 2018 14:54:23 GMT

I need to create a report with spanning headers over the columns, then a line below the spanning headers, then the "main" headers, and then another line:

Using HEADLINE gives me the bottom line, of course, but is there a fast and easy way to create the first line, besides literally typing in a bunch of underscores?

VCM

Re: Need a 2nd headline when using spanning header

ballardw — Thu, 21 Jun 2018 15:46:05 GMT

What code are you currently using and which ODS Style?

Typing underscores is likely to be unrewarding as changes to font size, font face, bold/italic, length of other text will mean things don't line up very well and depending on other factors may actually allow individual underscores to be see.

Re: Need a 2nd headline when using spanning header

Cynthia_sas — Thu, 21 Jun 2018 19:08:53 GMT

Hi:
Without code, it's hard to speculate. It will make a difference about how you do it, depending on what your destination is and what initial style you're using. You have 2 approaches -- using a TEXTDECORATION style override or changing the bordertop... or borderbottom... style overrides. HEADLINE and HEADSKIP are LISTING only options, so they would NOT be giving your anything in ODS output. Your output looks like JOURNAL style, which has RULES=GROUPS turned on that might put the bottom line under the column headers.

This forum posting https://communities.sas.com/t5/ODS-and-Base-Reporting/How-to-write-ods-latex-template/m-p/471278#M21087 showed the use of border controls with PROC REPORT and ODS RTF to put an extra line into spanning headers. That person was using ACROSS items, so your use case might be different.

Cynthia