PROC TABULATE DATA=ghpb11 NOSEPS MISSING ORDER=DATA ;
CLASS ENT2 health_type / PRELOADFMT MLF;
LABEL SUBTL_ACT_RTD_SEP_CNE="Total Participants End of Year (thousands)"
	  TOT_ACTIVE_PARTCP_CNE="Active Participants End of Year (thousands"
	  TOT_ASSETS_EOY_AME="Total Assets (millions)"
	  TOT_CONTRIB_AME="Total Contributions (millions)"
	  TOT_DISTRIB_BNFT_AME="Total Benefits (millions)";
VAR TOT_ACTIVE_PARTCP_CNE TOT_ASSETS_EOY_AME SUBTL_ACT_RTD_SEP_CNE TOT_ACTIVE_PARTCP_CNE;
VAR TOT_CONTRIB_AME TOT_DISTRIB_BNFT_AME;
TITLE 'Table A1.  Number of Group Health Plans, Total Participants, Active Participants,';
TITLE2 'Assets, Contributions, and Benefits';
TITLE3 'by type of plan and type of insurance, 2011';
TITLE4 'All Plans';
KEYLABEL ALL='Total';
TABLE ALL health_type=' ', 
    N='Number of Plans'*F=COMMA13. (SUM=' '*(SUBTL_ACT_RTD_SEP_CNE TOT_ACTIVE_PARTCP_CNE))*F=K13F.
	SUM=' '*(TOT_ASSETS_EOY_AME TOT_CONTRIB_AME TOT_DISTRIB_BNFT_AME)*F=M13F. / 
    RTS=41 Box='Type of Plan'  MISSTEXT='-';

RUN;

PROC TABULATE DATA=ghpb11 NOSEPS MISSING ORDER=DATA;
where INS3=0;
CLASS ENT2 health_type / PRELOADFMT mlf;
LABEL SUBTL_ACT_RTD_SEP_CNE="Total Participants End of Year (thousands)"
	  TOT_ACTIVE_PARTCP_CNE="Active Participants End of Year (thousands"
	  TOT_ASSETS_EOY_AME="Total Assets (millions)"
	  TOT_CONTRIB_AME="Total Contributions (millions)"
	  TOT_DISTRIB_BNFT_AME="Total Benefits (millions)";
VAR TOT_ACTIVE_PARTCP_CNE TOT_ASSETS_EOY_AME SUBTL_ACT_RTD_SEP_CNE TOT_ACTIVE_PARTCP_CNE;
VAR TOT_CONTRIB_AME TOT_DISTRIB_BNFT_AME;
TITLE 'Table A1.  Number of Group Health Plans, Total Participants, Active Participants,';
TITLE2 'Assets, Contributions, and Benefits';
TITLE3 'by type of plan and type of insurance, 2011';
TITLE4 'Self-Insured';
KEYLABEL ALL='Total';
TABLE ALL health_type=' ', 
    N='Number of Plans'*F=COMMA13. (SUM=' '*(SUBTL_ACT_RTD_SEP_CNE TOT_ACTIVE_PARTCP_CNE))*F=K13F.
	SUM=' '*(TOT_ASSETS_EOY_AME TOT_CONTRIB_AME TOT_DISTRIB_BNFT_AME)*F=M13F. / 
    RTS=41 Box='Type of Plan'  MISSTEXT='-';

RUN;

PROC TABULATE DATA=ghpb11 NOSEPS MISSING ORDER=DATA;
where INS3=1;
CLASS ENT2 health_type / PRELOADFMT mlf;
LABEL SUBTL_ACT_RTD_SEP_CNE="Total Participants End of Year (thousands)"
	  TOT_ACTIVE_PARTCP_CNE="Active Participants End of Year (thousands"
	  TOT_ASSETS_EOY_AME="Total Assets (millions)"
	  TOT_CONTRIB_AME="Total Contributions (millions)"
	  TOT_DISTRIB_BNFT_AME="Total Benefits (millions)";
VAR TOT_ACTIVE_PARTCP_CNE TOT_ASSETS_EOY_AME SUBTL_ACT_RTD_SEP_CNE TOT_ACTIVE_PARTCP_CNE;
VAR TOT_CONTRIB_AME TOT_DISTRIB_BNFT_AME;
TITLE 'Table A1.  Number of Group Health Plans, Total Participants, Active Participants,';
TITLE2 'Assets, Contributions, and Benefits';
TITLE3 'by type of plan and type of insurance, 2011';
TITLE4 'Mixed-Insured';
KEYLABEL ALL='Total';
TABLE ALL health_type=' ', 
    N='Number of Plans'*F=COMMA13. (SUM=' '*(SUBTL_ACT_RTD_SEP_CNE TOT_ACTIVE_PARTCP_CNE))*F=K13F.
	SUM=' '*(TOT_ASSETS_EOY_AME TOT_CONTRIB_AME TOT_DISTRIB_BNFT_AME)*F=M13F. / 
    RTS=41 Box='Type of Plan'  MISSTEXT='-';

RUN;

PROC TABULATE DATA=ghpb11 NOSEPS MISSING ORDER=DATA;
where INS3=2;
CLASS ENT2 health_type / PRELOADFMT mlf;
LABEL SUBTL_ACT_RTD_SEP_CNE="Total Participants End of Year (thousands)"
	  TOT_ACTIVE_PARTCP_CNE="Active Participants End of Year (thousands"
	  TOT_ASSETS_EOY_AME="Total Assets (millions)"
	  TOT_CONTRIB_AME="Total Contributions (millions)"
	  TOT_DISTRIB_BNFT_AME="Total Benefits (millions)";
VAR TOT_ACTIVE_PARTCP_CNE TOT_ASSETS_EOY_AME SUBTL_ACT_RTD_SEP_CNE TOT_ACTIVE_PARTCP_CNE;
VAR TOT_CONTRIB_AME TOT_DISTRIB_BNFT_AME;
TITLE 'Table A1.  Number of Group Health Plans, Total Participants, Active Participants,';
TITLE2 'Assets, Contributions, and Benefits';
TITLE3 'by type of plan and type of insurance, 2011';
TITLE4 'Fully-Insured';
KEYLABEL ALL='Total';
TABLE ALL health_type=' ', 
    N='Number of Plans'*F=COMMA13. (SUM=' '*(SUBTL_ACT_RTD_SEP_CNE TOT_ACTIVE_PARTCP_CNE))*F=K13F.
	SUM=' '*(TOT_ASSETS_EOY_AME TOT_CONTRIB_AME TOT_DISTRIB_BNFT_AME)*F=M13F. / 
    RTS=41 Box='Type of Plan'  MISSTEXT='-';

RUN;
