Hi All,
I am running one SQl query. The data is containing only ~90k observations. However, the code keeps on running without going to the next step. Can anybody suggest way to speed up the code. Below attached is the query which I am running:
proc sql;
create table nr&otfile as
select a.*,b.bucket as bucket_tmp,b.cur_bal as cur_bal_tmp,
b.tot_prin as tot_prin_tmp,b.ac_no as ac_tmp
from ajmb2.nr&otfile a left join ncir&otfile b
on a.ac_no = b.ac_no;
quit;