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!
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'.
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'.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: