topic Re: Pass-through facility SQL access in SAS Programming

Pass-through facility SQL access

KarimTassine — Mon, 13 Jul 2020 14:09:29 GMT

Hello everyone!

I am trying to connect my database in SAS studio using an sql pass-through facility.

But everytime i run the program, i get this error :

ERROR: The SERVER= option is required for establishing a connection through the SAS/ACCESS Interface to PC Files.

NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.

So, i am wondering if this issue is only on SAS studio and SAS Academic Edition!

Thank you.

Re: Pass-through facility SQL access

ballardw — Mon, 13 Jul 2020 16:50:14 GMT

You may get a better response showing the actual code submitted.

And which SQL source you want to connect to.

Re: Pass-through facility SQL access

KarimTassine — Mon, 13 Jul 2020 17:35:43 GMT

Thanks for reply.

this is a part of the code :

proc sql;
connect to pcfiles(path="&path\database\all.accdb"
dbpassword=sastest);
select DEALID, Duration, Score, Decision
from connection to pcfiles
(select top 10, DEALID, Duration, Score, Decision
from clients
where score is not null
order by score desc);
disconnect from pcfiles;
quit;

Re: Pass-through facility SQL access

AnandVyas — Tue, 14 Jul 2020 03:15:00 GMT

If you are trying this on SAS University Edition PCFILES server not supported. See the link below:
https://communities.sas.com/t5/SAS-Programming/pcfiles-serverr-with-SAS-University-Edition/td-p/244098