05-15-2015 03:19 PM
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";
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?
05-18-2015 07:50 AM
sheet=" AUTOBOND2 RAW$"n ;
Does not work, same error message
Try libname statement , my favorite .
This works. Thanks!
05-18-2015 07:57 AM
You can open that libname to see what exactly table name it is .
Maybe it like " AUTOBOND2 RAW $"n
05-18-2015 08:00 AM
No, it shows as " AUTOBOND2 RAW$" with no trailing spaces.
Nevertheless, I think the problem has been solved by usingthe libname statement.
Need further help from the community? Please ask a new question.