BookmarkSubscribeRSS Feed
deleted_user
Not applicable
I'm trying to use Proc Import to read an XLSX file into a SAS file, but I'm getting an error message:


16 proc import out=R110035.ssns_provided
17 datafile = 'S:\Requests\2011 Requests\1101\R110035\Misc\From Client.xlsx'
18 dbms = EXCEL replace;
19 run;

ERROR: Unable to open file S:\Requests\2011 Requests\1101\R110035\Misc\From Client.xlsx. It
does not exist or it is already opened exclusively by another user, or you need
permission to view its data.

Am I using the right DBMS option? Is there some other problem?
Thanks,
Jeff
3 REPLIES 3
CurtisMack
Fluorite | Level 6
Do have the file open in Excel? That can cause this error.
Cynthia_sas
SAS Super FREQ
Also, these notes are relevant:
http://support.sas.com/kb/32/455.html
http://support.sas.com/kb/38/535.html
http://support.sas.com/kb/32/862.html

And this documentation shows which versions of Excel can be read with which versions of SAS on various platforms (32 bit vs 64 bit):
http://support.sas.com/documentation/cdl/en/acpcref/63184/HTML/default/viewer.htm#a003094743.htm

cynthia
Ksharp
Super User
Hi.
proc import is not supported the XLSX file which is file above Office2007.
If you want to import these files , one way is to use ' libname ' statement.

[pre]
libname exce excel 'c:\temp\from.xlsx';
proc sql ;
create table r11 as
select *
from exce.sheet1;
quit;
[/pre]


Not tested code.


Ksharp

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 15136 views
  • 1 like
  • 4 in conversation