proc sort data=sashelp.baseball out=baseball; by league division; run; proc freq data=baseball; tables team/nocum out=base; by league division; run; proc sql; create table d as select league, division, sum(Count) as totalplayers from base group by league, division; quit; proc sql noprint; select totalplayers into :n1 - :n4 from d order by league, division; quit; %put &n1 &n2 &n3 &n4; data base1; merge base d; by league division; count_percent=strip(put(count,best.))||"("||strip(round(percent,0.01))||")"; abbre=substr(league,1,1)||substr(division,1,1); run; proc sort data=base1; by team; run; proc transpose data=base1 out=base2; by team; var count_percent; id abbre; run; data base3; set base2; if missing(NE) then NE="0(0.00)"; if missing(NW) then NW="0(0.00)"; if missing(AE) then AE="0(0.00)"; if missing(AW) then AW="0(0.00)"; run; proc report data=base3 headskip headline nowd center split='*'; column Team gap ("National" NE NW ) ("American" AE AW ); define Team/ "Teams" ; define gap / ' ' style={cellwidth=0.75in}; define NE/ "East*(N=&n3)"; define NW/ "West*(N=&n4)"; define AE/ "East*(N=&n1)" ; define AW/ "West*(N=&n2)" ; run; ... View more

data s; set sashelp.heart; run; proc sort data=s; by status; run; proc freq data=s; table status/nocum out=x; run; proc sql; select count into :n1 - :n2 from x order by status; run; %put &n1,&n2; proc means data=s N mean median std min max; var weight; class weight_status; by Status; output out=outp; run; data s2; set outp(drop=_type_ _freq_); if missing(status) or missing(weight_status) then delete; run; proc means data=s N mean median std min max; var Diastolic; class bp_Status; by status; output out=outp1; run; data s3; set outp1(drop=_type_ _freq_); if missing(status) or missing(bp_status) then delete; run; proc transpose data=s3 out=s4; by status BP_Status ; var Diastolic; /*id abbre;*/ run; proc transpose data=s4 out=s5; by status _name_; var COL1 col2 col3 col4 col5; /*id abbre;*/ run;   proc report data=base3 headskip headline nowd center split='*'; column Category Summary_statistics ("Dead" ND ) ("Alive" NA ); define Category/ "Category" ; define ND/ "East*(N=&n2)"; define NA/ "West*(N=&n1)"; run; ... View more