DATA Step, Macro, Functions and more

PROC IMPORT problems using 64 bit platform

Reply
Super Contributor
Posts: 279

PROC IMPORT problems using 64 bit platform

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;

Valued Guide
Posts: 765

Re: PROC IMPORT problems using 64 bit platform

[ Edited ]

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;

Super Contributor
Posts: 279

Re: PROC IMPORT problems using 64 bit platform

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;

 

Valued Guide
Posts: 765

Re: PROC IMPORT problems using 64 bit platform

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

Super Contributor
Posts: 279

Re: PROC IMPORT problems using 64 bit platform

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

Super User
Posts: 3,256

Re: PROC IMPORT problems using 64 bit platform

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?

Valued Guide
Posts: 765

Re: PROC IMPORT problems using 64 bit platform

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.

 

Super Contributor
Posts: 279

Re: PROC IMPORT problems using 64 bit platform

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;

Ask a Question
Discussion stats
  • 7 replies
  • 289 views
  • 1 like
  • 3 in conversation