Proc FedSQL: Error with very simple syntax

Patrick — Sat, 16 Sep 2023 11:00:48 GMT

Hi all,

I'm trying to write some code under SAS9.4 M7 that will be easily migratable to running under Viya 4 and in CAS.

I've just started my journey to get a bit more seriously into Viya so assume that I'm rather novice and can miss "the basics".

My current environment is:

X64_10PRO WIN 10.0.19041 Workstation

9.04.01M7P080520

When I run below super simple code I'm getting an error but I don't understand what I'm missing.

proc fedsql;
  select * from sashelp.class
  ;
quit;

ERROR: Table "SASHELP.CLASS" does not exist or cannot be accessed
ERROR: BASE driver, schema name SASHELP was not found for this connection

I didn't see in the Docu that Proc FedSQL is Viya only so not sure what I'm missing.

I also couldn't find in the docu if/where I would have to define the missing connection as the error message indicates.

Re: Proc FedSQL: Error with very simple syntax

FreelanceReinh — Sat, 16 Sep 2023 12:41:05 GMT

What a coincidence! Yesterday I came across these error messages for the first time while trying to help in the thread Hash object in proc DS2.

Result: PROC DS2 -- and apparently PROC FedSQL as well -- cannot work with concatenated libraries such as SASHELP. For DS2 this is documented in Usage Note 51043: Librefs with concatenated libraries are not supported in DS2 (which I found thanks to this 2016 post).

Your code works with a libref pointing to a simple permanent library (or WORK, if applicable).

Example (Windows):

libname lib 'C:\Program Files\SASHome\SASFoundation\9.4\core\sashelp' access=readonly;

proc fedsql;
  select * from lib.class
  ;
quit;