topic Export multiple Data sets to one sheet 1 excel in SAS Programming

Export multiple Data sets to one sheet 1 excel

radha009 — Thu, 12 Apr 2018 18:54:44 GMT

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

kiranv_ — Thu, 12 Apr 2018 19:07:39 GMT

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

AhmedAl_Attar — Thu, 12 Apr 2018 20:03:24 GMT

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

Hope this helps,

Ahmed