Dear Friends
I am trying to use several methods to import an xls file using sas code in SAS Enterprise Guide
And each yields errors .
The source file is located on a local file system.
I can import the file successfully using the SAS enterprise guide import task..
Your help is appreciated.
First Method : Proc Import
proc import
datafile= 'u:\testfile.xls'
dbms=excel
out=work.out
replace;
run;
The error I get:
ERROR: Unable to open file u:\testfile.xls. It does not exist or it is already opened exclusively by another user, or you need
permission to view its data.
Method 2 Using LibName Statement
libname myxls "u:\TestFile.xls";
The error I get
ERROR: Connect: Class not registered
ERROR: Error in the LIBNAME statement.
As you can see from many other questions in htis forum, it's a common misunderstanding that your local file system is available for your SAS code. It's available in the import tasks. SAS code is executed on your SAS Workspace server, so the given file path needs to be available from there.
Thank you very much - i didn't know that.
Rafael
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.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.