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;
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;
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;
Hi, did you look at ... http://support.sas.com/kb/43/933.html ?
Ok, this worked. However, I want to use PROC IMPORT because I have several files to import and I plan to use a macro.
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?
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.
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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: