topic Multiple dataset into a single excel file in SAS Enterprise Guide

Multiple dataset into a single excel file

Noob81 — Wed, 28 Apr 2021 04:53:27 GMT

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.

Re: Multiple dataset into a single excel file

Kurt_Bremser — Wed, 28 Apr 2021 07:10:47 GMT

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.

Re: Multiple dataset into a single excel file

Noob81 — Wed, 05 May 2021 16:42:54 GMT

Thanks .