Multiple dataset into a single excel file

[Noob81]

Hi all ,

Im a new sas user . Using sas eg 7.15 currently . In need for some kind soul to assist.
I have multiple datasets in various process flow . How do i go about exporting these datasets into a single excel file on multiple worksheets.

[Kurt_Bremser]

I would

• use LIBNAME XLSX to create the Excel file on the SAS server
• use PROC COPY or other steps to populate the Excel file with sheets
• clear the LIBNAME
• download the file with the Copy Files task of Enterprise Guide.

Similarly, you can use ODS EXCEL to create the Excel file and use output procedures to populate it. Then again, use Copy Files to download the file.

[Noob81]

Thanks .