how import data from access 2010 to sas enterprise miner 12.1

Reply
New Contributor
Posts: 3

how import data from access 2010 to sas enterprise miner 12.1

proc IMPORT out=data

datatable='data'

dbms=access replace;

database='c:\user\database2.accdb';

run;

an error occurred during the execution of this code

I just start my work with SAS and will so appriciate if you could help my to solve this problem)

New Contributor
Posts: 3

Re: how import data from access 2010 to sas enterprise miner 12.1

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

my win 64

Super Contributor
Posts: 490

Re: how import data from access 2010 to sas enterprise miner 12.1

Did you make sure that this is the right dir?

Also what is your sas version and is it 32 or 64?

Valued Guide
Posts: 3,208

Re: how import data from access 2010 to sas enterprise miner 12.1

add to that list of questions on the environment.

Client/Server approach or a standalone desktop version.

When Client/Server the version/type of the SAS/Server process and whether access pcfiles is licensed.

I am guessing it is a Windows server based one.

---->-- ja karman --<-----
New Contributor
Posts: 3

Re: how import data from access 2010 to sas enterprise miner 12.1

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.

There is some special requirements for access files?

Ask a Question
Discussion stats
  • 4 replies
  • 295 views
  • 1 like
  • 3 in conversation