How to export all dataset present in work library to an excel file

[Soham0707]

Hello all,

here, i want to export all the dataset from work library to an excel file.

Need code for that.

can anyone help me for this?

Thanks in advance.

[data_null__ · Accepted solution]

PROC COPY

data one two three;
   set sashelp.class;
   run;
libname xl xlsx 'newbook.xlsx';
proc copy in=work out=xl;
   run;
libname xl clear;

[novinosrin]

Guru @data_null__  Very neat. Does that handle exporting to multiple sheets appropriately with the naming convention?

Sorry, I am yet to test that sweet solution. Pardon me.

[data_null__]

Yes in this case there are three sheet tabs named one two three.  

---

@novinosrin wrote:

Guru @data_null__  Very neat. Does that handle exporting to multiple sheets appropriately with the naming convention?

Sorry, I am yet to test that sweet solution. Pardon me.

---

[novinosrin]

Thank you!

[Soham0707]

Thanks for reply.

But i want all the datasets  at once in one excel workbook having multiple sheets (sheets name must be the dataset name).  

[Vince_SAS]

Have you tried the code suggested by @data_null__ ?  I think it does what you ask.

Vince DelGobbo

SAS R&D

[Soham0707]

yes it works

[Soham0707]

Thank you very much data_null_.