how to manager CAS tables with public with limited access

[vallsas]

Hi All,

I have a question on the CAS, when we load the data into cas then there are two copies of tables display (one is cas table and .sashdat table) .

in one instance we prepare the data by using prepare data module and then creating new copy which stores in cas.

here the confusion is at first we loaded the table into cas from db, then this table is used in prepare data(for modifications and filters) then we run and save the plan (which creates new table in cas)

Finally 4 tables appear with similar names in cas 1.test (cas) ,test.sashdat (we read/import the data from database)

2.test_1 (save the plan), test_1.sashdat (after filters and conditions apply)

There is confusion to user which table to be use and we see the main source table (database table when we import into cas) also appears and then after preparing the data also one more table save in cas . 

1.Is there any way to hide the tables which is not require to appear to user. ?

also 2.every time is it necessary to have .sashdat table after loading the table in cas?

3.if we save the table in user personal library then how other users can use the cas table?

thanks !!

[gwootton]

It sounds like your questions are surrounding the source table and the in-memory table. More information on this can be found here:

Viya 3.5 Administration - CAS Fundamentals - Data
https://go.documentation.sas.com/doc/en/calcdc/3.5/casfun/n09ssmi0ko8uyfn1022ezo2hv0pm.htm

Caslibs can either be session or globally scoped, and not all users can make a global caslib (one accessible to other users). More information on this can be found here:

Viya 3.5 Administration - CAS Fundamentals - Caslibs
https://go.documentation.sas.com/doc/en/calcdc/3.5/casfun/n1i11h5hggxv65n1m5i4nw9s5cli.htm