I added &syserr after quit it gave me proper error code but still &syserrortext doesn't work Thanks ... View more

This is what I am trying to do: 1. Create Log file say logfile.txt 2. I run a sas code to fetch all reject details from sas or Orcale table using proc sql 3. Before proc sql begins I will write/append a plain normal string into my logfile.txt saying that "Step:1 Begin of ZZZZZZ" and same for at end of the proc sql 4. Purpose of this is track all codes log in single file, for example any of the table got deleted accidentally I will get get an "not exist error", i need to track this error in my logfile.txt, and to do so I did like  %processorlogger(Step:2 End of noofdaysin_reject at &SYSERR &SYSERRORTEXT %sysfunc(datetime(),datetime24.3));  at syserrortext I am getting a warning says "Apparent symbolic reference SYSERRORTEXT not resolved"   I am getting the proper error code 1012 for syserr and it gets appends into the file but syserrortext doesn't.., Please note if &syserror was given without quitting proc sql syserr code will be always 0 which is success, so for precise error syserror should be given after quit like below   proc sql; select * from DZ.noofdaysin_re  /* this is mispelled table */ run; quit; %put SYSERR = &SYSERR; %put SYSERRORTEXT = &SYSERRORTEXT;   Hope I made my point clear..!!      ... View more

I am trying to achieve to add step by step logger on my each Proc sql select statement, I was able to do that by below code, I couldn't append syserrortext in to the file %macro processlogger(msg); data _null_; file '../Processlog/processlog.txt' mod; length message $32767 ; message=symget('msg'); put message ; run; %mend; %processlogger(Starting at %sysfunc(datetime(),datetime24.3)); Proc SQL; select * from DZ.Table_name run; %put SYSERR = &SYSERR; /* If I add this I am getting warning */ %put SYSERRORTEXT = &SYSERRORTEXT; Apparent Symbolic reference SYSERRORTEXT not resolved /* here I have to append error text also in my file */ %processlogger(Ending at SYSERR,SYSERRORTEXT %sysfunc(datetime(),datetime24.3));   ... View more

Thanks this is an excellent solution.., I have a question in writing file??   libname DZ 'Dataset'; %macro dummy2(value); proc sql; select * from DZ.HighV_Trans /* misspelled */  run; %if &value=3 %then %goto error; %else %goto exit; %error: /* here how do I write error in this file??  */ proc export data = ?? outfile ="C/Pradeep/Log.txt" /*dbms = csv replace;*/ run; %Put the value of value is &value; %exit: %mend; %dummy2(3); %dummy2(5);     ... View more