topic Re: Renaming worksheets when using libname statement for creating Excel files in Microsoft Integration with SAS

Renaming worksheets when using libname statement for creating Excel files

Helle — Wed, 14 Jul 2010 12:18:07 GMT

Hi,

I would like to rename the individual worksheets when creating Excel files using the libname statement so that the name of the sheet does not have to be equal to the name of the dataset. Is there an option similar to the sheet='YY' option in PROC Export?

Here's a code sample:

libname outxls excel 'H:\HLI\example_out2.xls' ;
data outxls.report_2009 (dblabel=yes);
set sasuser.report_2009;
run;
LIBNAME outxls CLEAR;

Thanks,

Helle

Re: Renaming worksheets when using libname statement for creating Excel files

Cynthia_sas — Thu, 15 Jul 2010 03:47:00 GMT

Hi:
If you did this:
[pre]
libname outxls excel 'H:\HLI\example_out2.xls' ;

data outxls.wombat (dblabel=yes);
set sasuser.report_2009;
run;

LIBNAME outxls CLEAR;
[/pre]

Then the name of the sheet would be 'wombat'....there is no sheet= option such as that used with PROC EXPORT.

cynthia

Re: Renaming worksheets when using libname statement for creating Excel files

Helle — Thu, 15 Jul 2010 07:48:52 GMT

Hi Cynthia,

Thanks for bringing this very obvious solution to my attention 🙂

Helle