Export multiple Data sets to one sheet 1 excel

[radha009]

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

[kiranv_]

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

[AhmedAl_Attar]

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