Hi, I am trying the below but it is not working. I am not getting any data. please suggest. data child_id; infile "$inbound_path/program_child_id.txt" dlm=","; input id :$11. @@; run; proc sql; select * into :child separated by ',' from child_id; quit; create table x as select * from connection to oracle (select a.*, b.* from table1 a, table2 b where a.program_id in (&program) and trim(a.program_child_id) in ('&child') and a.program_id = b.program_id and a.program_child_id = b.program_child_id );
... View more