Hello, I am trying to generate table with Span Headers across different column variables. I am to add the labels and get the line beneath the span label but it looks like the underline seems to be connected to the next group. Is there a way to restrict the underline and clearly show that spanlabel "Asia" appears over column Lexus and Toyota and "Europe" appears over column Audi and BMW. Currently both underlines seems are connected. Below is the code I am using. data cars; set sashelp.cars; where origin in ("Asia","Europe"); if make in ("Audi", "BMW","Lexus","Toyota"); if drivetrain="All"; run; proc sort data=cars out=x nodupkey; by make origin; run; proc sort data=cars; by type model drivetrain; run; proc transpose data=cars out=cars2; by type model drivetrain; id make; var enginesize; run; data cars2; set cars2; x=1; run; options leftmargin=0.75in rightmargin=0.75in topmargin=0.75in bottommargin=0.75in; ods escapechar="^"; proc template; define style style_rtf; parent=styles.rtf; style SystemTitle / font_face="Times New Roman" font_size=8pt font_weight=light font_style=roman foreground=black background=white ; style SystemFooter / font_face="Times New Roman" font_size=8pt font_weight=light font_style=roman foreground=black background=white ; style Header / font_face="Times New Roman" font_size=8pt font_weight=light font_style=roman foreground=black background=white ; style Data / font_face="Times New Roman" font_size=8pt font_weight=light font_style=roman foreground=black background=white ; style Table / foreground=black background=white cellspacing=0 cellpadding=3 frame=hsides rules=groups ; style Body / foreground=black background=white ; style SysTitleAndFooterContainer / cellspacing=0 ; end; run; ods rtf file="spanheader.rtf" style=style_rtf; title1 'Western Region Summary'; proc report data=cars2 nowd style(report)={cellwidth=100%}; column type model drivetrain ("Asia" ('^S={borderbottomwidth=1 borderbottomcolor=black}' Lexus Toyota)) ("Europe" ('^S={borderbottomwidth=1 borderbottomcolor=black}' Audi BMW)) x; define Type / style(column)={width=40mm} group; define drivetrain / "Drive Train" group style(column)={width=30mm}; define model / "Model" group style(column)={width=30mm} ; define Lexus / display style(column)={width=10mm} ; define Toyota / display style(column)={width=10mm} ; define Audi / display style(column)={width=10mm} ; define bmw / display style(column)={width=10mm} ; define x/ noprint; run; ods rtf close;
... View more
