Desktop productivity for business analysts and programmers

EG 4.1 Naming sheets when exporting to Excel

Reply
N/A
Posts: 0

EG 4.1 Naming sheets when exporting to Excel

Has anyone had an issue with exporting to Excel and naming the worksheet.

In 9.1 we used the following code:
PROC EXPORT DATA= LIBNAME.CLIENT
OUTFILE= "/u99/sas/testexport.xls"
DBMS=XLS REPLACE;
SHEET="month list";

Enterprise guide doesn't seem to like the Sheet command
Community Manager
Posts: 2,693

Re: EG 4.1 Naming sheets when exporting to Excel

The same code should be runnable from within Enterprise Guide.

But if you are looking to use the point-and-click method of exporting data to Excel from EG, then you are correct -- EG does not currently support an option to name the target sheet.

Chris
Ask a Question
Discussion stats
  • 1 reply
  • 92 views
  • 0 likes
  • 2 in conversation