Using Proc Import to read an Excel worksheet with a name that
begins with a space can return the following error:

   ERROR 22-322: Syntax error, expecting one of the following:
   ;, (, DATAFILE, DATATABLE, DBMS, FILE, OUT, REPLACE, TABLE.
   ERROR 76-322: Syntax error, statement will be ignored.

Using the Import Wizard to read the same Excel worksheet results
in the following error:

   ERROR: Prepare: Invalid bracketing of name ' For eloader-sas$'.
   SQL statement: SELECT * FROM ` worksheet name$`
   ERROR: Import unsuccessful.  See SAS Log for details.


This behavior has been identified as a limitation of the
SAS Import Procedure.

Users can use the Libname-Excel engine and refer to the
worksheet names that begin with a space like this:

   libname myxls 'c:\desktop\class.xls';

   data work.test;
     set myxls."' class$'"n; 
   run;

Using RANGE=  instead of SHEET= in the Proc Import code may
also succeed, e.g.

   proc import datafile="c:\test.xls"
     out=test
     range=" name";
     dbms=Excel replace;
     getnames=yes;
   run;

Operating System and Release Information