Learning SAS? Welcome to the exclusive online community for all SAS learners.

Error message when I using proc sql procdure

Reply
Learner
Posts: 1

Error message when I using proc sql procdure

I try to run following statement in SAS University Edition

proc sql;
      connect to access (path = "/folders/myfolders/IMPLAN_WA/WA_1 .mdb");
      create table WA_tio1 as
         select * from connection to access (select * from RegionalIndustryBalances);
However, following error meaasages are appeared

Error Message:
 ERROR: Cannot find ACCESS engine.
 ERROR: A Connection to the access DBMS is not currently supported, or is not installed at your site.

How can I fixed this error messages?

Super User
Posts: 17,829

Re: Error message when I using proc sql procdure

I don't think SAS UE supports Access DBs Smiley Sad

Ask a Question
Discussion stats
  • 1 reply
  • 225 views
  • 0 likes
  • 2 in conversation