topic Re: PROC IMPORT problems using 64 bit platform in SAS Programming

PROC IMPORT problems using 64 bit platform

GreggB — Mon, 19 Oct 2015 16:50:03 GMT

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;

Re: PROC IMPORT problems using 64 bit platform

MikeZdeb — Mon, 19 Oct 2015 17:05:41 GMT

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.xlsb';

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;

Re: PROC IMPORT problems using 64 bit platform

GreggB — Mon, 19 Oct 2015 17:09:41 GMT

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;

Re: PROC IMPORT problems using 64 bit platform

MikeZdeb — Mon, 19 Oct 2015 17:18:41 GMT

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

Re: PROC IMPORT problems using 64 bit platform

GreggB — Mon, 19 Oct 2015 17:24:17 GMT

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

Re: PROC IMPORT problems using 64 bit platform

SASKiwi — Mon, 19 Oct 2015 18:31:01 GMT

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?

Re: PROC IMPORT problems using 64 bit platform

MikeZdeb — Mon, 19 Oct 2015 18:40:04 GMT

Hi ... could you try ...

libname x pcfiles 'G:\Departments\Research\SpecialServices\1516\nes.xlsb';

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.

Re: PROC IMPORT problems using 64 bit platform

GreggB — Tue, 20 Oct 2015 18:57:14 GMT

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;