Hello,
In ODS Excel the borders of the title are not displayed properly across the entire merged cells:
In ODS Tagset.ExcelXP it works without problems:
Sample Code:
proc template;
define style title_test;
parent=styles.HTMLBlue;
class SystemTitle /
background=pink
bordercolor = black
borderstyle = solid
borderbottomcolor=aquamarine
borderbottomwidth=4
;
end;
run;
ods tagsets.excelxp(i) file="test_tagset_excelxp.xls"
style=title_test
options(
sheet_interval = 'none'
sheet_name='test'
sheet_label = ' '
embedded_titles = 'yes'
suppress_bylines = 'yes'
Merge_Titles_Footnotes='yes'
);
title "Title in ODS Tagset ExcelXP Output";
proc print data=sashelp.cars(obs= 20); run;
ods _all_ close;
ods excel file='test_ods_excel.xlsx'
style=title_test
options(
sheet_interval = 'none'
sheet_name='test'
sheet_label = ' '
embedded_titles = 'yes'
suppress_bylines = 'yes'
);
ods escapechar='^';
title1 "Title in ODS Excel Output";
proc print data=sashelp.cars(obs= 20); run;
ods _all_ close;
Why? Is this a known issue? Any solutions?
Many thanks!
What is your SAS version?
SAS Enterprise Guide: 7.11 HF5 (7.100.1.2856) (32-Bit)
SAS Server: 9.04.01 / Linux
Hi:
Posting an updated example. From SAS Tech Support, there is a known defect about this behavior. The workaround is shown below, in a STYLE template change.
cynthia
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.