topic Re: How to use PROC IMPORT on Excel worksheet whose name begins with a space in SAS Programming

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

PaigeMiller — Fri, 15 May 2015 19:19:28 GMT

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 — Sat, 16 May 2015 07:38:33 GMT

sheet=" AUTOBOND2 RAW$"n ;

OR Try libname statement , my favorite .

Xia Keshan

PaigeMiller — Mon, 18 May 2015 11:50:02 GMT

sheet=" AUTOBOND2 RAW$"n ;

Does not work, same error message

Try libname statement , my favorite .

This works. Thanks!

Ksharp — Mon, 18 May 2015 11:57:23 GMT

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

Maybe it like " AUTOBOND2 RAW $"n

PaigeMiller — Mon, 18 May 2015 12:00:32 GMT

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

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