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;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.