About jaxdaxter

jaxdaxter · ‎06-13-2023

I've simplified to what I want the table to look like. Basically a SAS program is running which is processing tables in sequence and I want a table giving a running commentary on the tables status. This program runs at set times. So for example it will run, process 2 tables, stop. Then the next day it will run and process 1 table. For example it may look like this table_name status table_1 success table_2 success table_3 success table_4 error If the program errors I would like to update this control table to say that the status of the table is errored. It's required basically because that's what the end user wants.

jaxdaxter · ‎06-13-2023

I am trying to write some code which when the process errors a control table will be updated with certain values. For the moment I have the following but gives a warning creating a work table called error_table and a column called status but no values. I have simplified the table I'm trying to create. %macro error_check; %if &syserr > 0 %then %do; %put This process has errored with the following message: &syserrortext; %put Writing out status "error" to control table; data error_table; status = error; run; %end; %else %do; %put it is fine; %end; %mend; Unfortunately I can't seem to get the code working. This is the first time I've used the &syserr macro so I'm wondering if I'm using it wrong should be using some other method. Thanks for any help one can give.

Online Status	Offline
Date Last Visited	‎06-13-2023 03:52 PM

Re: Is there a way to use SAS error handling to write to/create a tabl...

Is there a way to use SAS error handling to write to/create a table

Re: Is there a way to use SAS error handling to write to/create a tabl...

Is there a way to use SAS error handling to write to/create a table