BookmarkSubscribeRSS Feed
srinu99
Fluorite | Level 6

proc import table='visit_bk' out=one dbms=access replace;
database='‪C:\Users\chandra\Desktop\DATA.mdb';
run;

                   run this program i had got an error like below,

    ERROR: Unable to open file ?C:\Users\chandra\Desktop\DATA.mdb. It does not exist or it is already
opened exclusively by another user, or you need permission to view its data.

   it is run on sas 9.4 version on windows 10 os.

plz solve my problem.

2 REPLIES 2
Reeza
Super User

Make sure your path to the file is correct and that SAS can access that location. If you're using SAS EG on a server for example it may not have access to your local drive.

 

On Windows you can find the exact path by finding the file, holding down SHIFT and RIGHT CLICK. There will be an option called Copy as Path, and this will give you the full path. Make sure that no one is using the file when you try to import.

ballardw
Super User

Another potential issue is that you are running in a server enviroment and the path "C:\users\chandra..." and the SERVER does not have that path and likely does not see your local drive at all. If this is the case you may need to use a different approach or find a location such as a shared network drive that the server can read from.

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
  • 2 replies
  • 1521 views
  • 0 likes
  • 3 in conversation