A simplified version of my code is as follows: /* Escapechar is ^ */ ods excel options (sheet_name="&table" sheet_interval="none" embedded_titles='yes'); title1 "&title"; proc report data=pk3 nowd missing split='@'; col subjectid ('Nominal time post-dose (h)' tp0 'tp0.5'n tp1 tp2 tp3 tp4 tp5 tp8) result_min result_max t_max auc_sum; define subjectid / 'Subject ID' order; define result_min / "C^{sub min}@(ng/mL)"; define result_max / "C^{sub max}@(ng/mL)"; define t_max / "t^{sub max}@(h)"; define auc_sum / "AUC^{sub 0-8}@(h&dot.ng/mL)"; run; The header in the output shows: Subject ID 0 0.5 1 2 3 4 5 8 Cmin(ng/mL) Cmax(ng/mL) tmax(h) AUC0-8(h▪ng/mL) Split character is being ignored. I have seen in the post below that this is a known issue. https://communities.sas.com/t5/ODS-and-Base-Reporting/Line-not-wrapping-in-ODS-Excel/m-p/324326/highlight/true#M17722 Is there a work around? I've tried ^{newline}, inserting '0A'x to no avail. Is there RAW code as in RTF that I could insert for Excel to render? Thanks in advance Bruce Kayton
... View more