BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
Patrick
Opal | Level 21

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.

1 ACCEPTED SOLUTION

Accepted Solutions
FreelanceReinh
Jade | Level 19

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;

View solution in original post

1 REPLY 1
FreelanceReinh
Jade | Level 19

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;

hackathon24-white-horiz.png

The 2025 SAS Hackathon Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 898 views
  • 2 likes
  • 2 in conversation