https://communities.sas.com/t5/SAS-Enterprise-Guide/EG-4-1-Naming-sheets-when-exporting-to-Excel/m-p/3792#M1224 Has anyone had an issue with exporting to Excel and naming the worksheet.<BR /> <BR /> In 9.1 we used the following code:<BR /> PROC EXPORT DATA= LIBNAME.CLIENT<BR /> OUTFILE= "/u99/sas/testexport.xls"<BR /> DBMS=XLS REPLACE;<BR /> SHEET="month list"; <BR /> <BR /> Enterprise guide doesn't seem to like the Sheet command Thu, 12 Jul 2007 19:15:04 GMT deleted_user 2007-07-12T19:15:04Z https://communities.sas.com/t5/SAS-Enterprise-Guide/EG-4-1-Naming-sheets-when-exporting-to-Excel/m-p/3792#M1224 Has anyone had an issue with exporting to Excel and naming the worksheet.<BR /> <BR /> In 9.1 we used the following code:<BR /> PROC EXPORT DATA= LIBNAME.CLIENT<BR /> OUTFILE= "/u99/sas/testexport.xls"<BR /> DBMS=XLS REPLACE;<BR /> SHEET="month list"; <BR /> <BR /> Enterprise guide doesn't seem to like the Sheet command Thu, 12 Jul 2007 19:15:04 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/EG-4-1-Naming-sheets-when-exporting-to-Excel/m-p/3792#M1224 deleted_user 2007-07-12T19:15:04Z https://communities.sas.com/t5/SAS-Enterprise-Guide/EG-4-1-Naming-sheets-when-exporting-to-Excel/m-p/3793#M1225 The same code should be runnable from within Enterprise Guide.<BR /> <BR /> 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.<BR /> <BR /> Chris Mon, 30 Jul 2007 17:06:41 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/EG-4-1-Naming-sheets-when-exporting-to-Excel/m-p/3793#M1225 ChrisHemedinger 2007-07-30T17:06:41Z