Exporting the SAS Datasets into Excel with multiple sheets

[THALLA_REDDY]

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

[PeterClemmensen]

How do you split the data into multiple data sets?

[THALLA_REDDY]

using DATA Steps

[Ksharp]

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

[Sajid01]

Thanks @Ksharp for the simple and elegant example