As much as I see you are repeating same lines few times except the COMPUTE argument. you can define: %macro comp(arg); compute &arg; If _name_='Application' then call define(_col_,'format','comma20.0'); If _name_='CreditAR' then call define(_col_,'format','percent8.1'); if _name_= 'JudgmentalAR' then call define(_col_,'format','percent8.1'); if _name_= 'Referral % ' then call define(_col_,'format','percent8.1'); endcomp; %mend common_lines; Then change your code to: Proc report data=final contents=" " nowd split='\' .... enter your code here upto ... %comp(year2015); %comp(year2016); %comp( Num_of_Variance); %comp(mature2015); %comp( Num_of_Variance2); RUN;
... View more