Hi,
I want to do a check if an in-memory table in Viya has an error, before saving another table.
IF the in-memory table has an error THEN I need to drop and reload several tables.
ELSE save tables to sashdat files.
Does anyone know if there is an easy way of testing this in the CAS code. Or maybe in a job/flow scheduling?
I’m working in Viya 3.5.
Some background on why I need this:
I have three tables containing final results, and one table containing unique keys and a column with a flag that controls which keys to analyze (either “completed” or “toRun”). The flag is temporarily updated in the in-memory table in the CAS code, and if the final tables have errors on the in-memory table, I want to drop this table and reload to get the original status of the flag to analyze those keys again.
When I just run a save without checking, I risk that some of the tables are saved and some not.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.