How to test in code if an in-memory table in Viya has an error before saving

anetteostbo — Mon, 12 Sep 2022 10:35:08 GMT

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.

Re: How to test in code if an in-memory table in Viya has an error before saving

smm662002 — Thu, 06 Oct 2022 19:27:22 GMT

Hi,

Would it be possible to clarify what type of error are you trying to test?
Can your error be an unexpected value in a table or a table coruption?

Regards,
Smm662002

topic Re: How to test in code if an in-memory table in Viya has an error before saving in SAS Programming

How to test in code if an in-memory table in Viya has an error before saving

Re: How to test in code if an in-memory table in Viya has an error before saving