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;

SAS INNOVATE 2024

Innovate_SAS_Blue.png

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. 

Register now!

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.

Get the $99 certification deal.jpg

 

 

Back in the Classroom!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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