proc sql;
create table big4 as
select distinct
case when a.Dadtunit contains "安永" or "普华"  or "德勤"  or "毕马威" then 1 else 0 end as big4
from
        feiyong_leixing as a
        left join
        kehufengxian as b on a.stkcd =b.stkcd and a.accper=b.accper
        order by stkcd;
quit;