Promoting CAS Tables: Understanding Scope and Avoiding the "Table not found" Error

In SAS^© Viya^™, sharing data between users is based on a key concept: promotion. A table loaded into memory is by default visible only to you (Session Scope). To make it public, you must promote it (Global Scope).

However, it often happens that the promote statement fails with a frustrating message: ERROR: There is no session-scope table X in caslib Public...

Yet, you are sure you loaded this table! Let's analyze why this happens and how to solve it properly with CASL.

The Problem: "Session Scope" vs. "Global Scope"

The error usually occurs due to confusion about the lifespan of a CAS session.

Look at this typical failing scenario:

1. You load a table MyTable in a session (let's say Session A).

2. You run a new script starting with cas MySession;.

3. You attempt to promote MyTable.

Why does it crash? The cas MySession; statement often starts a new session (Session B). Session B is completely isolated from Session A. It cannot "see" MyTable which is in the memory of Session A. For promote, the table simply does not exist.

The Robust Solution: Do Everything in CASL

Rather than using PROC CASUTIL sequentially (which can hide session changes), the recommended approach by experts (like SASJedi) is to use a PROC CAS block. This allows managing the deletion of the old global version and the promotion of the new one in a single logical transaction.

Furthermore, depending on your Viya^™ version, the action to use differs slightly to copy and promote a table simultaneously (for example, to rename it in the process).