Hi all, Please i think i need help here. I Have a proc sql code running for more than 4 hours to give me an output. the dataset on the left (Base0) has only 1 million rows, but Base2 is a remote dataset in a global repository. PLEASE why does it takes so long to execute (4 hours) ? How can it be optimized ? NB Note than the key variable doesnt have the same structure in both dataset. Thanks   proc sql; create table lib1.Base1 as select a.*, b.DW_DATE_KEY, b.SERVICE_CLASS, b.TOTAL_VOICE_AMT,b.TOTAL_DURATION, b.NB_CALLS, b.NB_CALLS_ONNET, b.NB_CALLS_OFFNET,b.NB_CALLS_INTERNATIONAL, b.VOICE_AMT_ONNET,b.VOICE_AMT_OFFNET,b.VOICE_AMT_INTERNATIONAL, b.VOICE_DUREE_ONNET,b.VOICE_DUREE_OFFNET , b.VOICE_DUREE_INTERNATIONAL, b.MA_VOICE_USED, b.BONUS_VOICE_USED from lib1.Base0 as a left join lib2.Base1(where =(DW_DATE_KEY >= 20160516 and DW_DATE_KEY <=20160630)) as b on a.msisdn =(input(b.msisdn, best12.)-237000000000); quit; ... View more