Look in to the following code Filename _log_ "/home/re00627/test.log"; Data Log1; Infile _log_ truncover; input a_line $200.; /*If Substr(a_line,1,57) = 'Statement is not valid or it is used out of proper order.'*/ /**/ if index(a_line, 'Statement is not valid or it is used out of proper order.') > 0 then Do; /*index(a_line, 'WARNING') > 0*/ filename myfile email to= "mail_id" subject= "Error in Report" type= "text/plain" importance="HIGH"; data _null_; file myfile; put 'Dear User'; put; put 'Due to your selection you are getting this mail.'; put; put 'Please go with some short selction.'; run; End; This code is not working, Here can you help me with some other option. If I am using, neither the index function is working nor SUSTR, if you have some easy solution please let e know.   ... View more

I am working in SAS EG, and I am running some prompt related to this report through DI studio. But if I want to run the code only from EG, above sort of code I am using, but not able to specify the error text. My aim is to specify the error text in the code, and to get mail respect that error only from the log...   If there any possibilities that we can mention the error text in the condition or in the loop, instead of any error code no, please let me know, I am chasing for this issue for long time, I need one permanent solution on this...     Regards Sourav ... View more

I am still looking for the solution here, ... View more

I will be so grateful, If will get some quick help on this. ... View more

Actually I want to scan the log from that path, and then if error will be there, respect to some specific error like "Statement is not valid or it is used out of proper order"(suppose) then it will shoot one mail to me or user.   Note: I want to specify the error test in the condition. Not for all error.   I have used another sort of code. Here can we do anything? Options obs=max nosymbolgen nomlogic nomprint; %INCLUDE "/home/name/Test.sas"; %Let Joblog = /home/name/; %Let Jobdate = &sysdate9.; %Let Jobname = RUN_LoadTB_Refresh; %LOGCHECK(&joblog.&JOBNAME._&jobdate..log,name); run;   Please help me.   Thanks Regards Sourav ... View more

Dera Linus   Thanks for the documentation. You are correct, I am creating Di for STP process. My scenario is like if I will get any error in SAS code and I will some mail to customer related to that error, I need when the ETL job will run. In the portal page some popup window will appear where it will be written that mail sent to customer. Can we that through DI beside creating STP.     Thanks     Regards Sourav ... View more

Hi guys,   I have small query. Like there in SYSERR we are mentioning 0 or other. Is there any way we can mention the error text instead of error code to specify the error in If statement or any other condition. I want to get mail only if that error text will arrive like for example "you are running out of memory". Only if this error will come, then I will get mail. Any solution, it will be helpful for me.   Thanks, Regards Sourav ... View more