PROC IMPORT problems using 64 bit platform

[GreggB]

My new machine is running Windows 8.1 64 bit with Office 13 32bit software. I thought I had this licked, but am having more problems.  my file does exist.  I've checked the path and it's correct.  No one else has it opened.

My error in the log:

ERROR: Unable to open file G:\Departments\Research\SpecialServices\1516\nes.xlsb. It does not
exist or it is already opened exclusively by another user, or you need permission to view its data.

Code I'm using:

proc import datafile='G:\Departments\Research\SpecialServices\1516\nes.xlsb' out=one
replace
dbms=excelcs;
run;

[MikeZdeb]

Hi, have you tried the data step approach (I use it on a 64-bit PC, Windows 7, 32-bit Office)  ...

libname x 'G:\Departments\Research\SpecialServices\1516\nes.x​lsb';
 
data one;

* name of worksheet within xlsb file enclosed in quotes with an extra '$', and that 'n';
set x.'sheet1$'n ;
run;
 
libname x clear;

[GreggB]

no luck.

279 libname x 'G:\Departments\Research\SpecialServices\1516\nes.xlsb';
ERROR: Connect: Class not registered
ERROR: Error in the LIBNAME statement.
280
281 data one;
282 * name of worksheet within xlsb file enclosed in quotes with an extra '$', and that 'n';
283 set x.'sheet1$'n ;
ERROR: Libref X is not assigned.
284 run;

[MikeZdeb]

Hi, did you look at ... http://support.sas.com/kb/43/933.html ?

Usage Note 43933: "Connection Failed" and "Connect: Class not registered" errors occur when using the Import Wizard with SAS® 9.3 on Windows X64 systems

[GreggB]

Ok, this worked.  However, I want to use PROC IMPORT because I have several files to import and I plan to use a macro.

[SASKiwi]

Your IMPORT code using EXCELCS indicates you are using the SAS PC File Server. Where is this running? Could it be that it doesn't have the G drive mapping?

[MikeZdeb]

Hi ... could you try ...

libname x pcfiles 'G:\Departments\Research\SpecialServices\1516\ne​s.x​lsb';
 
data one;

* name of worksheet within xlsb file enclosed in quotes with an extra '$', and that 'n';
set x.'sheet1$'n ;
run;
 
libname x clear;

from ... http://wuss.org/Proceedings13/82_Paper.pdf

It’s not the Yellow Brick Road but the SAS PC FILES SERVER® will take you Down the LIBNAME PATH= to Using the 64-Bit Excel Workbooks.

[GreggB]

No luck.

1    libname x pcfiles 'G:\Departments\Research\SpecialServices\1516\nes.xlsb';
ERROR: Incorrect syntax for this LIBNAME statement. This engine does not accept a physical name.
ERROR: Error in the LIBNAME statement.
2
3    data one;
4    * name of worksheet within xlsb file enclosed in quotes with an extra '$', and that 'n';
5    set x.'sheet1$'n ;
ERROR: Libref X is not assigned.
6    run;