SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

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

Reply
Occasional Learner
Posts: 1

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

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!

Super User
Posts: 5,490

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

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.
Data never sleeps
Ask a Question
Discussion stats
  • 1 reply
  • 140 views
  • 0 likes
  • 2 in conversation