You can use the ODS Inline formatting functions to do this. Unfortunately the ODS EXCEL destination does not seem to honor this, please contact technical support. See the code below for an example. It works allright for PDF and HTML and tagsets.excelxp.
ods escapechar="~";
data reportData;
set sashelp.class;
length newColumn newcolum2 $ 64;
newColumn = cats(
"~{style [font_weight=bold]", name, "}"
, "~{newline}"
, catx(" ", age, sex)
);
newColum2 = catx("~{newline}", name, sex, age);
run;
ods excel file="c:\temp\sample.xlsx";
ods pdf file="c:\temp\sample.pdf";
ods tagsets.excelxp file="c:\temp\sample.xml";
proc print data=reportData;
run;
ods tagsets.excelxp close;
ods pdf close;
ods excel close;
... View more
