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.
Hi @Patrick,
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;
Hi @Patrick,
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;
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.