topic Re: How to export all dataset present in work library to an excel file in SAS Programming

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

Soham0707 — Wed, 25 Sep 2019 12:33:49 GMT

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.

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

data_null__ — Wed, 25 Sep 2019 13:00:33 GMT

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;

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

novinosrin — Wed, 25 Sep 2019 13:05:32 GMT

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.

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

data_null__ — Wed, 25 Sep 2019 13:18:49 GMT

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.

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

novinosrin — Wed, 25 Sep 2019 13:20:44 GMT

Thank you!

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

Soham0707 — Thu, 26 Sep 2019 09:48:12 GMT

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).

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

Vince_SAS — Thu, 26 Sep 2019 11:49:02 GMT

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

Vince DelGobbo

SAS R&D

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

Soham0707 — Thu, 26 Sep 2019 12:09:17 GMT

yes it works

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

Soham0707 — Thu, 26 Sep 2019 12:10:23 GMT

Thank you very much data_null_.