ODS tagsets.excelxp title

[JianShen]

Hi all,

I have a question regarding titles in ODS tagsets.excelxp. In my department, we want to export multiple tables to excel. Because we have over 10 tables with different lay-outs and titles, we first create the tables. Then we use %include in combination with ODS to export the tables. To give a short overview, the programs use the following format

program1:

title1 "this is a title";

proc report;

column var1

define column1 / group;

rbreak after / summarize;

run;

title;

program2:

ods tagsets.excelxp path="c:\reports\" file="new_file.xml" options(sheet_interval="PROC");

%include "c:\&path_to_program\program1.sas";

ods tagsets.excelxp close;

The programs are mostly doing what is expected, except for the title. It seems like ODS isn't adding the title we have in program 1 to the output. We already tried using both embed_titles=yes and embed_titles_once=yes, but the title still doesn't show up. Therefore, we're wondering if we are missing something or if we have to add the titles in ODS itself, rather than the %include program1.

Any tips or suggestions would be greatly helpful!

[JianShen · Accepted solution]

I figured out it was us using the wrong name for the embed option. We kept using embed_titles='yes' instead of embedded_titles='yes'.