DATA Step, Macro, Functions and more

Export tables down each other and side by side to same excel file and same sheet

Reply
Frequent Contributor
Posts: 95

Export tables down each other and side by side to same excel file and same sheet

I have 3 macros.
Each macro create mutiple output tables.
I want that all output tables will go to same excel file and same sheet.

I want that tables created by macro1 will be down each other.


I want that tables created by macro2 will be down each other but on side of tables created by macro1

I want that tables created by macro3 will be down each other but on side of tables created by macro2


Can anyone send please an example to code for that request?





Super User
Posts: 9,618

Re: Export tables down each other and side by side to same excel file and same sheet

Have you tried the suggestions given to you in https://communities.sas.com/t5/ODS-and-Base-Reporting/export-multiple-tables-to-one-excel-file-with-...?

 

One option I can think of is to use ODS HTML and create a wrapper table.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Ask a Question
Discussion stats
  • 1 reply
  • 94 views
  • 0 likes
  • 2 in conversation