I have a question regarding the table scope in SAS Viya. In the documentation it can be seen that the In-Memory duration for a global table is long and available for all sessions and that the In-Memory duration for a Session table is medium and only for the current session.
It can be read that: "By default, when you load a table into memory, the table has session scope."
When I, for example, import a .xlsx file to a table in a CAS In Memory library, the table remains in memory even when my session ends or when I logout from SAS Viya. I would have expected that the table was dropped from memory when my session ended.
1) Can anyone explain why the table remains in memory after my session ends?
2) Is it possible to manipulate more specifically how long a table stays in memory? For example, if the data is not used for 3 weeks it should be dropped from memory.
I'm relatively new to SAS Viya so I still have a lot to learn.
Thanks,
Berry H.
... View more