Lesson 7: Accessing DBMS Data with SAS/ACCESS

[Varha613]

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?

[LinusH]

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.

[Ksharp]

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.