Hello! I am looking for help on a SAS program I have where I run multiple Proc Tabulate analysis for select counties via a macro. I would like to have all proc tabulate outputs for each county in an individual tab named as the county name. Currently it outputs to one tab and it is a lot of data to scroll through all the counties together. Sample data attached.   options orientation=portrait missing=0; ods listing close; ods html path="&path" file="&file";   %macro desc(location);   /*YTD TOTALS - COUNTY REPORTS*/ title1 "Cases of Disease in &location County, Year Total"; proc tabulate data=work.disease2 format=5.; where DiagAddress_County = "&location"; format sex $sex. evyear evyear. age agegrp. ; class evyear age sex / missing preloadfmt; tables evyear=' '*age=' ' all*evyear=' ',sex=' ' all/printmiss box='Age' rts=25; keylabel n=' ' all='Total'; run;   proc tabulate data=work.disease2 format=5.; where DiagAddress_County = "&location"; format sex $sex. evyear evyear. race2 $race. ; class evyear race2 sex / missing preloadfmt; tables evyear=' '*race2=' ' all*evyear=' ',sex=' ' all/printmiss box='Race' rts=25; keylabel n=' ' all='Total'; run;   proc tabulate data=work.disease2 format=5.; where DiagAddress_County = "&location"; format sex $sex. evyear evyear. ethnicity2 $ethnic.; class evyear ethnicity2 sex / missing preloadfmt; tables evyear=' '*ethnicity2=' ' all*evyear=' ',sex=' ' all/printmiss box='Ethnicity' rts=25; keylabel n=' ' all='Total'; run;   proc tabulate data=work.disease2 format=5.; where DiagAddress_County = "&location"; format sex $sex. evyear evyear. FacilityType $prvtype.; class evyear sex / missing preloadfmt; class FacilityType / order=formatted missing preloadfmt; tables evyear=' '*FacilityType=' ' all*evyear=' ',sex=' ' all/printmiss box='FacilityType' rts=25; keylabel n=' ' all='Total'; run;   %mend; %desc(CountyA); %desc(CountyG); %desc(CountyZ); ... View more

I am trying to rename the Break after Region to say Total instead of Region 11 repeated. I have tried using compute after but since I did that to rename the rbreak, it is not allowing me to use that twice. I have also tried to code within the same compute block, but it is not renaming the Region breaks to Total. Any suggestions?   Proc Report Code options missing=0; proc report data=work.syp1113 nowd; where year=2024; column region county month Total; define region / group 'Region' width=15 format=$regionfmt. order=data; define county / group 'County' width=20 format=$cntyfmt.; define month / across 'Month'  width=20 format=monthfmt. order=internal; define Total/computed;   compute Total;      Total=sum(_c2_, _c3_ ,_c4_, _c5_,_c6_,_c7_,_c8_,_c9_,_c10_,_c11_,_c12_,_c13_);   endcomp; break after Region /summarize style=[font_weight=bold]; rbreak after /summarize style=[font_weight=bold background=lightgrey]; compute after;   region='State'; endcomp; run;   Current Output I would like the second Region 11 to be named Total instead of repeating the Region name.   ... View more