topic Re: Proc Import from Access not working in SAS Studio in SAS Procedures

Proc Import from Access not working in SAS Studio

kflanary — Mon, 30 Nov 2015 23:16:27 GMT

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?

Re: Proc Import from Access not working in SAS Studio

SASKiwi — Mon, 30 Nov 2015 23:39:05 GMT

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?

Re: Proc Import from Access not working in SAS Studio

Reeza — Mon, 30 Nov 2015 23:45:06 GMT

Are you using SAS UE?