topic Re: How to import an excel file with worksheet name starting with number in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-import-an-excel-file-with-worksheet-name-starting-with/m-p/133623#M10834 <HTML><HEAD></HEAD><BODY><P>The sheet parameter is usually quoted, and you have to give it a valid SAS name.&nbsp; </P></BODY></HTML> Wed, 06 Nov 2013 21:00:16 GMT Reeza 2013-11-06T21:00:16Z How to import an excel file with worksheet name starting with number https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-import-an-excel-file-with-worksheet-name-starting-with/m-p/133622#M10833 <HTML><HEAD></HEAD><BODY><P>I am currently using the below code to import a worksheet from an excel workbook. Unable to import where the worksheet name begins with a number. Proc IMPORT OUT= Test1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DATAFILE= "/sas/data_20131101_130401.xls"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DBMS=xls REPLACE;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sheet = 7061_newdata;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; GETNAMES=YES; MIXED=YES; run; Please advise. Thanks Raj</P></BODY></HTML> Wed, 06 Nov 2013 20:59:04 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-import-an-excel-file-with-worksheet-name-starting-with/m-p/133622#M10833 Rish 2013-11-06T20:59:04Z Re: How to import an excel file with worksheet name starting with number https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-import-an-excel-file-with-worksheet-name-starting-with/m-p/133623#M10834 <HTML><HEAD></HEAD><BODY><P>The sheet parameter is usually quoted, and you have to give it a valid SAS name.&nbsp; </P></BODY></HTML> Wed, 06 Nov 2013 21:00:16 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-import-an-excel-file-with-worksheet-name-starting-with/m-p/133623#M10834 Reeza 2013-11-06T21:00:16Z Re: How to import an excel file with worksheet name starting with number https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-import-an-excel-file-with-worksheet-name-starting-with/m-p/133624#M10835 <HTML><HEAD></HEAD><BODY><P>Reeza, Thank you!</P></BODY></HTML> Wed, 06 Nov 2013 21:04:25 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-import-an-excel-file-with-worksheet-name-starting-with/m-p/133624#M10835 Rish 2013-11-06T21:04:25Z