ods text and embedded_titles (ods excel)

xxformat_com — Sat, 30 Oct 2021 08:04:54 GMT

Hi,

I was doing some testing to figure out when to use flow='text' (I'll write a separate post on the topic)

but I was surprised to see that embedded titles are removed when ods text is used.

Here is the code. Activate the ods text statement to see the difference.

ods excel file="&xxtest./reporting/ods_excel_test.xlsx" 
          options(embedded_titles='on');

*ods text ='This is a first example of a long string';

title 'This is a test';
proc print data=sashelp.class;
    var name age;
run;

ods text ='This is a first example of a long string';

ods excel close;

Is this something you would expect?

topic ods text and embedded_titles (ods excel) in ODS and Base Reporting

ods text and embedded_titles (ods excel)