DATA Step, Macro, Functions and more

Export multiple Data sets to one sheet 1 excel

Reply
Contributor
Posts: 65

Export multiple Data sets to one sheet 1 excel

i have multiple data sets (4 sas tables) want to export to excel in one sheet.

PROC Star
Posts: 499

Re: Export multiple Data sets to one sheet 1 excel

you mean to  say appended data of 4 datasets. Then append the data in SAS and then use proc export

Super Contributor
Posts: 270

Re: Export multiple Data sets to one sheet 1 excel

You don't have to concatenate the data sets in SAS before exporting to Excel!

 

You can use ODS EXCEL destination and export multiple objetcs (data sets, charts) to a single sheet using the following examples here

- Adding Multiple Tables or Graphs on a Page

- Add multiple tables and graphs to each worksheet using the ODS Destination for Excel

 

Hope this helps,

Ahmed

Ask a Question
Discussion stats
  • 2 replies
  • 77 views
  • 3 likes
  • 3 in conversation