Help using Base SAS procedures

Proc Import from Access not working in SAS Studio

Reply
New Contributor
Posts: 2

Proc Import from Access not working in SAS Studio

I am trying to run the following code to pull a table from Access:

 

proc import table="qryManualRaps"
dbms=access
datatable="Z:\HCCRAPS\ChartReviews\ChartReviews - MASTER - Copy.accdb"
out = manualraps;
run;

 

I get the following error:

ERROR: Unable to open file . It does not exist or it is already opened exclusively by another user, or you need permission to view
its data.
 
The file is not open and I have permission to view this file.  Any suggestions?
Super User
Posts: 3,260

Re: Proc Import from Access not working in SAS Studio

The most likely cause is that your SAS server session, run from SAS Studio, cannot resolve the path Z:\ etc. Is the Z drive/mapping on your SAS server or somewhere else?

Super User
Posts: 19,855

Re: Proc Import from Access not working in SAS Studio

Are you using SAS UE?
Ask a Question
Discussion stats
  • 2 replies
  • 241 views
  • 0 likes
  • 3 in conversation