Hello Experts,
My code is :
proc sql;
create table test as select distinct
ev0_2.POLICE,
ev0_2.SUPPORT,
ev0_2.SUPPORT2,
ev1.EFFET as EF
from
(select ev0.NO_POLICE, sup.SUPPORT,sup.SUPPORT2
from EVEN ev0 inner join SUPPORT sup on ev0.SUPPORT=sup.SUPPORT ) ev0_2
left join EV ev1 on ev0_2.POLICE=ev1.NO_POLICE and ev0_2.SUPPORT=ev1.SUPPORT;
quit;
Firstly, I would like to check the common observation from the table EVEN and SUPPORT and after I would like the observation with left join. Could you please check if my code is right beacause my programme is looping.
Thank you !
... View more