topic Re: SAS Studio access to tables on server in SAS Viya

SAS Studio access to tables on server

KlemenVrhovec — Tue, 08 Apr 2025 11:07:20 GMT

We have a SAS Viya server. It is already configured and I can see our companies data (sql tables) in SAS Environment Manager under Data -> Data Sources. I can also preview it in Environment manager.

The next step is I want to access this data with SAS code, from SAS Studio. The issue is that inside SAS Studio -> SAS Libreries I only see default libraries. How do I access tables I see in Environment manager?

This is what I see in SAS Studio

And in SAS environment I see cas-shared-default which inclueds multiple tables I want to access through SAS Studio

Re: SAS Studio access to tables on server

DJongman — Mon, 14 Apr 2025 07:53:19 GMT

By default, cas libraries will not be shown. First you will need to set up a cas session.

cas;

(this line creates a cas session named casauto.) Also note that the standard selected cas-library is casuser. You can change this with options and or parameters

The CAS libraries are not yet displayed.
Use the following code to assign all available cas - libraries

caslib _all_ assign;

this line assignes all available cas - libraries

After that, you can load data into cas with proc casutil.

Re: SAS Studio access to tables on server

KlemenVrhovec — Tue, 15 Apr 2025 09:40:40 GMT

Thank you. This is the solution I was searching for