Modify casstartup_usermods.lua to load cas table automatically from SASHDAT files after restart

[idziemianczyk]

Hi,

I would like to load all cas tables automatically after the Viya restart. Here we can find an example of code we can add to casstartup_usermods.lua

s:table_addCaslib{caslib="worldbank",
     dataSource={srcType="path"},
     path="/rdstore/data/smp/world_bank",
     session=false}

There are 2 questions, any help is appreciated: 

1. I have a simple code in SAS4GL that checks the list of caslibs, then load all SASHDAT tables into memory. Maybe you've already done it before and can share the lua code that checks all the caslibs, then load tables from SASHDAT to cas? It would be much more efficient to load data automatically after restart instead of running SAS4gl code.

2. How can I test the LUA code presented behind? Even for a single table, how I can use s:table_addCaslib in SAS Studio  "proc lua" or command line "lua "? 

[gwootton · Accepted solution]

There are built-in sample jobs for loading and unloading CAS tables that might be helpful here:

CAS Table State Management
https://go.documentation.sas.com/doc/en/calcdc/3.5/caldatamgmtcas/n150v9svjp42ron1hn9r496xj49m.htm

This is the PROC LUA doc on connecting to a CAS session:

LUA Procedure - Example 13: Connecting to the CAS Server
https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/proc/n1t2uas89u3nddn1tajxbv74xj0d.htm

Once you have the connection you could test that table_addCaslib code or any code using CAS actions. More information on using Lua to interact with CAS can be found here:

Getting Started with SAS® Viya® 3.5 for Lua
https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/caspg3lua/titlepage.htm