@fyuksel: If I understand your question correctly, what you want is something like this: proc sql;
create table want as select
year,
count(*) as no_of_firms,
sum(DVC>0) as dividend_payers,
calculated dividend_payers/calculated no_of_firms as pct_dividend_payers format=percent6.2,
sum(sharerepur>0) as repurchasers,
calculated repurchasers/calculated no_of_firms as pct_repurchasers format=percent6.2
from have
group by year
order by year
;
quit;
... View more
