Hello, everybody !   I'm trying to develop a code  to identify a empty table and update another table " type of control table" with a information in specific field, after stop the process or depending run the process normally. But something happen in the update step that this code doesn't work sucessfully. Could anybody help in this task, please?   Accordin SAS code below: data work.tasktable; * to simulating a empty source table*; format orig_info_1 $ 1.; format orig_info_2 $ 1.; format dt_carga DDMMYY10.; run; data work.logtable; * to simulating a control table*; format process_nm $ 7.; format msg_log $ 30.; format load_dt DDMMYY10.; process_nm="ABCD123"; load_dt=today( ); put load_dt=ddmmyy10.; RUN; ******** Assigning macro variables **********************; options mprint; %let ttbl=work.tasktable; %put tab_de_trabalho=&ttbl; %let fnsh=EOF; %put end_of_file=&fnsh; %let load_dt=%sysfunc(PUTN( %sysfunc(today()), ddmmyyS10.)); %put load_date=&load_dt; %let load_tt=%sysfunc(PUTC(%sysfunc(today()),$10.)); %put load_date_char=&load_tt; *SAS date in char format*; %let ltbl=work.logtable; %put log_table=&ltbl; %let var1='XPTO567'; %put system_name=&var1; %let var2='empty_source_file'; %put error_message=&var2; DATA _NULL_; FORMAT END $3.; SET &ttbl END=&fnsh; BY dt_carga; IF END=&fnsh AND _N_ LE 1 AND orig_info_1=' ' THEN /* testing the condition of empty table*/ call execute ('data &ltbl;set &ltbl;format process_nm $ 7.;if &load_tt=put(today(),$10.) and process_nm=&var1 and INDEX(msg_log," ") GE 1 then msg_log=%str(&var2);run;'); *update a character value in msg_log colunm*; IF END=&fnsh AND _N_ LE 1 AND orig_info_1=' ' THEN call execute ('data_null_;STOP;run;'); *stop the process*; IF END=&fnsh AND _N_ LE 1 AND orig_info_1 NE ' ' THEN call execute ('data_null_;output="OK";run;'); *else output=ok "do nothing" *; RUN;   ... View more