SAS Studio access to tables on server

[KlemenVrhovec]

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

[DJongman · Accepted solution]

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.

[KlemenVrhovec]

Thank you. This is the solution I was searching for