How to assign CASLIB to the new local library(New library isn't CAS library)

[jitendra_patil]

Hi All,

I have created CAS library ie. "XYZ" in SAS Viya 3.4 version through Prepare Data component. I want to assign this library to the new local library using Develop SAS Code component. Can anyone suggest the way how it can be done?

Much appreciate.

Thanks,

G2

[MarkBodt_NZ]

So I interpret the question as: You've got some data in a CAS lib that you can see in SAS Viya.

You now want to use SAS Studio ("Develop SAS Code") to access the data in that CAS Library.

That's quite easy:

You need to use a libname statement using the CAS engine like this:

* here, abc is the libref, cas is the CAS engine and you specify the library name (exactly as defined in CAS) in caslib=;

Libname abc cas caslib='XYZ';

*the following will list the tables that are in the CAS library

proc datasets lib=abc;

quit;

*assuming you have a table called sales in the caslib, then you can use it in code like this:

data MaySales;

 set abc.sales;

 where Month='May';

run;

I've made some assumptions with the above code, particularly the libname statement. I assume that you are using SAS StudioV that is in the same environment as SAS Viya. That way you don't have to specify CAS connection information.

If you are using SASStudio or other SAS Coding tools like Enterprise Guide that are separate from the SAS Viya environment then you will have to specify the cashost, port and maybe authentication.

HTH

Mark