Hi,    I have a question changing this 'data step' procedure to 'proc sql' procedure.   Data Step Procedure: ('num_rec_prop' is a parameter that I have set and called)   data Process_Step_Error_Log; if &num_rec_prop NE 1 then do; Step_ID = 001; Error_Code = 'AEE001'; end; else do; Step_ID = 002; Error_Code = 'SUC001'; end; output; run;   However, when I change this procedure into 'proc sql' and uses macro function. The reason is if there is an error, another table needs to be updated as well (PROC_STEP_LOG, and this table exists initially)   I create an empty table first: data Proc_Step_Error_Log; input Step_Id 10 Error_Code $10; datalines; run; Then, I use the following macro procedure: (proc_log_id is read and called before as well)  %macro etl_error_log; %if &num_rec_prop NE 1 %then %do; insert into Proc_Step_Error_Log set Step_Id = 001 , Error_Code = "AEE001"; update PROC_STEP_LOG set proc_step_end_ts = datetime() , proc_step_stat_cd = "Failed" , lst_updt_ts = datetime() where proc_log_id = &proc_log_id; %end; %else %do; insert into Proc_Step_Error_Log set Step_Id = 002 , Error_Code = "SUC001"; %end; %mend; %etl_error_log;   If I ran this part, error message shows up: ERROR 180-322: Statement is not valid or it is used out of proper order. (Highlight on the word 'insert')   How could I fix my code to run successfully?   Thank you!  ... View more

Hi,   I have a question on setting a check point within the SAS code. This check point could decide if later procedures will run or stop.    The code has 10 input tables: Table1, Table2, ..., Table10.    Later procedures will run if Table1 through Table10 they all have observations (not empty). Later procedure will stop if any one of Table1 through Table10 is empty.    I know the following code could check whether the table is empty or not for 1 table:   Proc Sql noprint; Select * from Table1; Quit; put *&sqlobs*; if &sqlobs > 0 then do; ... else do; end; How could I apply similar procedure to 10 tables? Is there any simple way?    Thank you! ... View more

Hi,   I have table_1 with columns (A, B, C, D, E).  For the rows within table_1, I would like to select rows of data where A, B, C are unique, but I also plan to keep information for D & E.  How can I do this?   Will this one work?  Proc Sql;    Create Table table_2 as select * from table_1        left join        (select distinct A, B, C from table_1) m    on table_1. A = m.A and table_1.B = m.B and table_1.C = m.C; Quit;   Thank you!  ... View more