topic Re: Exporting the SAS Datasets into Excel with multiple sheets in SAS Enterprise Guide

Exporting the SAS Datasets into Excel with multiple sheets

THALLA_REDDY — Wed, 17 Feb 2021 06:41:29 GMT

Hi Team,

I am using SAS Enterprise Guide 8.3 and will be querying data into multiple datasets. Now I want to export all the datasets into Single Excel file with multiple sheets.

Can anyone help me with this requirements ?

thanks in advance

Thalla

Re: Exporting the SAS Datasets into Excel with multiple sheets

PeterClemmensen — Wed, 17 Feb 2021 06:43:02 GMT

How do you split the data into multiple data sets?

Re: Exporting the SAS Datasets into Excel with multiple sheets

Ksharp — Wed, 17 Feb 2021 11:51:30 GMT

libname x xlsx 'c:\temp\x.xlsx';
proc copy in=work out=x;
select a b c d ;
run;

Re: Exporting the SAS Datasets into Excel with multiple sheets

THALLA_REDDY — Thu, 18 Feb 2021 08:50:34 GMT

using DATA Steps

Re: Exporting the SAS Datasets into Excel with multiple sheets

Sajid01 — Mon, 22 Mar 2021 00:45:28 GMT

Thanks @Ksharp for the simple and elegant example