proc sql;create table a as

select Stkcd,`year`,max(invest)/min(A001000000) as new_columns
from
(select Stkcd, left(Accper,4) as `year`,Accper,A001000000,invest from Work.test)a
group by Stkcd,`year`;
quit;