topic Re: Lesson 7: Accessing DBMS Data with SAS/ACCESS in SAS Studio

Lesson 7: Accessing DBMS Data with SAS/ACCESS

Varha613 — Thu, 16 Apr 2026 16:58:26 GMT

Hello, I am working on the demo: using an SQL pass-through query from SAS SQL 1:Essentials. But I'm having trouble accessing the results.

proc sql;
connect to pcfiles(path="&path/database/SQL_DB.accdb" dbpassword=sastest);
select * from connection to pcfiles
(select top 10, UserID, Income, State
from customer
order by Income desc);
disconnect from pcfiles;
quit;

Can someone help figure out why this is happening? Please and thank you!

I am doing it on my MacBook, I'm thinking that could be the issue since PCFile isn't on the Mac. Is there any other I can use to complete this lesson?

Re: Lesson 7: Accessing DBMS Data with SAS/ACCESS

LinusH — Fri, 17 Apr 2026 06:31:20 GMT

It's pretty much in the message, you need to specify on which server your SAS PC Files Server is executing.
This information should be documented for your environment.

Re: Lesson 7: Accessing DBMS Data with SAS/ACCESS

Ksharp — Fri, 17 Apr 2026 06:39:31 GMT

You need another option 'server=' to make it work:
connect to pcfiles(path="&path/database/SQL_DB.accdb" dbpassword=sastest server=xxxxxxx);

Or you could try PROC IMPORT + DBMS=ACCESS , since you are trying to read in a ACCESS datafile.