proc tabulate data = ghpb11;
class ent2 INS3 filingsize;
TITLE 'Table A5. Selected Expenses of Group Health Plans';
title2 'by type of insurance and type of plan, 2011';
title3 '(numbers in millions)';
var 
tot_distrib_bnft_AME distrib_drt_partcp_AME ins_carrier_bnfts_AME ioh_ben
tot_admin_expenses_AME professional_fees_AME contract_admin_fees_AME invst_mgmt_fees_AME IOH_AEXP;
where filingsize2 ne '2';
table all='All Plans with Trusts' filingsize=' ', 
(tot_distrib_bnft_AME='BENEFIT PAYMENTS'
distrib_drt_partcp_AME='Directly to participants or beneficiaries (including rollovers)'
ins_carrier_bnfts_AME='To insurance carriers for the provision of benefits'
ioh_ben='Other'
tot_admin_expenses_AME='ADMINISTRATIVE EXPENSES'
professional_fees_AME='Professional fees'
contract_admin_fees_AME='Contract administrator fees'
invst_mgmt_fees_AME='Investment advisory and management fees'
IOH_AEXP='Other')*sum=' '*f=m12f., 
(all='Total' INS3=' ')*(all='Total' ent2=' ')/MISSTEXT='-';
footnote;
run;
