Hello sas community, I hope you are doing well. Please i wanna optimise this part of code can you help because i dont use much the if and do .... /* Union results base */ proc sql; create table lib.globsin_rc_union_&suffixe as select 2010 as vision, a.* from lib.glob_sin_rc_0910 as a /* A modifier */ union all select 2011 as vision, a.* from lib.glob_sin_rc_0911 as a union all select 2012 as vision, a.* from lib.glob_sin_rc_0912 as a union all select 2013 as vision, a.* from lib.glob_sin_rc_0913 as a union all select 2014 as vision, a.* from lib.glob_sin_rc_0914 as a union all select 2015 as vision, a.* from lib.glob_sin_rc_0915 as a union all select 2016 as vision, a.* from lib.glob_sin_rc_0916 as a union all select 2017 as vision, a.* from lib.glob_sin_rc_0917 as a union all select 2018 as vision, a.* from lib.glob_sin_rc_0918 as a union all select 2019 as vision, a.* from lib.glob_sin_rc_0919 as a union all select 2020 as vision, a.* from lib.glob_sin_rc_0920 as a order by vision,exe; quit; Thanks regards
... View more
