How to control new sheets with ODS Excel in Data Integration Studio

[yus03590]

Hi.  I'm sorry if this question is in the wrong area, there was no location for Data Integration Studio.  Anyway, I'm trying to output two tables using proc tabulate and list, with proc ods text being used before each to supply a title.  I want the first sheet to have the first title then the first table, and the second sheet to have the second title and second table, as follows.  

The control flow is data -> Extraction -> Open ODS Destination -> Proc Tabulate -> Proc Print -> Email and close ODS destination

Title

Table

-new sheet-

Title

Table

Much thanks!

[LinusH]

Well this is the correct area for DI Studio questions.
But about your question. I'm not an ODS expert so I can't help with your exact requirement.
But it seems you are trying to use DI Studio as a report generator, or? I would try to keep DIS doing only ETL stuff, and leave reporting to other tools.
That said, you can export to Excel in several ways in a more ETL like fashion, including LIBNAME EXCEL engine and PROC EXPORT.