How to use PROC IMPORT on Excel worksheet whose name begins with a space

[PaigeMiller]

The name of the worksheet I would like to import into Excel begins with a space, it actually has two spaces, the name is

' AUTOBOND2 RAW' but there are no quotes in the name, I just put them there so you can see the initial space. But when I try

proc import datafile="myfile.xlsx" out=AUTOBOND2 dbms=excel replace;

  sheet=" AUTOBOND2 RAW";

  run;

Produces the error in the LOG

ERROR: Prepare: Invalid bracketing of name ' AUTOBOND2 RAW$'.

SQL statement: SELECT * FROM ` AUTOBOND2 RAW$`

ERROR: Import unsuccessful.  See SAS Log for details.

How do I read this worksheet?

[Ksharp · Accepted solution]

sheet=" AUTOBOND2 RAW$"n ;

OR Try libname statement , my favorite .

Xia Keshan

[PaigeMiller]

sheet=" AUTOBOND2 RAW$"n ;

Does not work, same error message

Try libname statement , my favorite .

This works. Thanks!

[Ksharp]

You can open that libname to see what exactly table name it is .

Maybe it like " AUTOBOND2 RAW                            $"n

[PaigeMiller]

No, it shows as " AUTOBOND2 RAW$" with no trailing spaces.

Nevertheless, I think the problem has been solved by usingthe libname statement.