topic Re: Creating a SAS Dataset basis SAS code run result in SAS Programming

Creating a SAS Dataset basis SAS code run result

SAS_L — Sun, 06 Oct 2019 21:09:46 GMT

Hello Community,

I am looking for some ideas here.

I have a requirement wherein I have to create a log dataset containing 2 variables Error text and Error Timestamp. I want to populate this dataset anytime I run any SAS code. For Example, I ran a code and it hits an error, I want to populate the dataset with error text and timestamp. Next time, I again run the code and this time it runs sucessfully, I want to populate the dataset with Error text as sucessfull.

I though of exporting SAS logs to text file and then importing that file to a dataset, but I want somewhat of a realtime approach where that log dataset keeps on updating with each code run.

Let me know if any more information is needed.

I am using SAS Studio

Thanks in advance!

Re: Creating a SAS Dataset basis SAS code run result

Reeza — Sun, 06 Oct 2019 22:56:55 GMT

Create a little macro that inserts the error message into the data set. Add triggers into your code.

How that %IF/%THEN is structured will vary from program to program, but hopefully gives you an idea.

%macro add_error(error_code = , error_message = );

proc sql;
insert into mydb.Error_Log
values(&error_code, &error_message);
quit;

%mend;

proc sql;
create table test as
select name, weight, height, error
from sashelp.class;
quit;

%if _SYSERR_ %then %add_error("Mistake1", "Check program at Part2");

Re: Creating a SAS Dataset basis SAS code run result

SASKiwi — Mon, 07 Oct 2019 02:50:35 GMT

I'm not a great fan of coding for job monitoring. You can get useful, but simple results by switching to running your code in SAS batch jobs via a job scheduler. The scheduler can automatically email you to tell you if a job was successful or not. Or you can monitor with the scheduler dashboard. Scheduling is as easy as clicking on selections in SAS Management Console.

Also the SAS option SYNTAXCHECK is set by default in batch mode and will immediately throw a job into syntax check mode when it hits an error so you only ever need to search for the first error in the job. That is pretty easy just with a text search as each batch job produces a SAS log file.

Read about this option here: https://documentation.sas.com/?docsetId=lesysoptsref&docsetTarget=n014qbvh3po8w5n1qlqbzr22vtg0.htm&docsetVersion=9.4&locale=en

Re: Creating a SAS Dataset basis SAS code run result

SAS_L — Thu, 10 Oct 2019 02:27:04 GMT

Thank You. I was able to use some part of this code in my solution and get it to work. Appreciate your help!